Eliminating duplicate records using SQ02

[Former Member]

Hi All,

I have created a infoset using SQ02. In which, the resultset results in duplicate records. I want to eliminate the duplicate records. I searched in the forum, still didn't get any proper answer.

Anyone can help me in this regard?

[Former Member]

Hi All,

I have created a infoset using SQ02. In which, the resultset results in duplicate records. I want to eliminate the duplicate records. I searched in the forum, still didn't get any proper answer.

Anyone can help me in this regard?

[Former Member]

there is a place to write abap code in the application tool bar buttons. put the code to delete duplicate entries.

[Sandra_Rossi]

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)

[Former Member]

Hi Sandra,

Thank you very much for your reply. I had gone through this help link (not blog). I find difficult to do the ABAP code in SAP Query since I am very much out of box in this area.

In case, if you have any other link/tutorial in this area, please reply back to me. My need is to delete all the duplicate rows in the SAP Query. I have created an infoset using table join.

Thanks

Kumaresh

[Former Member]

kumar,

do one thing. check on what basis the records are different, take that into account while selecting

[Former Member]

Hi,

I am trying to download the production orders along with the status. Since each production order has more than one status at a single point in time and during join conditions with two tables AUFK and JEST, it is retrieving the duplicate records. And this status field is to be in the filter fields, not in the selection fields.