topic Re: MAX VALUE in Application Development and Automation Discussions

MAX VALUE

Former Member — Mon, 06 Aug 2007 07:26:24 GMT

Hi experts

I want to find the max value of a particular column in internal table and store in a variable.

tell me any methodes.

thanks in advance

Regards

Rajaram

Re: MAX VALUE

Former Member — Mon, 06 Aug 2007 07:27:30 GMT

SORT ITAB BY FIELD1 DESCENDING.

READ TABLE ITAB INDEX 1.

MAX_VALUE = ITAB-FIELD1.

Re: MAX VALUE

Former Member — Mon, 06 Aug 2007 07:29:04 GMT

HI,

before filling the internal table we can get it.

data :max_lifnr type lfa1-lifnr.

select max( lifnr ) into max_lifnr from lfa1.

or else u can do like this.

data :max_lifnr type lfa1-lifnr.

data:itab like lfa1 occurs 0 with header line.

select * into table itab from lfa1.

loop at itab.

if max_lifnr > itab-lifnr.

max_lifnr = itab-lifnr.

endif.

endloop.

write:/ max_lifnr.

(or)

data :max_lifnr type lfa1-lifnr.

data:itab like lfa1 occurs 0 with header line.

select * into table itab from lfa1.

sort itab by lifnr descending.

read table itab index 1.

max_lifnr = itab-lifnr.

write:/ max_lifnr.

please reward all helpful answers

rgds,

bharat.

Re: MAX VALUE

Former Member — Mon, 06 Aug 2007 07:32:37 GMT

Hi raja,

Data maxi like ztable-mark1.

select max(mark1) into maxi from ztable.

Regards,

Azhar

Re: MAX VALUE

Former Member — Mon, 06 Aug 2007 07:36:59 GMT

HI,

sort itab by fldname DESCENDING.

DATA MAX TYPE C.

READ TABLE ITAB INDEX SY-INDEX.

MAX = ITB-FLDNAME.

WRITE:/10 MAX.

IF HELPFUL REWARD SOME POINTS.

WITH REGARDS,

SURESH ALURI.

Re: MAX VALUE

Former Member — Mon, 06 Aug 2007 07:43:33 GMT

hi,

try this.

tables : zemployee.

data : sal like zemployee-salary.

select max( salary ) into sal from zemployee.

if sy-subrc = 0.

write 😕 sal.

endif.

Reward with points if useful.

Re: MAX VALUE

Former Member — Mon, 06 Aug 2007 07:51:34 GMT

BUT CAN WE IT WITHOUT SORTING.

Re: MAX VALUE

Former Member — Mon, 06 Aug 2007 07:52:54 GMT

Hi,

see my post to this thread.

rgds,

bharat.