topic Re: internal table problems in Application Development and Automation Discussions

internal table problems

Former Member — Thu, 26 Jul 2007 13:02:39 GMT

Hi All,

I am having an internal table with several entries,

now lets say i have 200 entries then there are 10 each of same keys,

so i want to delete the 9 entries and keep only which has higest date,

so technically i want to reduce 200 to 20 entires, can someone suggest some efficient way of doing that please?

thanks,

Hitesh

Re: internal table problems

Former Member — Thu, 26 Jul 2007 13:06:36 GMT

hi,

sort our internal table by date field as

SORT ITAB BY DATE.

and use DELETE ADJACENT KEYWORD to delete duplicate records as

DELETE ADJACENT DUPLICATES FROM ITAB..............

if helpful reward some points.

with regards,

Suresh Aluri.

Re: internal table problems

Former Member — Thu, 26 Jul 2007 13:06:44 GMT

you can:

sort tha table for data

delete adjacent duplicates from table comparing keys.

Message was edited by:

Ierardi Leo

Re: internal table problems

Former Member — Thu, 26 Jul 2007 13:07:12 GMT

Hi,

Let sat ITAB is ur Internal Table with 200 entries.

SORT ITAB BY <Key Fields> <Date field> DESCENDING.

DELETE ADJACENT DUPLICATE ENTRIES FROM ITAB COMPARING <Key Fields> .

Regards,

Ranjit Thakur.

Please Mark The Helpful Answer.

Re: internal table problems

Former Member — Thu, 26 Jul 2007 13:08:26 GMT

Hi,

Sort the internal table by date descending & use DELETE ADJECENT DUPLICATES statement.

First sort the table with main key & the date. e.g.:

SORT itab by vbeln ASCENDING date DESCENDING.

Now loop the table & use coantrol break At new VBELN. And append the values to another internal table at new sales order.

at last use the following to assing the contenets of the 2nd internal table to main internal table.

ITAB1[] = ITAB2[].

Reward points if helpful answer.

Ashvender

Re: internal table problems

Former Member — Thu, 26 Jul 2007 13:26:48 GMT

Hi,

Do it like this

Sort itab by date descending.

Delete adjacent duplicates from itab comparing date.

It wll delete all the adjacent duplicate entries by checking date.

I think it will solve your problem.

Award points if use ful.

Regards,

Kishore