SQ01 query with identical lines

[s_v15]

I have an issue where existing queries which have worked fine before, but now display identical lines randomly. I am not able to figure out any specific reason why a specific line is repeated again with the same data. these queries are by document number and the exact same document number is displayed in these queries.

The issue is with many SAP queires some of which have worked fine in the past.

Any hints will be highly appreciated.

[andrs_sarcevic]

It might be related to one of your JOIN conditions in the Query... Check if you are getting duplicates because a key field is not being populated or something like that.

Cheers,

Andres.

[s_v15]

I have had this isuse in the past when I developed a different query. This is the first thing I checked to make sure there is not a primary key that is leftout causing the issue, So that is ruled out

These are table joins but nothing too complicated and I could not find any reason why a random line is duplicated for no reason.

[Shafiq_Rehman]

It may be the way joins are setup, for example in your query you may have may have emergency address, mailing address, etc but you are not displaying addresses in query, when you run the query it will display duplicate records because you are just not displaying the addresses but they are in the JOIN.

[JeevanSagar]

If a "random" line is duplicated it means that the document has been changed or one of the items in the documents is deleted but SAP (business transaction) didn't delete it from database table (just marked it for deletion). You need to examine one of those duplicated using SE16N and see if the duplicates appear in the SE16N also and use the "flag for deletion" field in the selection screen and exclude them before executing the report.

[Former Member]

Hi,

http://wiki.sdn.sap.com/wiki/display/ERPHCM/Duplicatelinesdonotdisplayedinquery%28Ex.Infotype0015,0014%29

hope this is useful

Regards

kk