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 / paras vora

After sorting, you can delete duplicates from an internal
table using the delete adjacent duplicates statement,
described in the ABAP/4 keyword documentation.

Is This Answer Correct ?    24 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the rules to create a BAPI?

1155


When value table becomes check table?

568


What is the difference between a pool table and a transparent table and how they are stored at the database level?

576


What is the length of function code at user-command?

740


Why we are using Macros instead of Function Modules

1607






Explain what are interactive reports?

615


There is a situation where there is a field "MATERIAL DESCRIPTION" in say 20 display only transaction. You want that whenever user opens any of these transaction, this particular field is masked with ****. But table does not holds ****. It holds the actual value. What are different ways of doing it? Which is the best way.

917


What is the maximum number of structures that can be included in a table or structure

630


why particularly lock object name starts with EZ OR EY?

1499


What are the two different ways of building a match code object? : abap data dictionary

604


What is an rdbms?

575


What are authorization objects and what statement is used to perform an authorization check in an abap program?

553


Explain what are the events in screen programming?

564


What is database utility?

693


Can a constructor be declared private? If yes then in which scenario?

914