topic Re: internal table manipulation.. in Application Development and Automation Discussions

internal table manipulation..

former_member185116 — Thu, 09 Oct 2014 10:05:26 GMT

hell all,

in have an internal table consisting of 4 records ..

the internal table has field called PTIME,

now my question is i need to get the record whose PTIME is highest and delete remaining records,

how do i achieve this,...

SimoneMilesi — Thu, 09 Oct 2014 10:09:55 GMT

Hi Vinay

Try this


SORT table BY ptime DESCENDING.
READ TABLE table INTO wa_table INDEX1.
DELETE table WHERE ptime <> wa_table-ptime.

former_member249399 — Thu, 09 Oct 2014 10:11:19 GMT

Hi,

sort your internal table with PTIME descending,

read table itab1 index 1. "itab1 : internal table

get data into structur / variable. store data into new table.

You can delete table.

Former Member — Thu, 09 Oct 2014 10:12:59 GMT

declare two workareas wa1 and wa2 of the same type Internal table (PTIME)

loop at itab into wa1.

read table itab into wa2 with index sy-index + 1.

if wa2-PTIME > wa1-PTIME.

PTIME_HIGHEST = wa2-PTIME.

endif.

endloop.

This will give highest PTIME value.

DELETE from itab where PTIME <> PTIME_HIGHEST.

Do hope it helps.

Reward points if helpful

Former Member — Thu, 09 Oct 2014 10:18:55 GMT

try this

SORT table BY ptime DESCENDING.

DELETE table from 2 .

former_member185116 — Thu, 09 Oct 2014 10:22:00 GMT

simone,

thanks for u r quick reply...