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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Remove Duplicatr data from ABAP quere (SQ02)

Former Member

‎04-21-2011 10:17 AM

0 Kudos

Hi experts,

I built a ABAP query by joining more then 5 tables using tcode SQ02.

when I run the query by SQ01 I found some duplicate row which is need to remove.

How can I remove those duplicate row from my Query or infoset.

Rayhan

3 REPLIES 3

former_member184632
Participant

‎04-27-2011 6:51 AM

0 Kudos

Hi Rayhan,

You cannot simply eliminate duplicate records (otherwise use abap), you must add a selection on selected records.

For adding ABAP, [read sap library - infoset - abap code|http://help.sap.com/saphelp_nw2004s/helpdata/en/d2/cb4504455611d189710000e8322d00/frameset.htm] and blog 13838 (it uses another abap exit, but it may help you to see how it works)

Thanks ,

Vishall

Former Member
In response to former_member184632

‎05-11-2011 9:19 AM

0 Kudos

Thanks

Former Member

‎04-27-2011 11:02 AM

0 Kudos

Hi,

this is not the forum for queries but if you have duplicate records it is because the joining conditions are not correct or the database tables have duplicate records.

The selection on records could not be very helpful, as suggested by Vishall, if you still have an error in your selection/joining conditions.