Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Hi everyone

can any body tell me how to remove identical records from an internal table.

I have 12450 records in an internal table which are read from excel sheet and when i tried to move them into a db table i get only 12449.

please let me know if you guys have an idea.

suchitra

Tags:
Former Member
Former Member replied

Hi,

first sort that internal table.then use this command

DELETE ADJACENT DUPLICATES from itab BY COMPARING 'field1' or

DELETE ADJACENT DUPLICATES FROM itab BY COMPARING ALL FIELDS.

Cheers,

Bujji

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question