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 Ja on Feb 15 at 6:11 AM
HI Srikanth

thanks for quick reply, can you please elaborate this bit?

---------------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
Ja  
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Toolbox.com for iPhone & Android: Ask Questions & Get Answers Anywhere. Download the Free App

_.____.__

0 comments:

Post a Comment

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