Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from srikanth_120 on Feb 15 at 5:08 AM Hi Ja
Check join conditions...delete duplicate common fields.among the 3 tables.
| | | ---------------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. __.____._ |   _.____.__ |
