ALV : How to activate List -> Export -> Spreadsheet

[Former Member]

Hi all,

I have tried to search this forum n google regarding on the above problem but couldn't find any answer. Therefore, i have decided to post this question here.

I have ALV report but somehow i couldn't Export -> spreadsheet directly. It was disable in my report.

I can still export my spreadsheet via Local file.

How do i enable the List-> Export -> Spreadsheet? Please help.....

Thank you in advance.

Regards,

SW

[Former Member]

Hi,

ALV grid has export option of Excel sheet.

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

i_callback_program = sy-repid

it_fieldcat = it_fieldcat

i_save = 'A'

TABLES

t_outtab = it_item

EXCEPTIONS

program_error = 1

OTHERS = 2.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

Please check and pass posible paramters

Regards

[Former Member]

Hi,

Check your source code if you have disabled the spreadsheet option in ALV toolbar.

regards

vivek

[Former Member]

Hi,

Press

Ctr+Shift+F9

Regards,

Pravin

[Former Member]

Hi,

I your report the code where you have set the pf-status,

double click on that pf status, it will take you to se41 tcode

having your pf status details.

There you can try doing,

EXTRAS->ADJUST TEMPLATE.

This will enable all the status options of your ALV output.

Hope it helps

Regards

Mansi

[former_member198032]

Hi,

this may help:

1678355 - Cannot export Line Items Display Reports to different spreadsheet file formats

Regards,

Cristiano