Skip to Content
avatar image
Former Member

ALV Excel standard template not showing when custom template(s) exist


When clicking the Excel function button on the ALV menu, the standard sap_sm.xls template is ignored if there is one or more custom templates.

If there are no custom templates then the standard becomes the default and displays directly.

The custom templates were not developed by me and are for only required for specific reports and not relevant to the report I have written.

In method cl_alv_bds->select_template:

The program is not able to find a value for ls_layout-objectkey, I need it to find the template with object key 'SAP_STANDARD_TEMPLATE'. Because up to this point the program has not found a vlaue for ls_layout-objectkey it then looks for custom templates. In this case it finds some and then leaves the method. If there is only one template this template is applied to the output; and if there are two or more templates the program displays a list of the custom templates for the user to choose from.

It is immeadiately after the check for custom templates that the method then looks for standard templates.

Is there a way to limit the custom templates to specific reports or is there a 'fix' for this issue?

thanks in advance


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers