PF status

[Former Member]

Hi Abappers

I copied the the PF -STATUS "STANDARD" into my custom "ZSTANDARD", and using the PF status in my list screen. almost all the function work fine except for the button for downloading into EXCEL sheet or WORD file, can any body tell me what could be the problem.

Regards

Narendiran Rathinavelu

[Former Member]

If u are able to see the buttons then probs with the USER-COMMANDS .

so u have to code for this user commands.

Regards

Prabhu

[Former Member]

Hi prabu,

Can you send me some code using which i can download the list into an excel file?

Regards

Narendiran Rathinavelu

[Former Member]

Hello,

Check on settings of that pf-status the "action" name for the download, and then on the pai check what is happening, I mean if there is any functionality for downloading into excel, check also that the action name is there.

Hope this helops,

GAbriel

[Former Member]

hi Gabriel,

Can you be more specific, where should i go and check this attribute of the PF status.

Regards

Naren

[Former Member]

You should copy the 'STANDARD' GUI status from program SAPLKKBL using transaction SE90 >Programming SubObjects> Gui Status.

Execute this transaction to get to next screen. select status using checkbox. click on GUI Status --> Copy.

Enter your Z program name and the name you what for this status - you can keep it as 'STANDARD' to be simple.

Then you can edit the new status to add or delete buttons. This will also bring in the standard SAP ALV functionality such as sorting/subtotaling etc...

Even if this doesnt work for you then you can write your code in the user_command subroutine to call the function module GUI_DOWNLOAD to download the data to excel.

CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

EXPORTING

I_CALLBACK_PROGRAM = W_REPID

I_CALLBACK_PF_STATUS_SET = 'PF_STATUS'

I_CALLBACK_USER_COMMAND = 'USER_COMMAND'

FORM USER_COMMAND USING P_UCOMM TYPE SY-UCOMM

P_SELFLD TYPE SLIS_SELFIELD.

case p_ucomm.

when '<FCODE for DOWNLOAD>'.

call function 'GUI_DOWNLOAD'

.

.

.

.

.

endcase.

ENDFORM.

I hope it helps.

Best Regards,

Vibha

*Please mark all the helpful answers