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 | | Popular White Papers In the Spotlight Visit IBM's Leveraging IT Services Briefing Center. Register now and learn how to deliver smarter security & resiliency. _.____.__ |