SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software SAP ABAP Programming and HANA Database Tutorials
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.




CRM Companies List
Web Based CRM Software


The following template is missing: sap_sm.xls


When I try to export ALV grid data to Excel using toolbar icons, I got "Contact your system administrator. The following template is missing: sap_sm.xls" error message recently on a new installed SAP system client.

After data is displayed on an SAP ALV grid in your ABAP program, click on Excel icon

export SAP ALV grid data to Excel in ABAP program

Following error occurs.

The following template is missing: sap_sm.xls

Contact your system administrator. The following template is missing: sap_sm.xls
Message no. 0K407

For the solution an ABAP programmer can simply execute following ABAP report BCALV_BDS_IMPORT_SAP_TEMPLATE titled as "ALV Import of SAP_STANDARD_TEMPLATE from Client 000" which copies standard templates for ALV from 000 client to current client.

After executing ABAP program BCALV_BDS_IMPORT_SAP_TEMPLATE using SE38 or SA38 transaction codes, after the Excel button is clicked data will be displayed within an Excel document.






SAP Tutorials

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table








Copyright © 2004 - 2017 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems