topic Re: ALV Excel output missing fields in Application Development and Automation Discussions

ALV Excel output missing fields

former_member657283 — Tue, 31 Mar 2020 18:20:59 GMT

Dear All,

The output grid list of FM REUSE_ALV_GRID_DISPLAY is displaied correctly with all fields visible.

Problem happens when I try to display ALV output by clicking button "Excel Sheet", there some fields disappear and no way to include them.

The issue occurs after having implemented a ZSTANDARD gui and related SET PF-STATUS as refhesh button was missing.

Any advice on what to check would be really appreciated

Thanks for your support.

Re: ALV Excel output missing fields

Sandra_Rossi — Tue, 31 Mar 2020 20:58:52 GMT

Did you create ZSTANDARD by copying the standard status STANDARD from function group SALV?

What code did you add?

Re: ALV Excel output missing fields

former_member657283 — Wed, 01 Apr 2020 07:34:52 GMT

right Sandra, I have copied the STANDAND from SALV adding ICON_REFRESH in application toolbar and that is my snippet:

FORM zf_display_alv.

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
EXPORTING
i_callback_program = sy-repid
i_callback_pf_status_set = 'SET_PF_STATUS'
i_callback_user_command = 'ALV_USER_COMMAND'
is_layout = gs_layout
it_fieldcat = gt_fieldcat[]
TABLES
t_outtab = tb_alv
EXCEPTIONS
program_error = 1
OTHERS = 2.

IF sy-subrc <> 0.
MESSAGE ID '00' TYPE 'I' NUMBER 001
WITH 'REUSE_ALV_GRID_DISPLAY call error: ' sy-subrc.
RETURN.
ENDIF.

ENDFORM.

FORM set_pf_status USING rt_extab TYPE slis_t_extab.
SET PF-STATUS 'ZSTANDARD'. "Copy of standard ALV
ENDFORM.

Re: ALV Excel output missing fields

former_member657283 — Fri, 03 Apr 2020 07:36:03 GMT

Actually, by copying status STANDARD_FULLSCREEN from program SAPLSLVC_FULLSCREEN solved my problem, just in case somebody will face same issue.

Re: ALV Excel output missing fields

Sandra_Rossi — Fri, 03 Apr 2020 07:42:20 GMT

If you do a comment under a question/answer and you want to target someone else than the question/answer' author, the only solution is to copy/paste their hyperlinked name so that the person receives a warning (NB: @ doesn't work)