topic Re: Alv grid override function in Application Development and Automation Discussions

Alv grid override function

Former Member — Tue, 21 Mar 2023 12:49:48 GMT

Is it possible to override SUM function in alv grid, for example do not count the material if it starts with '4'?

Re: Alv grid override function

FredericGirod — Tue, 21 Mar 2023 13:07:43 GMT

Filter the material and do the sum ... or switch to Excel

Re: Alv grid override function

Former Member — Tue, 21 Mar 2023 13:16:45 GMT

starts with 4 its just example. I have a huge grid with a lot of interchangeable element, wich of course summing if click sum function, so i need to override it and count interchangeable elements only once

Re: Alv grid override function

Sandra_Rossi — Tue, 21 Mar 2023 14:29:42 GMT

You can do anything in ABAP, you don't need to always use the standard ALV aggregation functions. Do the SUM yourself.

But remember to keep the ALV the most standard way, not to have too much specific weird results.

You may also add custom buttons to apply specific filters so that to simplify the task, and make it clear to the user what is currently filtered (one toggle button to say either include or exclude materials '4').

Re: Alv grid override function

RaymondGiuseppi — Tue, 21 Mar 2023 16:49:28 GMT

If it is really worth it, with CL_GUI_ALV_GRID and method GET_SUBTOTALS you can change the subtotal values.

(suggestion: Handle event after_refresh, if flag 'already done' is not set change subtotals, set flag 'already done' and force a re-display of ALV with method refresh_table_display)

Re: Alv grid override function

Former Member — Thu, 23 Mar 2023 07:37:32 GMT

I got subtotal values with get_subtotals method, but which kind of flag are u talking about and how to change subtotal values?

Re: Alv grid override function

RaymondGiuseppi — Thu, 23 Mar 2023 15:48:19 GMT

You get some REF TO DATA reference from GET_SUBTOTALS, then assign/loop and update the internal tables behind, recalculate sums.
By flag, I mean an attribute of your local class to make sure you don't do the calculation in an infinite loop, because the refresh_display will trigger the event after_refresh again.

Re: Alv grid override function

Former Member — Fri, 24 Mar 2023 09:30:09 GMT

i dont have parameters in AFTER_REFRESH event.It works, i calling mine override method after set_table_for_first_display.
And i call CALL METHOD lo_alv->set_ready_for_input

EXPORTING
i_ready_for_input = 0. in mine method.

But after filtering it couts as it counted before ( as a usual alv sum function ).