2024 Nov 06 5:55 AM
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
2024 Nov 06 8:45 AM
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.
2024 Nov 06 11:25 AM
@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.
2024 Nov 06 12:42 PM
2024 Nov 06 9:46 AM
Is the results table structure static or dynamic?
2024 Nov 06 10:36 AM
@raymond_giuseppi Yes this one is dynamic structure.
2024 Nov 06 12:59 PM
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
Else
2024 Nov 07 4:52 AM - edited 2024 Nov 07 4:53 AM
@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.
2024 Nov 07 6:09 AM
Thanks to @Sandra_Rossi and @raymond_giuseppi for your valuable time. I solved it as per guideline.
Regards-
Rajib