topic Re: find max value from internal table in Application Development and Automation Discussions

find max value from internal table

Former Member — Thu, 18 Oct 2007 07:16:43 GMT

DATA : BEGIN OF SUBVBPLP OCCURS 10,

vendprodid like mara-mfrpn ,

CUMQUANTITY TYPE I ,

PACKLISTID LIKE VBRK-VBELN,

mfr_id(3) ,

debtorid(27),

END OF SUBVBPLP.

SUBVPLP-CUMQUANTITY = 10.

APPEND .

SUBVPLP-CUMQUANTITY = 20.

APPEND.

I WANT TO FIND THE MAX VALUE FORM CUMQUANTITY . AND RESULT INTO ONE VARIBALE . PLS GIVE SUGGESTION TO GET MAX VALUE

Re: find max value from internal table

Former Member — Thu, 18 Oct 2007 07:18:49 GMT

Hi,

data : test type i.

Sort subvbplp by cumquantity descending.

read table subvbplp index 1.

test = subvbplp-cumquantity.

Regards,

Himanshu

Re: find max value from internal table

Former Member — Thu, 18 Oct 2007 07:22:13 GMT

declare two workareas wa1 and wa2 of the same type SUBVBPLP

loop at itab into wa1.

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

if wa2-CUMQUANTITY > wa1-CUMQUANTITY.

maxval = wa2-CUMQUANTITY.

endif.

endloop.

This wil give max in variable maxval.

Hope dis solves ur query

Reward points if helpful

Re: find max value from internal table

Former Member — Thu, 18 Oct 2007 07:26:28 GMT

use this select statement...

Select max ( <fieldname in itab> ) from table <i_tab> into <f_name> where .........

Re: find max value from internal table

varma_narayana — Thu, 18 Oct 2007 07:34:20 GMT

Hi.

This is the code to get the Max CUMQUANTITY.

Sort SUBVBPLP by CUMQUANTITY DESCENDING.

READ TABLE SUBVBPLP INDEX 1.

WRITE: / SUBVBPLP-CUMQUANTITY .

<b>Reward if Helpful.</b>

Re: find max value from internal table

Former Member — Thu, 18 Oct 2007 10:18:07 GMT

loop at subvbplp.

sort subvbplp by cumquantity descending.

read table subvbplp into w_subvbplp with index sy-index+1.

if w_subvbplp > subvbplp.

maxval = w_subvbplp-cumquantity.

endif.

endloop.

NO I GETTING SOME ERROR " KEY = ....","JEY...= "OR TABLE KEY ...=" EXPECTED AFTER WITH

Re: find max value from internal table

varma_narayana — Thu, 18 Oct 2007 10:23:47 GMT

Hi Anil.

There is no need to Loop the Internal table in this case .

This is the better way.

Check this which i gave in my prev post.

Hi.

This is the code to get the Max CUMQUANTITY.

<b>Sort SUBVBPLP by CUMQUANTITY DESCENDING.

READ TABLE SUBVBPLP INDEX 1.

WRITE: / SUBVBPLP-CUMQUANTITY .

</b>

REWARD IF HELPFUL

Re: find max value from internal table

Former Member — Fri, 13 Jun 2014 22:50:32 GMT

The logic is not complete. If the max value is the first one, it will not be saved to maxval. This would be the proper solution:

loop at itab into wa1.

maxval = wa1-cumquantity.

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

if wa2-CUMQUANTITY > wa1-CUMQUANTITY.

maxval = wa2-CUMQUANTITY.

endif.

endloop.