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

difference between Valuation type and valuation category?

2019


Why do we use dynamic where conditions?

884


visibility section for class level and attributes level

825


what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?

1741


Can we define our own match code id's for sap matchcodes? : abap data dictionary

579






Example of table cluster and cluster tables.

665


What are the uses of interactive reporting?

631


I am getting the (first) page number and the remaining records displayed in another list in another page BUT the PAGE Number is not displayed? What is the code/solution?

1547


Explain the uses of the simple maintenance interface? : sap abap hr

599


Hi! I want to join SAP ABAP course in Hyderabad, can any one tell me where should I join? and Which is the best institute for SAP WORKSHOP? Thank you...

1023


Did you create any joins?

555


What are the functions of lock objects?

707


What is asynchronous update?

588


How will you read from internal table records in a given value range (without using loop)

984


What is buffering allowed but switched off?

881