I have a table with 400 recs. among some are duplicate records.

how can I remove the duplicate records from the table.

pls help me out.

Answer Posted / sunil

Sort internal table according to field which is having
repeated values. And the use the statement "DELETE ADJACENT
DUPLICATES FROM <internaltable> COMPARING <the field with
which u sorted the internal table>.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

BDC program to migrate data to SAP R/3 database. The data will be uploaded using transaction ME11. (Session Method) plz mention the detail coding Tahnks, Rahul

1613


Which type of tables used this buffer?

595


Explain pai and pbo.

713


What is pakey structure, pshd1 structure and what type of fields it contains? : abap hr

750


What is an “on request field” statement?

648






How many types of data classes are there in sap abap? : abap data dictionary

552


How to write a code in tab control? : abap bdc

629


What is the difference between RETURNING and CHANGING parameters for a method?

1000


How to insert a line into abap internal tables?

612


What is a transport?

624


What is table buffer?

579


In the abap/4 dictionary tables can be defined independent of the underlying database (t/f). : abap data dictionary

703


What does the extract statement do in extract datasets? : abap modularization

557


What is the difference between field-group header and other field groups?

561


Concepts of OO ABAP and why we are using it?

855