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.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / ganesh jarwal
by using "DELETE ADJECENT DUPLICATES" we can remove the
duplicat resords from a table.
Is This Answer Correct ? | 3 Yes | 0 No |
if u write a write statement after end of selection ,will that be triggered?
2 Answers Bristle Cone, Cap Gemini, HP, Satyam, Wipro,
How to get the spool number in smartforms?
can any body tell what is idoc archieving and how to do that
What are the different database integrities?
What does the extract statement do in extract datasets?
Differentiate screen painter from menu painter.
Why is bdc _cursor and GET_Cursor used?
How to move the even records of one internal table to other
how to modify the standard method as per your requirement
Explain enhancements
Performance tuning techniques
What are the function modules used in a sap script driver program?