Skip to main content

How to resolve Common Error : Standard Template "sap_sm.xls" missing

Hey everyone, putting forward a common error we usually face when we have “Excel inplace” functionality enabled in our SAP system.

This error occurs when validity of the signature of SAP standard templates expired or were incorrectly delivered via support packages.

We can reproduce the error by doing as below..

Click on “spreadsheet” icon after any SAP ALV grid view of data is on screen to make this data to export into excel directly from SAP.

 But, instead of exporting into excel you will see below pop-up.

To overcome this, we need to place a valid standard template in system by removing the old ones. 


Best Approach : 

1. check and remove duplicate entries of template and check if issue is resolved.

2. if issue still exists, delete the old templates from 000 client.

3. upload the new template into 000 client and if this solution needs to be transported to next landscape(from dev to prod) use check box "transport request" and capture the template in TR.

4. Test the template using report BCALV_BDS_MAINTENANCE.


Solution: 

 To check the existing templates, delete the old templates(the expired ones) or to upload new templates.

Below snote will have the SAP latest excel standard template file attached in Attachments section. Upload the template and the issue is resolved.


Important things to know before Appling the solution :

  • Anything related to templates should be done from 000 client.
  • Only SAP_SM.xls and SAP_SM.xlsm is needed in the system from the SAP standard templates. (Sap_om.xls and sap_mm.xls files aren’t required anymore.)
  • Above SAP Basis 700 it is possible that templates exist only in CLIENT 000 and the business client can use them from there. This is recommended by SAP.
  • Mixed template uploading cause errors which means that if one template is uploaded to business client the system will search every template there and won’t use them from client 000.
  • Template duplication causes error.           

 

References : 

https://me.sap.com/notes/1686797

https://me.sap.com/notes/0001937247

Labels:
Location: 170, NH65, near Himalaya Book World, Bhagya Nagar Society Colony, Nampally, Hyderabad, Telangana 500457, India

Comments

Post a Comment

You might find these interesting

8 Must-Know Questions About Object Store on SAP Business Technology Platform

What is the problem that Object Store solves ? Modern enterprise systems increasingly deal with massive volumes of unstructured data such as documents, logs, media files, and backups. Traditional relational databases are not optimized for such workloads. What is Object Store ? Object storage—commonly referred to as blob storage—addresses this gap by providing scalable, durable, and cost-efficient storage for unstructured data. Object storage is a storage architecture designed to manage unstructured data as discrete units called objects.  Each object consists of: Binary data (file content) : Image , File etc Metadata (descriptive attributes) : File size, Content type, Last modified timestamp, Storage class (hot, cool, archive) Unique identifier (key or URL) : unique path-like string used to locate a blob inside a bucket Unlike file systems or relational databases, object storage does not rely on hierarchical file structures or schemas. The SAP BTP Object Store service is a managed, ...
Post a Comment
Read more