Skip to Content
avatar image
Former Member

duplicate record

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 ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 09, 2008 at 10: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 ?

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 09, 2008 at 10: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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 09, 2008 at 10: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..

    Add comment
    10|10000 characters needed characters exceeded