Transpose internal table using dynamic table creation

former_member641233 — Mon, 24 Feb 2014 06:16:44 GMT

I have an internal table with only one column it_table:

it_table:

sales_org

distribution_channel

division

material

Now I want to transpose this table so that i can download the table in an excel with only one row:

sales_org distribution_channel division material.......

Please help me to implement this?

Re: Transpose internal table using dynamic table creation

Former Member — Wed, 05 Mar 2014 15:50:40 GMT

Hi,

You can create a dynamic table using some code like this:

TRY.

FREE lo_st_type.

lo_st_type = cl_abap_structdescr=>create( gt_cols ).

IF lo_st_type IS NOT INITIAL.

CREATE DATA lo_st_data TYPE HANDLE lo_st_type.

UNASSIGN <fs_data_wa>.

ASSIGN lo_st_data->* TO <fs_data_wa>.

CREATE DATA lo_data LIKE STANDARD TABLE OF <fs_data_wa>.

UNASSIGN <g_table>.

ASSIGN lo_data->* TO <g_table>.

ENDIF.

CATCH cx_sy_table_creation.

ENDTRY.

gt_cols is type abap_component_tab and should have as many lines as your table it_table.

After you create the dynamic table you have to fill it with the info in it_table.

Try it out and I will help you if needed.

Martin