topic Re: CL SALV aggregation doesn't work in Application Development and Automation Discussions

CL SALV aggregation doesn't work

Anandkarna123 — Wed, 16 Oct 2024 04:44:48 GMT

The aggregation was not working on my main program, so I decided to write another dummy program to see if it works there or not. Turns out, it doesn't. I have gone through every discussion and cannot seem to find the solution. The total doesn't appear at the end of the column which technically, it should.

Here is the code:

REPORT z_test_salv_aggregation. TYPES: BEGIN OF ty_data, menge TYPE i, " Using integer for quantity END OF ty_data. DATA: it_test TYPE TABLE OF ty_data, wa_test TYPE ty_data, lo_alv_table TYPE REF TO cl_salv_table, lo_agg TYPE REF TO cl_salv_aggregations, lo_functions TYPE REF TO cl_salv_functions_list. * Sample data wa_test-menge = 10. APPEND wa_test TO it_test. wa_test-menge = 20. APPEND wa_test TO it_test. wa_test-menge = 30. APPEND wa_test TO it_test. * Create the ALV Table TRY. cl_salv_table=>factory( IMPORTING r_salv_table = lo_alv_table CHANGING t_table = it_test ). CATCH cx_salv_msg INTO DATA(lx_msg). WRITE: / 'Error creating ALV table:', lx_msg->get_text( ). RETURN. ENDTRY. * Get the Functions object and activate all functions lo_functions = lo_alv_table->get_functions( ). lo_functions->set_all( 'X' ). lo_agg = lo_alv_table->get_aggregations( ). TRY. CALL METHOD lo_agg->add_aggregation EXPORTING columnname = 'MENGE' aggregation = if_salv_c_aggregation=>total. CATCH cx_salv_data_error cx_salv_not_found cx_salv_existing INTO DATA(lx_error). ENDTRY. * Display the ALV Table lo_alv_table->display( ).

Re: CL SALV aggregation doesn't work

Sandra_Rossi — Wed, 16 Oct 2024 05:16:44 GMT

It does work.

Re: CL SALV aggregation doesn't work

Anandkarna123 — Wed, 16 Oct 2024 05:20:49 GMT

Hey, thanks for your reply. As you can see in the image below, the sum is not shown. Could this be a version problem or something like that?

Re: CL SALV aggregation doesn't work

Sandra_Rossi — Wed, 16 Oct 2024 05:23:13 GMT

Of course. Optionally use "ALV SOS" to identify the cause (search the Web).

Re: CL SALV aggregation doesn't work

Anandkarna123 — Wed, 16 Oct 2024 05:44:18 GMT

yeah, I did the consistency check. It shows this

What does this mean?

Re: CL SALV aggregation doesn't work

Sandra_Rossi — Wed, 16 Oct 2024 06:29:01 GMT

It doesn't concern your total issue.

What it means:

Re: CL SALV aggregation doesn't work

Sandra_Rossi — Wed, 16 Oct 2024 06:49:02 GMT

You didn't indicate your ABAP version.

Try with type P instead of I.

Re: CL SALV aggregation doesn't work

RaymondGiuseppi — Wed, 16 Oct 2024 07:04:12 GMT

I copied your code and it worked on my ECC and S/4HANA systems, can you check that you didn't define a default display variant and/or execute the ALV consistency check on your system?

Re: CL SALV aggregation doesn't work

RaymondGiuseppi — Wed, 16 Oct 2024 08:13:00 GMT

Also MENGE is usually a quantity field, so associated to a unit of measure field, add this uom field to the displayed structure (or define as a constant in field catalog) and insure the link is correct, so ALV will not sum add meters and litters.

CL_SALV_COLUMN->SET_QUANTITY or SET_QUANTITY_COLUMN