topic Re: delete in Application Development and Automation Discussions

delete

Former Member — Fri, 06 Oct 2006 15:28:31 GMT

I want to delete duplicate records from an Internal Table by comparing all the fields.

CAN I use the code below or do i need to specify comparing fields.

DELETE ADJACENT DUPLICATES FROM it_bsid.

Shejal.

Former Member — Fri, 06 Oct 2006 15:30:17 GMT

Hi,

Example..

For DELETE ADJACENT DUPLICATES you have to sort first..

SORT ITAB BY MATNR.

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING MATNR.

If you don't give the comparing it will check for all the fields..

Thanks,

Naren

RichHeilman — Fri, 06 Oct 2006 15:30:36 GMT

Just use that statement, omitting the COMPARING extension will simply mean that it will look at the entire line.

sort it_bsid ascending.
DELETE ADJACENT DUPLICATES FROM it_bsid.

Regards,

Rich Heilman

Former Member — Fri, 06 Oct 2006 15:30:37 GMT

<b>DELETE ADJACENT DUPLICATES FROM it_bsid comparing all fields.</b>

Don't forget to sort.

Former Member — Fri, 06 Oct 2006 15:31:10 GMT

Hi Shejal,

If you didnt specify COMPARING clause it will consider all fields of internal table.

These two statements will work in same manner.

DELETE ADJACENT DUPLICATES FROM it_bsid.

DELETE ADJACENT DUPLICATES FROM it_bsid COMPARING ALL FIELDS.

Thanks,

Vinay

Former Member — Fri, 06 Oct 2006 15:32:33 GMT

Thanks everyone.

Shejal.