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,
Rajiv. |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| | Popular White Papers
In the Spotlight Visit IBM's Leveraging IT Services Briefing Center. Register now and learn how to deliver smarter security & resiliency.  _.____.__ |
