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