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

What are the payroll related infotypes? : abap hr

561


What is sap script? Describe its components.

586


What is an interactive report?

610


Do you know any other patterns if yes.. explain

865


Explain the components of selection table?

621






what is a text table ?

1801


What is locking ?

590


Explain what is the difference between sy-tabix and sy-index? Where it is used?

551


What is the function of a data element?

611


What are the dis-advantages of logical databases? : abap hr

594


What is the disadvantage of a call by reference? : abap modularization

592


How do you read files from the presentation server ? : abap bdc

573


What is off cycle payroll run

1776


What is netweaver???what is the relationship with ABAP?

1617


Differentiate between transparent tables, cluster tables and pooled tables

555