internal tables

[Former Member]

i hv an internal table with several columns....

in that internal table there is an field MELNR (migo number).

i want that if the migo number is repeated in that internal table, then the first record should exist only.remaining records with same MIGO number should be deleted.

[Former Member]

hi,

do it in two step,

step 1 SORT itab BY  MELNR

step 2 DELETE ADJACENT DUPLICATES FROM itab comparing MELNR

Regards,

anirban

[Former Member]

Hi,

Sort the internal table and use DELETE ADJECENT DUPLICATES statement.

Best regards,

raam

[Former Member]

For that you have to give your query as groupby, try this way and execute.

[Former Member]

Hi Mathew ,

Write the statement :

SORT ITAB BY MELNR.
DELETE ADJACENT DUPLICATES FROM ITAB COMPARING MELNR.

This will solve the issue.

Regards,

Swapna.

[Former Member]

Use

DELETE ADJACENT DUPLICATE from itab comparing MELNR .

~hitesh

Try to close the thread once your queries are resolved