cancel
Showing results for 
Search instead for 
Did you mean: 

doubt

Former Member
0 Kudos

I want to delete all occurances (not just the adjacent duplicates) from an internal table where certain fields are duplicated. I tried 'DELETE duplicate entries FROM it_name' but got an error saying 'Between Delete and Duplicate, Adjacent is missing'.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Make sure the "certain fields" are at the beginning of the record and that none of them occur after a numeric (curr etc) field. Sort the table. Use "DELETE ADJACENT DUPLICATES FROM itab COMPARING f1 f2...".

Did you do an ABAP help on DELETE ADJACENT DUPLICATES? Have a read - especially of the notes after Addition 2.

Answers (2)

Answers (2)

rahulkavuri
Active Contributor
0 Kudos

The syntax is

Delete adjacent duplicated from itab comparing field1.

Press F1 on Delete command( or any other command) so as to know about it

Former Member
0 Kudos

gi,

do this way


DELETE adjacent duplicates  FROM it_name comparing <fields>. 

Regards,

Santosh