We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-dev] Query using SQVI - Repeat Line Items

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

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.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2013 Ziff Davis, Inc. and message author.
Ziff Davis, Inc. 28 E 28th Street New York, NY 10016
LCC352  

President
19 achievements
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Become a blogger at Toolbox.com and share your expertise with the community. Start today.

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language