topic Re: Internal table in Application Development and Automation Discussions

Internal table

Former Member — Mon, 23 Jun 2008 03:52:31 GMT

Hi All,

I am having one internal table with three fields i.e f1, f2, f3. Now my requirement is i have to display the record from internal table in which f2 value is maximum.

regards

shashikanth naram

Re: Internal table

Former Member — Mon, 23 Jun 2008 03:57:54 GMT

Hi,

SORT your internal table in descending order by F2.

read the first record.

EX; SORT itab by F2 DESCENDING. Now max. value will come in first.

READ the value.

LOOP AT ITAB.

ON CHANGE OF itab-f2.

READ ITAB WITH KEY ..........

ENDON.

ENDLOOP .

Re: Internal table

Former Member — Mon, 23 Jun 2008 03:58:02 GMT

sort internal table by f2 and then use select upto 1 row statement

Re: Internal table

Former Member — Mon, 23 Jun 2008 03:59:18 GMT

Hi Shashi,

Here is the logic.

1. Create 2 workarea (WA1 and WA2 )of the same type .

2. Now Loop at it_final,

Loop at itab.

If itab-f2 > wa1-f2.

wa2 = itab.

Endif.

wa1 = wa2.

Endloop.

Write:/ ' Maximum Value' , wa2-f1, wa2-f2, wa2-f3.

&**************Reward Point if helpful*****************&

Re: Internal table

Former Member — Mon, 23 Jun 2008 03:59:44 GMT

Hi shashikanth,

1. sort the internal table itab by f2 in descending order.

2. read the first line, gives the maximum value.

Ex.

Sort itab by f2 descending.

read table itab index.

reward if found helpful.

Regards,

Boobalan Suburaj

Re: Internal table

Former Member — Mon, 23 Jun 2008 04:02:41 GMT

Hi,

sort the internal table with descending order by the field f2 and then use read table to get the first record.

Thanks,

Arunprasad.P

Re: Internal table

Former Member — Mon, 23 Jun 2008 04:13:50 GMT

Sort your itab by desecding f2.

than: read itab index 1.

write:f1,f2,f3.

vipin

Edited by: Vipin on Jun 23, 2008 9:44 AM

Re: Internal table

kesavadas_thekkillath — Mon, 23 Jun 2008 04:15:11 GMT

sort itab by f2 descending.

read table f2 index 1.

write itab.

Re: Internal table

Former Member — Mon, 23 Jun 2008 04:26:38 GMT

Hi,

You can do as below :



SORT ITAB BY F2 DESCENDING.

READ TABLE ITAB INDEX 1.

WRITE : ITAB-F1, ITAB-F2, ITAB-F3.

Thanks,

Sriram POnna.