how can delete duplicates in sap?

Answer 1

You can try this site https://www.sdn.sap.com :

https://www.sdn.sap.com/irj/sdn/advancedsearch?QueryString=duplicate%20delete&SearchPluginName=sdn_all&SelectedCustomProps=resourcetype(value=sdn_article),resourcetype(value=sdn_article_complex),resourcetype(value=sdn_bulk_zip),resourcetype(value=sdn_case_study),resourcetype(value=sdn_demo),resourcetype(value=sdn_ebook),resourcetype(value=sdn_ebook_comp),resourcetype(value=sdn_eclass*),resourcetype(value=sdn_enduser_submission),resourcetype(value=sdn_evalution_version),resourcetype(value=sdn_event),resourcetype(value=sdn_faq*),resourcetype(value=sdn_file_only),resourcetype(value=sdn_forum),resourcetype(value=sdn_help*),resourcetype(value=sdn_hot_fix),resourcetype(value=sdn_how-to_guide),resourcetype(value=sdn_interface_documentation),resourcetype(value=sdn_javadocs*),resourcetype(value=sdn_mimes),resourcetype(value=sdn_open_source),resourcetype(value=sdn_patch),resourcetype(value=sdn_plain_html),resourcetype(value=sdn_presentation),resourcetype(value=sdn_product_definition),resourcetype(value=sdn_sap_tutor),resourcetype(value=sdn_sapnote),resourcetype(value=sdn_sdn-tv),resourcetype(value=sdn_tool),resourcetype(value=sdn_virtual_classroom),resourcetype(value=sdn_webinar*),resourcetype(value=sdn_weblog),resourcetype(value=sdn_workshop_material)

deleting adjacent duplicates comparing multiple fields
Forum 3/16/05 Author Name: Natasha L
... Topic: deleting adjacent duplicates comparing multiple fields Replies:... deleting adjacent duplicates comparing multiple fields Posted:... How can I delete adjacent duplicates from an itab comparing mutliple DELETE ADJACENT DUPLICATES FROM LT_ARCH_... Re: deleting adjacent duplicates comparing multiple fields... table and then use the " DELETE ADJACENT DUPLICATES " statement. e.... DELETE ADJACENT DUPLICATES FROM gt_itab COMPARING... Re: deleting adjacent duplicates comparing multiple fields......... DELETE ADJACENT DUPLICATES FROM itab...... COMPARING ALL FIELDS Effect Deletes adjacent duplicate entries from the internal table... If there are n duplicate entries in succession, the...

HTML Version
|
Properties
|
See Also

Regarding Delete duplicates adjacent in internal table
Forum 3/24/05 Author Name: ambi chan
... Topic: Regarding Delete duplicates adjacent in internal table Replies... Regarding Delete duplicates adjacent in internal table Posted... In my report i tried to delete the adjacent datas as below itab_rbusa. delete adjacent duplicates from itab_rbusa comparing... values as output after using the delete statement why?(789B Re: Regarding Delete duplicates adjacent in internal table... Re: Regarding Delete duplicates adjacent in internal table Posted... ] to itab_rbusa. delete adjacent duplicates from itab_rbusa comparing... values.. still i get duplicates. endloop. ambichan.... Re: Regarding Delete duplicates adjacent in internal table... the loop and then issue a DELETE...

HTML Version
|
Properties
|
See Also

ITAB_DUPLICATE_KEY error while deleting ODS data
Forum 4/28/06 Author Name: Ala Nishadam
... Topic: ITAB_DUPLICATE_KEY error while deleting ODS data Replies: 1...ITAB_DUPLICATE_KEY error while deleting ODS data Posted: Apr... again i am getting ITAB_DUPLICATE_ERROR message while deleting data from ODS. kindly... load it is very important to delete the previous data.... Re: ITAB_DUPLICATE_KEY error while deleting ODS data...DUPREC will give a list of duplicate records in RSISOSMAP. How then are the duplicate records deleted ?... Any ideas on what caused the duplicate records to be created ?

HTML Version
|
Properties
|
See Also

Delete duplicates in Field Groups
Forum 11/11/05 Author Name: ram malle
... Topic: Delete duplicates in Field Groups Replies:... Delete duplicates in Field Groups Posted:... where one of them contains the duplicate entries. How to catch it and delete the duplicates.... Re: Delete duplicates in Field Groups... FIELD-GROUPS: header. delete adjacent duplicates from header.... TYPE STANDARD TABLE OF mara. delete adjacent duplicates from int_mara.... Re: Delete duplicates in Field Groups Posted:

