topic Re: Combining rows into single row in dynamic internal table in Application Development and Automation Discussions

Combining rows into single row in dynamic internal table

Former Member — Fri, 11 Sep 2015 15:38:39 GMT

Hello All,

i have created a dynamic internal table as below: (Here Prod. Orders are dynamic in the internal table), now i am passing this dynamic internal table to ALV for display.

Now i want to merge similar operations into 1 row like below.

Any ideas will be helpful.

Regards,

Sree.

Re: Combining rows into single row in dynamic internal table

Former Member — Fri, 11 Sep 2015 15:55:29 GMT

Before appending a row you should check if there's a record with the same operation and modify it

So I believe you should change your logic where you append the record in the dynamic internal table

Max

Re: Combining rows into single row in dynamic internal table

VenkatRamesh_V — Fri, 11 Sep 2015 16:28:31 GMT

Hi,

Try,

Sort internal table by operations. Use collect statement Instead of append.

Hope it helpful,

Regards,

Venkat.

Re: Combining rows into single row in dynamic internal table

former_member184158 — Fri, 11 Sep 2015 16:51:38 GMT

Hi,

Just use Collect ls_data into lt_data.

look to this example please,

this is the difference between collect ans append.

Append ls_data to lt_data.

After using collect statement

Collect ls_data into lt_data.

REPORT zibo_pg_test2.

TYPES: BEGIN OF st_ty,
operation TYPE c LENGTH 2,
prod1 TYPE i,
prod2 TYPE i,
prod3 TYPE i,
prod4 TYPE i,
END OF st_ty.

data ls_data TYPE st_ty.
data lt_data TYPE TABLE OF st_ty.

ls_data-operation = 10.
ls_data-prod1 = 100.
APPEND ls_data to lt_data.
CLEAR ls_data.

ls_data-operation = 10.
APPEND ls_data to lt_data.
CLEAR ls_data.

ls_data-operation = 10.
ls_data-prod3 = 90.
APPEND ls_data to lt_data.
CLEAR ls_data.

ls_data-operation = 10.
ls_data-prod4 = 75.
APPEND ls_data to lt_data.
CLEAR ls_data.

BREAK-POINT.
CLEAR lt_data.

ls_data-operation = 10.
ls_data-prod1 = 100.
COLLECT ls_data into lt_data.
CLEAR ls_data.

ls_data-operation = 10.
COLLECT ls_data into lt_data.
CLEAR ls_data.

ls_data-operation = 10.
ls_data-prod3 = 90.
COLLECT ls_data into lt_data.
CLEAR ls_data.

ls_data-operation = 10.
ls_data-prod4 = 75.
COLLECT ls_data into lt_data.
CLEAR ls_data.

Regards

Ibrahim

Re: Combining rows into single row in dynamic internal table

etetik — Mon, 13 Feb 2023 10:02:15 GMT

This. I signed up just to upvote this comment. Use collect instead of append to resolve the problem.