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 |
Which FM do you use to find out who is reporting to whom
How to print continuous pages in smartform?my requirement is i need to print 3 pages for each customer i.e 2 pages for purchase order forms and 3rd page is terms and condition page.Likewise how can i print 100 customer pages at once continuously?
where is security relevent information such as Password for ITS are stored?
How can we use multiple transactions by using bdc_insert? : abap bdc
What does an EXEC SQL stmt do in ABAP?
how to read the standard field value in your custom program.
if u write a write statement after end of selection ,will that be triggered?
2 Answers Bristle Cone, Cap Gemini, HP, Satyam, Wipro,
What does the ‘suppress dialog’ do?
How many types of size categories and data classes are there?
Significance of Hide?
WHICH LANGUAGE IS USED TO WRITE ABAP CODING PART?
I a custom table some one has edited and deleted something, So how we should maintain the log for changed and edited datas