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 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.
 
__.____._
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
srikanth_120  
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Have an SAP Question? Ask Your Peers at Toolbox for IT

_.____.__

0 comments:

Post a Comment

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