HTML Version
|
Properties
|
See Also

Search help - adding new fields - deleting duplicates in the resulting F4
Forum 6/23/05 Author Name: Bill Joseph
... help - adding new fields - deleting duplicates in the resulting F4 Replies... help - adding new fields - deleting duplicates in the resulting F4 Posted... i am getting no. of duplicates when i press F4 for... help - adding new fields - deleting duplicates in the resulting F4... help - adding new fields - deleting duplicates in the resulting F4

HTML Version
|
Properties
|
See Also

Deleting duplicate tables
Forum 1/17/06 Author Name: cyrus brocha
... Topic: Deleting duplicate tables Replies: 1 Pages... Deleting duplicate tables Posted: Jan 17... The problem is duplicate data is not being deleted from PSA and table /... make a batch routine to keep deleting the redundant data from PSA Re: Deleting duplicate tables

HTML Version
|
Properties
|
See Also

Using: Delete Adjacent Duplicates
Forum 8/28/04 Author Name: Arunava Das
... Topic: Using: Delete Adjacent Duplicates Replies: 4 Pages:... Using: Delete Adjacent Duplicates Posted: Aug 28,... Hi, How can we use Delete Adjacent Duplicates where comparing clause is dynamic... Re: Using: Delete Adjacent Duplicates... The DELETE ADJACENT DUPLICATES statement works particularly well if... want to compare when looking for duplicates. In this case, deleting adjacent duplicates is the same as deleting all duplicates.... Re: Using: Delete Adjacent Duplicates Posted: Aug 28,... So How can we use the Delete Adjacent Duplicate when there are more that but also the duplicates are not deleted.... Re: Using: Delete...

HTML Version
|
Properties
|
See Also

delete duplicate adjest
Forum 7/18/06 Author Name: rani umbro
... Topic: delete duplicate adjest Replies: 12 Pages... delete duplicate adjest Posted: Jul 18... i get 48 rows i make delete comma and it delete only 12 why ? ? Re: delete duplicate adjest... Re: delete duplicate adjest..., u have to sort before deleting. sort itab by matnr. delete adhjacent duplicates from itab comparing matnr. sort itab by... Re: delete duplicate adjest... the records before you use the delete adjacent duplicates from itab comparing field1 field2... Re: delete duplicate adjest... the right key column in: DELETE ADJACENT DUPLICATES FROM itab COMPARING keycolumn.... Re: delete duplicate adjest... first sort the itab for the duplicate...

HTML Version
|
Properties
|
See Also

How to delete duplicate entries from internal table.
Forum 11/3/05 Author Name: Sriram Ponna
... Topic: How to delete duplicate entries from internal table.... How to delete duplicate entries from internal table...., Please tell me how to delete the duplicate values/records from the... Re: How to delete duplicate entries from internal table.... Then use delete adjacent duplicates from itab_marc comparing... sort your table in beforehand, deleting will n't work correct. Re: How to delete duplicate entries from internal table.... DELETE ADJACENT DUPLICATES FROM ITAB.... the character fields in it and delete the rows which have duplicates comparing all the character fields... Re: How to delete duplicate entries from internal...

HTML Version
|
Properties
|
See Also

Delete Duplicate rows in Data Package based on selection
Forum 6/20/06 Author Name: Sri Vani
... Topic: Delete Duplicate rows in Data Package based... Delete Duplicate rows in Data Package based... The data has duplicate order no. I need to delete the duplicate rows in the data package... Re: Delete Duplicate rows in Data Package based... Start Routine for this. use DELETE DUPLICATES FROM DATA_PACKAGE COMPARING... Re: Delete Duplicate rows in Data Package based... Re: Delete Duplicate rows in Data Package based... something like this... DELETE ADJACENT DUPLICATES FROM DATA_PACKAGE COMPARING... Re: Delete Duplicate rows in Data Package based... DELETE ADJACENT DUPLICATES FROM DATAPAK COMPARING PROCESSID.... Re: Delete Duplicate rows in...

HTML Version
|
Properties
|
See Also

1-10More

Answer 2

I believe this link would help you if I understand your problem correctly.

http://help.sap.com/saphelp_nw2004s/helpdata/en/06/aafd54fc4011d195280000e8353423/content.htm

Good Luck :)

ps. next time take a look at http://help.sap.com thats where most developers including me run off too incase we are stuck :)