Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SAP query in SQ02

Former Member
0 Kudos

Good afternoon,

I made a query, and this is to return everything I need, but doubling this

lines, each row is always displayed twice. It is possible in

SQ02 put some sort of code to be displayed only one line?

Best regards,

António Pinho

2 REPLIES 2

madhu_vadlamani
Active Contributor
0 Kudos

HI Teixeira1,

First check why two entries is coming. Check how you joined the tables. Please tell what and tables you joined.

Regards,

Madhu.

Jelena
Active Contributor
0 Kudos

This is dictated by the JOIN. You'll need to find out which field is causing "duplicates" and either change the join or add the condition to eliminate "duplicates" (these are not really duplicates, they just appear that way). Sometimes JOIN cannot be changed and the table data has to be added as an 'additonal table' (in Extras). I ran into this once when there was a complex criteria needed to get the sales order schedule lines (VBEP).