duplicate record

[Former Member]

Hi

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 ?

[former_member186143]

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

[Former Member]

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..

[Former Member]

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

how to delete next one ?

[Former Member]

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

[former_member186143]

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