topic delete adjacent duplicates required within a loop in Application Development and Automation Discussions

delete adjacent duplicates required within a loop

former_member632991 — Mon, 12 Feb 2007 10:06:43 GMT

can i use st.

delete adjacent duplicates from itab1 comparing vbeln without a loop on itab1.

or it should be used within a loop on itab1.

Former Member — Mon, 12 Feb 2007 10:08:39 GMT

You do not need it in a loop. However you need to sort the table by the fields you are checking for duplicates in.

Former Member — Mon, 12 Feb 2007 10:09:06 GMT

sort ur internal table by field Vbeln and then use delete adjacent duplicates clause.

u need not to use Loop in that.

for e.g -

u can use liek this -

sort itab by vbeln.

DELETE ADJACENT DUPLICATES FROM ITAB.

amit

Former Member — Mon, 12 Feb 2007 10:10:05 GMT

No need to loop...

you can staraight away write this:

delete adjacent duplicates from itab1 comparing vbeln.

Thanks

Former Member — Mon, 12 Feb 2007 10:34:27 GMT

hi Sonika,

Pls make sure the table itab is SORTed by the field based on which you want to delete; befor the DELETE ADJACENT .... stmt.

This statement can be issued without a loop. That is the advantage of this syntax.

Regards,

Vivek

**->Reward all correct, helpful ansers.