topic Re: maximum value in ALV in Application Development and Automation Discussions

maximum value in ALV

Former Member — Sun, 12 Oct 2008 01:47:57 GMT

Hi Friends,

I have some requirement like below...

ABC JACKSON 1000.00

ABC DENNY 2000.00

ABC KELVIN 0.00

2000.00 (subtotal should display Max value in that column)

i mean in the ALV output i needs to display the subtotal as Max value for ABC...and so on.

I would like to know that there is any option like do_sum,sub_tot ........ in ALV field catalog..?

kindly help me to resolve this...

Re: maximum value in ALV

Former Member — Sun, 12 Oct 2008 03:14:00 GMT

it is possible. but there is no special option for it. you have to use the DO_SUM option of the fieldcatalog.

DO_SUM = 'A' "for maximum

DO_SUM = 'B' " for minimum

DO_SUM = 'C' " for Average

DO_SUM = 'X' " for totals

check it once.

Re: maximum value in ALV

Former Member — Mon, 13 Oct 2008 02:09:31 GMT

Thanks ....but i have one question... that you mentioned as do_sum... i.e only for entire column sum right...? but for me i needs to show at sub_total level.. Maximum value..

please confirm it... 'A' 'B' 'C' will work for both...?

Edited by: murali krishna on Oct 13, 2008 5:30 AM

Re: maximum value in ALV

Former Member — Mon, 13 Oct 2008 04:03:03 GMT

No.Do_sum =A,B,C.. would work only with the ALV column values not for the sub total values.