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 / rajesh

BY USING COLLECT STATEMENT

Is This Answer Correct ?    1 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi I am in training of functional module, i am unable to understand what exactly use of IDOC,BAPI,DIM and BIM. As LSMW and BDC methods are used for data conversion from legacy to sap. Might be it is silly question. please explain me

1754


What are the relational operations that can be performed on view in sap? : abap data dictionary

497


Explain what is the purpose of sap script?

561


The commands through which an abap/4 module can “branch to “ or “call” the next screen are?

618


What is value table? : abap data dictionary

627






What are the advantages of logical databases : abap hr

590


How will you define org structure in MM?

825


What is singleton pattern in OOPS?

957


what is call back in alv?

1962


In Smartforms or ADOBE Forms Can we get text from standard table in verticle form? if yes, How?

1797


Hi every one ! You people are doing a great job here , Im going to attend Tata Technologies interivew on this sunday,Can anyone who has already attended this company interivew or other companies interivews in abap pls share ur experience with me and help me to get into job my id ushareddyabap@gmail.com. Thankyou verymcuh

1495


What is technically difference between in Table creation in table creation maintenance not allowed ,maintenance allowed with restriction, maintenance allowed ?

1149


1.If there is one receiver,then To send 10 materials at a time through BD10 tcode, How many Master Idoc create? 2.If there is one receiver,then To send 1 material at a time through BD10 tcode, how many Master Idoc generated? 3.Can I Send Multiple Messges through BD10 tcode?

1486


Different types of luws. What are they?

605


Why do we use dynamic where conditions?

863