delete

[Former Member]

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]

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]

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]

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

Don't forget to sort.

[Former Member]

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]

Thanks everyone.

Shejal.