SAP Knowledge Base Article - Public

2781334 - Extending the Extension Field to Excel Template

Symptom

You would like to know how to add any Extension Field to the Microsoft Excel Template, as you have noticed that when opening the Supplier Invoice Excel Template, some of the fields are not displaying as expected or when updating an already maintained fields in the  Excel template, the values are not getting retrieved by the system for newly created entries.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Open the Excel Template.
  2. See that the expected field is not available.

Cause

Not all fields are available in the Standard Excel Template, the change need to be done by Partner. If you already added the field and is still not being displayed, the extended field could be mapped incorrectly in XML.

Resolution

Please contact your partners to go through the details given in the document attached to resolve this issue.
Restructure the excel mapping for extension field and try updating the same.

See Also

For more information on how to add an Extension Field in the Excel, please check the following Blog post: 

How to Add Extension Field in Supplier Invoice Upload Excel Template?

Keywords

Add Extension Fields to Excel, Extension Field, Excel Add-in, Microsoft Excel , KBA , how to add extension fields , extension field , add extension fields to excel , add field to excel , SRD-MD-PRD-PRD , Product , AP-POP-PO , Purchase Order , How To

Product

SAP Business ByDesign all versions

Attachments

Adding ext fields to excel.pdf
How to add the extension field in Excel.docx