RE:[sap-log-sd] How to join tables VBAK,VBAP,VBREVE,VBREVK,VEDA

Posted by LCC352 (Sr. Mgr, ERP/Financial Systems)
on May 31 at 9:23 AM
Rajiv,

Given the tables you say you need to join, there is no one way to join them so that you will not get duplicates. You have to attack the tables one at a time after the initial pull from VBAK/VBAP and figure out which records you really want based on the data you see coming from the database. Maybe you need a field on one of the other tables that is duplicating, but it's the same value in each row in the other table. If that's the case, you can take one value and throw the rest away.

I hope that helps. - Lou

---------------Original Message---------------
From: rajivvarma
Sent: Tuesday, May 24, 2011 6:03 AM
Subject: How to join tables VBAK,VBAP,VBREVE,VBREVK,VEDA

Hi Experts,

I have requirement to use VBAK,VBAP,VBREVE,VBREVK,VEDA.Could you please tell me how to join these tables in right manner to avoid duplicates.

I have tried linking all the tables to VBAK but it is creating duplicates so please guide me right join condition to use these tables.

Thanks & Regards,
Rajiv.

__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
Popular White Papers

In the Spotlight
Visit IBM's Leveraging IT Services Briefing Center. Register now and learn how to deliver smarter security & resiliency.
_.____.__