topic Re: Internal Table in Application Development and Automation Discussions

Internal Table

Former Member — Wed, 22 Nov 2006 19:03:14 GMT

Hi ,

Can anyone please tell me the syntax to for which we can check the values of an internal table for duplicates and avoid it.

Thanks

Former Member — Wed, 22 Nov 2006 19:09:01 GMT

Hi,

To delete duplicate records from internal table you can check this code:

sort itab by a b c.

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING a b c.

sort itab.

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING all fields.

Former Member — Wed, 22 Nov 2006 19:10:00 GMT

Hi,

First sort the internal table on the field on which you want to check for the duplicates.

then:

Delete adjacent duplicates from ITAB.

Please close the thread if it is solved.

Regards,

Vinod.

venkata_ramisetti — Wed, 22 Nov 2006 19:10:52 GMT

Hi Bharat,

If just want to delete all duplicates, you can use the below lgic.

SORT ITAB BY FIELD1 FIELD 2.

DELETE ADJACENT DUPLICATES FROM itab COMPARING ALL FIELDS.

Make sure that you sort you internal table in such way all dusplicate records should come adjacent.

Thanks

Ramakrishna