topic delete data from internal table in Application Development and Automation Discussions

delete data from internal table

Former Member — Thu, 20 Dec 2007 10:36:58 GMT

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..

Re: delete data from internal table

Former Member — Thu, 20 Dec 2007 10:38:36 GMT

can you re-explain what exactly is the issue?

Re: delete data from internal table

Former Member — Thu, 20 Dec 2007 10:39:03 GMT

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

Re: delete data from internal table

former_member188829 — Thu, 20 Dec 2007 10:39:35 GMT

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

Re: delete data from internal table

Former Member — Thu, 20 Dec 2007 10:41:47 GMT

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

wil it not work?

Re: delete data from internal table

Former Member — Thu, 20 Dec 2007 10:42:51 GMT

Re: delete data from internal table

Former Member — Thu, 20 Dec 2007 10:43:28 GMT

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.

Re: delete data from internal table

Former Member — Thu, 20 Dec 2007 10:44:51 GMT

Hi,

You can do as below:


Sort itab by erdat matnr descending.

delete adjacent duplicates frommiab comparing erdat.

Thanks,

Sriram Ponna.

Re: delete data from internal table

Former Member — Thu, 20 Dec 2007 11:05:48 GMT

Hi,

Use this

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

SORT tablename by matnr DESCENDING

DELETE ADJACENT DUPLICATES FROM table name COMPARING matnr.

Regards,

Ari