topic internal tables in Application Development and Automation Discussions

internal tables

Former Member — Fri, 29 Aug 2008 04:54:01 GMT

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.

Re: internal tables

Former Member — Fri, 29 Aug 2008 04:55:24 GMT

hi,

do it in two step,

step 1 SORT itab BY  MELNR

step 2 DELETE ADJACENT DUPLICATES FROM itab comparing MELNR

Regards,

anirban

Re: internal tables

Former Member — Fri, 29 Aug 2008 04:55:42 GMT

Hi,

Sort the internal table and use DELETE ADJECENT DUPLICATES statement.

Best regards,

raam

Re: internal tables

Former Member — Fri, 29 Aug 2008 04:56:28 GMT

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

Re: internal tables

Former Member — Fri, 29 Aug 2008 04:57:26 GMT

Hi Mathew ,

Write the statement :

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

This will solve the issue.

Regards,

Swapna.

Re: internal tables

Former Member — Fri, 29 Aug 2008 04:59:32 GMT

Use

DELETE ADJACENT DUPLICATE from itab comparing MELNR .

~hitesh

Try to close the thread once your queries are resolved