topic Re: Delete the Adjacent duplicate values in Application Development and Automation Discussions

Delete the Adjacent duplicate values

Former Member — Tue, 27 Feb 2007 14:21:14 GMT

Hi all,

I want to Delete the Adjacent duplicate values. For this iam using

Delete Adjacent duplicates from table itab.

My question is Where i have to use this? i mean outside the loop or

within the Loop and Endloop.

Performance wise which one is suggested ?

Thanks in advance

Sri...

Re: Delete the Adjacent duplicate values

Former Member — Tue, 27 Feb 2007 14:22:15 GMT

It is not to be used within a loop.

It should be out of the loop.

Leave performance, if you use it in a loop, you will get erroneous results.

Regards,

ravi

Re: Delete the Adjacent duplicate values

Former Member — Tue, 27 Feb 2007 14:22:31 GMT

You cannot use that in loop

use that befor loop .... endloop

Re: Delete the Adjacent duplicate values

Former Member — Tue, 27 Feb 2007 14:24:24 GMT

HI,

U cant Use in a Loop.

Ex:

<b>SORT ITAB ASCENDING BY MATNR WERKS.

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING MATNR.</b>

Regards

SAB

Re: Delete the Adjacent duplicate values

suresh_datti — Tue, 27 Feb 2007 14:24:49 GMT

outside the loop.

<i>sort itab.

delete adjacent duplicates from itab.</i>

You can also use the addition

delete adjacent duplicates from itab comparing fields <f1> <f2> etc.

~Suresh

Re: Delete the Adjacent duplicate values

Former Member — Tue, 27 Feb 2007 14:26:55 GMT

You need to sort the internal with or without a field before using delete adjacent duplicates on itab.

use

delete adjacent duplicates from itab

Re: Delete the Adjacent duplicate values

Former Member — Tue, 27 Feb 2007 14:27:07 GMT

Hi,

it must not be between loop and end loop.

write outside the loop.

before using Delete Adjacent duplicates from table itab.

sort the table itab.

i.e

sort itab.

Delete Adjacent duplicates from table itab.

Regards,

Sruthi