topic Re: internal table in Application Development and Automation Discussions

internal table

Former Member — Thu, 02 Feb 2006 08:08:22 GMT

How to find Maximum Value in Internal Table

There is one internal table containing 3 columns.

I want to find the maximum value of 2nd column in that internal table . If I use loop at tab, that becomes performance issue, when there are more no. of records.

Re: internal table

jayanthi_jayaraman — Thu, 02 Feb 2006 08:12:29 GMT

Hi,

sort itab by column2 descending.

read itab into wa index 1.

write wa-column2.

This will give the maximum value.Kindly reward points by clicking the star on the left of reply,if it ehlps.

Re: internal table

Former Member — Thu, 02 Feb 2006 08:12:40 GMT

Hi,

Try to sort the internal table by that column in ascending/descending format.

Then read the 1st or the last entry of the internal table depending on the sorting type ( ascending/descending ).

Best regards,

Prashant

Re: internal table

Former Member — Thu, 02 Feb 2006 08:25:03 GMT

Hi, chexk this sample code. you can do a similar one

tables : vbak.

parameters : p_vbeln like vbak-vbeln.

data : itab like table of vbak with header line.

select * from vbak into table itab where vbeln = p_vbeln.

*assume the second column is erdat

sort itab by erdat descending.

read table itab index 1.

write : itab-erdat.

Re: internal table

Former Member — Thu, 02 Feb 2006 08:27:50 GMT

sort itab by <field nedded>.
read table itab index 1.

Message was edited by: Deepak K

Re: internal table

Former Member — Thu, 02 Feb 2006 08:37:37 GMT

hi,

sort the table by ascending/descending order on the respective columns.. the first row in itab will give the least/largest value.. For further info type sort and press f1 help.

Regards.

Re: internal table

hymavathi_oruganti — Thu, 02 Feb 2006 08:41:43 GMT

THERE IS FN MAX.

IT WORKS ON N, I, P types.

MAX(SNO) gives maximum of SNO

Re: internal table

Former Member — Thu, 02 Feb 2006 08:44:59 GMT

i hope everyone else suggested the same...