Trupti is right. Create the Query and you can join the unique field to table
| | | ---------------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 _.____.__ |