topic Re: Get Sum for multiple field in Application Development and Automation Discussions

Get Sum for multiple field

former_member203806 — Tue, 03 Jan 2023 07:00:01 GMT

Hi Experts,

I have below internal table.

I need to get Date wise, Category wise total duration.

Thanks

Re: Get Sum for multiple field

Dominik_Tylczynski — Tue, 03 Jan 2023 08:11:05 GMT

Hello pramod.pathirana

pramod.pathiranaHave a look at control level processing when working with internal tables:

Processing Table Entries in Loops

AT - Control Level Processing

Best regards

Dominik Tylczynski

Re: Get Sum for multiple field

Sandra_Rossi — Tue, 03 Jan 2023 08:47:44 GMT

It could be something close to this:

itab_with_sum = VALUE #(
                FOR GROUPS <group> OF <line> IN source_itab
                GROUP BY ( category = <line>-category )
                ( category     = <group>-category
                  sum_duration = REDUCE #(
                                 INIT sum = VALUE decfloat16( ) IN
                                 FOR <line> IN GROUP <group>
                                 NEXT sum = sum + <line>-duration ) ) ).

or if you have HANA (simpler but should be slower):

SELECT category, SUM( duration ) AS sum_duration
FROM @source_itab
GROUP BY category
INTO TABLE @DATA(itab_with_sum).

Re: Get Sum for multiple field

Eduardo-CE — Tue, 03 Jan 2023 15:09:26 GMT

LOOP.
  COLLECT wa INTO itab 
ENDLOOP.