cancel
Showing results for 
Search instead for 
Did you mean: 

BYD2411 How to add extension field to excel template.

SAPSupport
Employee
Employee
0 Kudos
124

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.
View Entire Topic
SAPSupport
Employee
Employee
0 Kudos

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