Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from Ja on Feb 15 at 5:59 AM Hi Srikanth
Can you please explain this bit.
| | | ---------------Original Message---------------
From: Ja
Sent: Friday, February 15, 2013 4:50 AM
Subject: Query using SQVI - Repeat Line Items
Hi
I'm trying create a simple query using 3 tables. all these 3 table having VBELN and POSNR fields as common.
table 1 - shows sales order details - VBAP
table 2 - shows billing details - VBFA
table 3 - shows transfer note details - Zxxxx
table 1 - having one entry for the selected VBELN and POSNR
table 2 - let's say having 5 entries for VBELN and POSNR
table 3 - having 10 entries for VBELN and POSNR
my requirement is to create a report which should covers VBELN / POSNR wise sales / billing and transfer note details in to a single report.
but when I linking these 3 tables the results shows me with duplicate entries.
please help me to avoid these duplicate entries.
Thanks in advance
Ja |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
