Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from LCC352 on Feb 15 at 9:35 AM Hello, Ja - I'm not sure you have "duplicate line items". What you absolutely WILL have is the same information repeated in every line followed by a different ZNOTE detail value, until something else (VBFA value, VBELN value, etc) changes. So if table 1 has a single value followed by 5 lines each with 10 ZNOTE entries, you'll have 50 lines where the table 1 value repeats. The first of the 5 lines will repeat 10 times, etc.
If you wish to do more of what Horacio suggests in the look of the query, you could play with the header text of the query so that the table 1 value is held, then the first table 2 value is held, followed by the 10 lines of table 3. Do that by doing a sort on the first and second table values. SAP will automatically give you header and footer entries for those items. Delete the footers but keep the headers.
I hope that helps.
- Lou
| | | ---------------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.   _.____.__ |
