topic Re: Customize the standard application tool in alv report in Application Development and Automation Discussions

topic Re: Customize the standard application tool in alv report in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/customize-the-standard-application-tool-in-alv-report/m-p/4780900#M1120015 <HTML><HEAD></HEAD><BODY><P>ii</P><P>go to tcode se41</P><P>then go to copy pf status giving bcalv_test_list_dispaly and give the status name as standard</P><P>and then give the sttaus name that you have declared in prog and copy.</P><P>thanx.</P></BODY></HTML> Thu, 27 Nov 2008 06:27:23 GMT Former Member 2008-11-27T06:27:23Z Customize the standard application tool in alv report https://community.sap.com/t5/application-development-and-automation-discussions/customize-the-standard-application-tool-in-alv-report/m-p/4780895#M1120010 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I want to disable only Excel button of the application tool bar in the alv report. So, i want the process how i can do that...please help me with a sample code......</P><P></P><P>Thanks,</P><P>Rocky.</P></BODY></HTML> Wed, 26 Nov 2008 20:00:03 GMT https://community.sap.com/t5/application-development-and-automation-discussions/customize-the-standard-application-tool-in-alv-report/m-p/4780895#M1120010 Former Member 2008-11-26T20:00:03Z Re: Customize the standard application tool in alv report https://community.sap.com/t5/application-development-and-automation-discussions/customize-the-standard-application-tool-in-alv-report/m-p/4780896#M1120011 <HTML><HEAD></HEAD><BODY><P>you got to edit the PF status and set ur own pf status..</P><P></P><P>search in the forum fro <STRONG>set pf-status</STRONG></P><P></P><P><STRONG>tip:</STRONG> copy the pf status named standard and edit as per ur req.</P></BODY></HTML> Wed, 26 Nov 2008 20:04:15 GMT https://community.sap.com/t5/application-development-and-automation-discussions/customize-the-standard-application-tool-in-alv-report/m-p/4780896#M1120011 former_member156446 2008-11-26T20:04:15Z Re: Customize the standard application tool in alv report https://community.sap.com/t5/application-development-and-automation-discussions/customize-the-standard-application-tool-in-alv-report/m-p/4780897#M1120012 <HTML><HEAD></HEAD><BODY><P>Hi Joy,</P><P></P><P>Thanks for u r reply, but i dnt know how to copy that standard pf status.</P><P>Please explain me with a sample code....</P><P></P><P>Thanks,</P><P>Rocky.</P></BODY></HTML> Thu, 27 Nov 2008 05:40:05 GMT https://community.sap.com/t5/application-development-and-automation-discussions/customize-the-standard-application-tool-in-alv-report/m-p/4780897#M1120012 Former Member 2008-11-27T05:40:05Z Re: Customize the standard application tool in alv report https://community.sap.com/t5/application-development-and-automation-discussions/customize-the-standard-application-tool-in-alv-report/m-p/4780898#M1120013 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>you can copy pf status using SE41 transaction.</P></BODY></HTML> Thu, 27 Nov 2008 05:41:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/customize-the-standard-application-tool-in-alv-report/m-p/4780898#M1120013 GauthamV 2008-11-27T05:41:59Z Re: Customize the standard application tool in alv report https://community.sap.com/t5/application-development-and-automation-discussions/customize-the-standard-application-tool-in-alv-report/m-p/4780899#M1120014 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P><STRONG>Note : this is sample code. the fct codes for Excel are to be checked.</STRONG></P><P></P><P>In ALV with OO you can do this to disable some fields</P><P></P><P> data: ls_exclude type ui_func,</P><P> lt_toolbar_excluding type ui_functions.</P><P></P><P> ls_exclude = cl_gui_alv_grid=>mc_mb_export.</P><P> append ls_exclude to lt_toolbar_excluding.</P><P> ls_exclude = cl_gui_alv_grid=>mc_mb_view.</P><P> append ls_exclude to lt_toolbar_excluding.</P><P></P><P>call method g_alv_grid3->set_table_for_first_display</P><P> exporting</P><P> is_layout = gs_layout</P><P> is_variant = h_layout</P><P> i_save = 'U'</P><P> it_toolbar_excluding = <STRONG>lt_toolbar_excluding</STRONG></P><P> changing</P><P> it_outtab = <Internal table></P><P> it_fieldcatalog = h_t_sel_fieldcat</P><P> exceptions</P><P> invalid_parameter_combination = 1</P><P> program_error = 2</P><P> too_many_lines = 3</P><P> others = 4.</P><P></P><P></P><P></P><P>for the reuse_alv_grid_display do the following : </P><P></P><P>data: i_fcode_extab type slis_t_extab,</P><P> wa_fcode type slis_extab, </P><P></P><P></P><P> wa_fcode = 'PRNT'.</P><P> append wa_fcode to i_fcode_extab.</P><P></P><P> wa_fcode = '&OAD'.</P><P> append wa_fcode to i_fcode_extab.</P><P></P><P> wa_fcode = '&AVE'.</P><P> append wa_fcode to i_fcode_extab.</P><P></P><P> wa_fcode = '&EB9'.</P><P> append wa_fcode to i_fcode_extab.</P><P></P><P> wa_fcode = '&SUM'.</P><P> append wa_fcode to i_fcode_extab.</P><P></P><P> wa_fcode = '&UMC'.</P><P> append wa_fcode to i_fcode_extab.</P><P></P><P> wa_fcode = '&XPA'.</P><P> append wa_fcode to i_fcode_extab.</P><P></P><P> wa_fcode = '&OMP'.</P><P> append wa_fcode to i_fcode_extab.</P><P></P><P></P><P>CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'</P><P> EXPORTING</P><P> I_CALLBACK_PROGRAM = SY-REPID</P><P> IS_LAYOUT = LAYOUT</P><P> IT_FIELDCAT = IT_FIELDCAT</P><P> IT_SORT = IT_SORT</P><P> I_CALLBACK_PF_STATUS_SET = 'STATUS'</P><P> IT_EXCLUDING = <STRONG>I_FCODE_EXTAB</STRONG></P><P> I_CALLBACK_USER_COMMAND = 'USER_COMMAND'</P><P> IT_EVENTS = IT_EVENTS[]</P><P> TABLES</P><P> T_OUTTAB = IT_VBAK.</P><P></P><P>Edited by: Srinivas Manchikalapati on Nov 27, 2008 7:09 AM</P><P></P><P>Edited by: Srinivas Manchikalapati on Nov 27, 2008 7:15 AM</P><P></P><P>Edited by: Srinivas Manchikalapati on Nov 27, 2008 7:18 AM</P></BODY></HTML> Thu, 27 Nov 2008 06:09:33 GMT https://community.sap.com/t5/application-development-and-automation-discussions/customize-the-standard-application-tool-in-alv-report/m-p/4780899#M1120014 Former Member 2008-11-27T06:09:33Z Re: Customize the standard application tool in alv report https://community.sap.com/t5/application-development-and-automation-discussions/customize-the-standard-application-tool-in-alv-report/m-p/4780900#M1120015 <HTML><HEAD></HEAD><BODY><P>ii</P><P>go to tcode se41</P><P>then go to copy pf status giving bcalv_test_list_dispaly and give the status name as standard</P><P>and then give the sttaus name that you have declared in prog and copy.</P><P>thanx.</P></BODY></HTML> Thu, 27 Nov 2008 06:27:23 GMT https://community.sap.com/t5/application-development-and-automation-discussions/customize-the-standard-application-tool-in-alv-report/m-p/4780900#M1120015 Former Member 2008-11-27T06:27:23Z Re: Customize the standard application tool in alv report https://community.sap.com/t5/application-development-and-automation-discussions/customize-the-standard-application-tool-in-alv-report/m-p/4780901#M1120016 <HTML><HEAD></HEAD><BODY><P>Hi Rocky,</P><P></P><P>If you are using <STRONG>normal</STRONG> ALV report (and not object-oriented), you can do the following:</P><P></P><P>Go to SE41. Type in program name = SAPLKKBL. Status name = STANDARD.</P><P>Copy the GUI status STANDARD of SAPLKKBL to your Program.</P><P></P><P>Then you can either go to GUI status of your program (using SE41 or SE80), and simply delete the excel button. </P><P>Or write the following code for excluding it.</P><P></P><P>FORM pf_stat_set USING extab TYPE slis_t_extab.</P><P></P><P>DATA: w_extab TYPE slis_extab.</P><P>w_extab-fcode = '&XXL'.</P><P>APPEND w_extab TO extab.</P><P></P><P>*/ Setting GUI status (assuming the newly copied gui status is named as GUISTATUS1 )</P><P> SET PF-STATUS 'GUISTATUS1' EXCLUDING extab.</P><P></P><P>ENDFORM. " pf_stat_set</P><P></P><P></P><P>Note: &XXL is the function code for Excel.</P><P></P><P></P><P>If you are using <STRONG>Object Oriented</STRONG> ALV, then you can do the following:</P><P></P><P>DATA: it_excl_toolbar TYPE ui_functions.</P><P>DATA: wa_excl_toolbar TYPE ui_func.</P><P>REFRESH:it_excl_toolbar.</P><P></P><P>CLEAR: wa_excl_toolbar.</P><P>MOVE '&XXL' TO wa_excl_toolbar.</P><P>APPEND wa_excl_toolbar TO it_excl_toolbar.</P><P></P><P> CALL METHOD go_grid_alv->set_table_for_first_display</P><P> EXPORTING</P><P> i_buffer_active = 'X'</P><P> is_layout = wa_layout</P><P> it_toolbar_excluding = it_excl_toolbar</P><P> CHANGING</P><P> it_outtab = it_output[]</P><P> it_fieldcatalog = it_fcat.</P><P></P><P></P><P>Let us know if you still face any issues.</P><P></P><P>Thanks,</P><P>Nisha Vengal.</P></BODY></HTML> Thu, 27 Nov 2008 06:50:16 GMT https://community.sap.com/t5/application-development-and-automation-discussions/customize-the-standard-application-tool-in-alv-report/m-p/4780901#M1120016 Former Member 2008-11-27T06:50:16Z