Skip to Content

Hi,

I would like to share how to add extension fields in standard Excel Upload template.

Step1 : Create SalesOrder xbo.

Step2 : Create Process Extension Scenario of SalesOrder BO.

I’ll create one ext field in Root and one in Item node, so, two PES is also needed to create for Root and Item node.

Check Inbound service (ManageSalesOrderIn) with MaintainBundle operation.

PES_SalesOrder_Root.xs for Root node.

/wp-content/uploads/2015/12/1_841981.png

PES_SalesOrder_Items.xs for Item node.

/wp-content/uploads/2015/12/2_842000.png

Active and CheckIn PES.

/wp-content/uploads/2015/12/3_842001.png

Step 3 : Add PES name in front of the extension field. Save and Activate xbo.

/wp-content/uploads/2015/12/4_842002.png

Step 4 : Download Excel Template from browser.

/wp-content/uploads/2015/12/excelso_842006.png

Step 5 : Also download SalesOrder wsdl (MaintainBundle operation).

/wp-content/uploads/2015/12/wsdlpic_842007.png

Step 6 :  Manually change download excel file extension as zip and click OK.

/wp-content/uploads/2015/12/zp_842008.png

Step 7 : Unzip the file and open to see the contents. Then open xmlMaps.xml with text editor (I’m using Notepad++).

/wp-content/uploads/2015/12/xl_842012.png

Step 8 : Add the root level extension field.

In this case, the datatype of this ext field is declared as SalesTypeCode (custom code list datatype) in xbo.

So, type should be the same as xbo.

/wp-content/uploads/2015/12/rt_842013.png

But, this datatype “SalesTypeCode” is custom type so we need to add that also in xml. You can see other standard datatypes are contained about the middle of xml. Just copy some type and edit.

/wp-content/uploads/2015/12/stt_842014.png

Step 8.1 : Add item level extension field.

You should add this under “Item” contents. Data type is declared as Text types in xbo, so it can be declared as string.

/wp-content/uploads/2015/12/it_842018.png

This is used standard type so no need to declare datatype.

Step 9 : Search this codes in your xml.

match=”*[contains(local-name(),’__’)]

And add the following codes before that.

<xsl:template match=”salesTypeTest”>

  <xsl:element namespace=”http://refsystems.sap.com/YGPXKE9HY_” name=”salesTypeTest”>

  <xsl:value-of select=”.”/>

  </xsl:element>

</xsl:template>

<xsl:template match=”itemTest”>

  <xsl:element namespace=”http://refsystems.sap.com/YGPXKE9HY_” name=”itemTest”>

  <xsl:value-of select=”.”/>

  </xsl:element>

</xsl:template>

You can find the namespace in wsdl file.

Open wsdl file with text editor and search your ext field name and copy namespace.

/wp-content/uploads/2015/12/namspc_842056.png

Save the xml.

Step 10 : Select these files and create zip.(I used 7zip)

/wp-content/uploads/2015/12/zpp_842261.png

Step 11 : Chane the zip file extension as xlsx.

/wp-content/uploads/2015/12/xlsxcg_842262.png

Open excel file and now you can see your extension fields in excel template xml.

/wp-content/uploads/2015/12/rtxl_842268.png

/wp-content/uploads/2015/12/itemxls_842269.png

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply