Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from horacio zapettini on Feb 15 at 6:43 AM Ja,
You should have more clear what you want to show.
What is exactly what you want to show? What are the duplicate entries you want to remove?
Do you want to show something like this?
-> Vbap Vbeln-Posnr
-->> VBFA Vbeln -posnr line1
-->>> Zxxxx Vbeln -posnr line1 position 1
->>> Zxxxx Vbeln -posnr line1 position 2
->>> Zxxxx Vbeln -posnr line1 position 3
-->> VBFA Vbeln -posnr line2
-->>> Zxxxx Vbeln -posnr line2 position 1
-->>> Zxxxx Vbeln -posnr line2 position 2
-->> VBFA Vbeln -posnr line3
-->> VBFA Vbeln -posnr line4
-->> VBFA Vbeln -posnr line5
>>> Zxxxx Vbeln -posnr line5 position 1
-->>> Zxxxx Vbeln -posnr line5 position 2
->>> Zxxxx Vbeln -posnr line5 position 3
->>> Zxxxx Vbeln -posnr line5 position 4
->>> Zxxxx Vbeln -posnr line5 position 5
-> Vbap Vbeln-Posnr2
...
BTW, IMO SQVI is not the tool you need. Go for a report! (at most, go for sq01-sq02 where you'd have more control on the way the information is being retrieved...)
HTH
Horacio
| | | ---------------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. __.____._ |   _.____.__ |
