2008 Sep 09 11:32 AM
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 ?
2008 Sep 09 11:59 AM
there are two entries in my BKPF table thats why its comming twice.. but i want only one ..
how to delete next one ?
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 ?
2008 Sep 09 11:35 AM
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
2008 Sep 09 11:44 AM
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..
2008 Sep 09 11:59 AM
there are two entries in my BKPF table thats why its comming twice.. but i want only one ..
how to delete next one ?
2008 Sep 09 12:03 PM
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
2008 Sep 09 12:26 PM
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
| User | Count |
|---|---|
| 6 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |