ALV Column Name in Excel download

1232 Views

Need Long Text for ALV column in the excel download.Appreciate anyone feedback.

In the below code when i download my ALV report into Excel for column "ADATUM"

i have the short text "Acp UpDate" . However i want 'Acceptance Upload Date'

Current Code:

DATA: gx_column TYPE REF TO cl_salv_column_table.

LOOP AT gt_column_ref INTO gv_column_ref.

TRY.

gx_column ?= gx_columns->get_column( gv_column_ref-columnname ).

CATCH cx_salv_not_found.

ENDTRY.

IF gx_column IS NOT INITIAL.

CASE gv_column_ref-columnname.

WHEN 'ADATUM'.
gx_column->set_short_text( 'Acp UpDate'(025) ). "The excel download of ALV report displays this Short Text.
gx_column->set_medium_text( 'Accp Upload Date'(022) ).
gx_column->set_long_text( 'Acceptance Upload Date'(019) ).

ENDCASE.

ENDLOOP.