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

[ishita_biswas2]

[DISCLAIMER:Please Note: Any Image/data in this presentation/video is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental]

Dear All,

In this blog, I would like to explain the steps to create extension field in supplier invoice excel template in SAP Business ByDesign System.

Agenda:

• Pre-Requisite


• Steps to add extension field in supplier invoice excel

Pre-Requisite:

Add the extension field via Adaption Mode and add the field in Inbound Services as per below screenshot:



Steps to add extension field in Excel:

In the below case, we have taken the header extension field ‘Test_SIV_PDI’ as example.

1. Go to Supplier Invoicing work center -> select view: Invoices and Credit memos.


2. Download the excel template from ‘Import from Microsoft excel’ option as per below screenshot.

 

3.  Once the file is downloaded, open the file location and rename .xlsx to .zip. This will automatically convert the excel file to zip and open it with your preferred zip tool.

XML file location:  NewSupplierInvoices_US_EN.zip\xl

4. Extract the XML file to specified folder and edit the same using Notepad ++ .

a) We need to add the field as part of the structure as mentioned below:

<xs:element minOccurs="0" maxOccurs="1" name="Test_SIV_PDI" type="xs:string"/>

 



 

b)There is one more change necessary in the xmlMaps.xml , in the transformations section.

<xsl:template match="Test_SIV_PDI">                                                                                                              <xsl:element namespace="http://sap.com/xi/AP/CustomerExtension/BYD/ZZZZZ"                                                                                                                                       name="Test_SIV_PDI">                                                                              <xsl:value-of select="."/>

</xsl:element>

</xsl:template>



 

5.  Replace the XML in that zip and rename it from .zip to xlsx

6.  Open the excel file and go to Developer->Source. You would be able to see extension field in XML maps ‘SAP_BYD_MAIN’.

Note: If you are unable to see, select it from the drop-down list.



 

As of now, the extensibility function is not provided in standard invoice upload excel file , hence , please contact your bydesign partner to implement the above steps as per your business requirement.

You can also check following blogs related to excel scenarios:

https://blogs.sap.com/2015/02/25/how-to-guide-for-journal-entry-voucher-excel-customization/

https://blogs.sap.com/2016/01/20/how-to-upload-data-for-custom-bo-using-excel/

https://blogs.sap.com/2014/07/28/how-to-customize-excel-import-template-example-for-marketing-leads/