topic duplicate record in Application Development and Automation Discussions

duplicate record

Former Member — Tue, 09 Sep 2008 10:32:06 GMT

In my SQ01 Query i have two duplicate records,

i want to delete one duplicate record .

I have used Logical data SDF.

how to find code for it and how to wirte code in SQ01 ?

Re: duplicate record

Former Member — Tue, 09 Sep 2008 10:35:33 GMT

perhaps check all the key relations you have in the query. perhaps you missed a key to declare or there are duplicate and legitemate records in a linked table

kind regards

arthur de smidt

Re: duplicate record

Former Member — Tue, 09 Sep 2008 10:44:37 GMT

if in the Query while mapping if all the key fields are been used, no duplicates would occur. There might be some key missing due to which the duplicates are occurring..

Re: duplicate record

Former Member — Tue, 09 Sep 2008 10:59:54 GMT

there are two entries in my BKPF table thats why its comming twice.. but i want only one ..

how to delete next one ?

Re: duplicate record

Former Member — Tue, 09 Sep 2008 11:03:27 GMT

HI,

Being a dadabase table, how could BKPF contain duplicate entry? Check the key entry of them. In SAP , no datatable can contain duplicate entry.

Regards,

Anirban

Re: duplicate record

Former Member — Tue, 09 Sep 2008 11:26:16 GMT

and are you aware that BKPF is a multiple key table !! so you have to fill all the keys in the selection or link all the keys ! if you want to get 1 record back