Convert multiple Rows in a Single row with different columns in ALV Report

[hossain_rajib55]

Hello Experts!!!

Looking for a guideline. As per my development i need to convert internal table multiples rows in a single row and values in different columns based on lifnr (Supplier) , gjahr (Fiscal Year), Poper (Period) for ALV report.

Please guided me.

Internal Table:

Need as like below:

Regards-

Rajib

[Sandra_Rossi]

I don't know what your exact question is, but maybe you are looking for ASSIGN COMPONENT (classic question in the forum). Even ASSIGN without COMPONENT could be used.

DATA(field_name) = 'PERIOD' && POPER.

ASSIGN COMPONENT field_name OF STRUCTURE alv_line TO FIELD-SYMBOL(<period_quantity>).

<period_quantity> = <period_quantity> + HSL_CRDT.

[hossain_rajib55]

@Sandra_Rossi  in my internal table i have multiple vendor and those vendor has HSL value based on period. so need to show them in a single line vendor wise as well as need to show in which period its amount is present.

[Sandra_Rossi]

So, my answer is fine, right?

[raymond_giuseppi]

Is the results table structure static or dynamic?

• Use Runtime Type Services (RTTS) to create a dynamic table.
• Then use assign to copy the data

[hossain_rajib55]

@raymond_giuseppi  Yes this one is dynamic structure.

[raymond_giuseppi]

If you can select multiple years, yes dynamic, but if only one year you can define a static version with 12 or 16 amounts columns (1-12, or more depending on Financial calendar 1-16?)

In first case

• Use @Sandra_Rossi 's answer with ASSIGN COMPONENT statement 

Else

• identify the available periods (e.g. 2024-01, 2024-02, etc.) in the first internal table
• And create a dynamic internal table - Create Dynamic Table using RTTS and display in ALV
• Also use @Sandra_Rossi 's answer with ASSIGN COMPONENT statement 

[hossain_rajib55]

@raymond_giuseppi  & @Sandra_Rossi  Thanks for your guideline.

Based on lifnr and period i need to combined in a row. I did the table structure and now need to move data.Now in which step should i follow.

[hossain_rajib55]

Thanks to @Sandra_Rossi  and @raymond_giuseppi  for your valuable time. I solved it as per guideline.

Regards-

Rajib