BYD2411 How to add extension field to excel template.

[SAPSupport]

Dear SAP,

The extension field in Journal Entry Vouchers been extended to webservice. How to add extension field to excel template to create Journal Entry Vouchers from excel？

Best Regards.

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Dear Customer,

You can following the below steps:

1. Go to Audit - Journal Entry Vouchers .
2. Click New -> Journal Entry Vouchers from Microsoft Excel 
3. Once you download the template, change the file extension to zip
4. Open the zip
5. Extract xmlMaps.xml in folder xl and open with any xml editor tool
6. Locate the Schema ManageAccountingEntryIn
7.  Add the following code in the position that you desited
   1. <xs:element minOccurs="0" maxOccurs="1" name="Field name" type="field type"/>
8. Locate <xsl:template match="*[contains(local-name(),'__')]">，before it add following code
   1. <xsl:template match="Field name">
      <xsl:element namespace="The name space of the extension field" name="Field name">
      <xsl:value-of select="."/>
      </xsl:element>
      </xsl:template> 
9. Save
10. Replace the original xmlMaps.xml with the modified one
11. Change the file extension back to xlsx
12. Open it in Excel
13. Go to Developer -> Source
14. Once you click on the source button, you should see the underlying data structure associated with it. To determine which cell is mapped to which attribute, select the cell and you can see the mapping on your right-hand side. This also works vice-versa. To map a cell to an attribute, select a column in the excel and simply right-click on the XML field and click "map element".
15. Save the excel
16. Go to Application and User Management  -> Microsoft Office Template Maintenance
17. Find the same template
18. Upload and publish the modified excel file.

Best Regards,

Cariford