delete data from internal table

[Former Member]

Hi Experts...

I have output like :

erdat matnr

12/2/2007 100000

13/2/2007 100000

14/11/2007 100001

14/6/2007 100001

but i want it like:

erdat matnr

13/2/2007 100000

14/6/2007 100001

data retriving from table direct..

and it is not working with max function.

plz help me..

[Former Member]

Hi,

Use this

first sort the internal table by matnr..then delete the duplicates

like

SORT tablename by matnr DESCENDING

DELETE ADJACENT DUPLICATES FROM table name COMPARING matnr.

Regards,

Ari

[Former Member]

can you re-explain what exactly is the issue?

[Former Member]

Sort table itab descending by matnr erdat.

Delete adjacent duplicates from Itab comparing matnr.

Lokesh

Edited by: Lokesh Aggarwal on Dec 20, 2007 10:39 AM

[former_member188829]

Hi,

Sort itab By Matnr Erdat Descending.

Delete Adjacent Duplicates From itab Comparing Matnr.

Edited by: Vishnu Reddy on Dec 20, 2007 4:14 PM

Edited by: Vishnu Reddy on Dec 20, 2007 4:34 PM

[Former Member]

sorting internal table and using select upto 1 row and appending it to another itab

wil it not work?

[Former Member]

..

[Former Member]

SORT it_mara BY matnr erdat descending.

DELETE ADJACENT DUPLICATE from it_mara comparing matnr.

LOOP AT it_mara.

WRITE: / it_mara-matnr,

it_mara-ersda.

ENDLOOP.

[Former Member]

Hi,

You can do as below:

Sort itab by erdat matnr descending.

delete adjacent duplicates frommiab comparing erdat.

Thanks,

Sriram Ponna.

[Former Member]

Hi,

Use this

first sort the internal table by matnr..then delete the duplicates

like

SORT tablename by matnr DESCENDING

DELETE ADJACENT DUPLICATES FROM table name COMPARING matnr.

Regards,

Ari