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

Posted by LCC352 (Sr. Mgr, ERP/Financial Systems)
on May 25 at 8:39 AM
By virtue of the multiple keys involved in the tables you list, unless you "know all the answers" to the secondary keys, you almost can't avoid duplicates with a straight join. Anything that has more than one row in the sales order/line item/secondary key combination is going to produce a duplicate. If this is being done in ABAP, I would start with gathering the data from VBAP and VBAK, then move to gathering the other data into internal tables based on the internal table created from VBAP/VBAK. Weed through the data in loop statements deleting anything in the internal table that doesn't fit the criteria you may have, and then process the rest. - 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,

Copyright © 2011 and message author. 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.