Adding SDK created extension field in Excel Upload Template (SalesOrder)

[may_thitsaoo]

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.

PES_SalesOrder_Items.xs for Item node.

Active and CheckIn PES.

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

Step 4 : Download Excel Template from browser.

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

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

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

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.

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.

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.

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.

Save the xml.

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

Step 11 : Chane the zip file extension as xlsx.

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

[S4_Hana]

Thank you, very helpful!

 

[former_member568054]

HI may.thitsaoo,

Very nice document and you described it in detail.

Please help me with the functionality below.

I have created two new extension fields at the item level in Sales Order. The two new extension field data type is Amount and Date. So, how do to add those two fields to the SO Standard Excel?

Thanks in advance,

Regards,
Yogaraj

[may_thitsaoo]

Hello Yogaraj,

 

Adding item extension field also explained in the blog. Could you please describe what exactly part you don't get? (eg: DataType in xml)

 

Regards,

May

[former_member568054]

Hi may.thitsaoo

Hope you are doing well and thank you very much for your response.

I have tested all the functionality as you mentioned in the above document which works well (If that field is text (string)).

I would like to add 2 new extension fields in the SAP standard SO excel upload tool. So, I have created two new extension fields in the system and those fields are extended to SO webservice. The field data type is Date and Amount.

My two new extension fields Data type is the date and amount. I changed my data type in XML. But I am getting an error message in excel. So, here my request is: How to add Amount and Date field datatype extension field in a standard template.

Thanks in advance,

Regards,

Yogaraj

[may_thitsaoo]

Hello Yogaraj,

So, DataType declaration missing is the error cause in your case.

If the fields are Date and Amount, in Step 8, try as below in Item nodes.

<xs:element minOccurs="0" maxOccurs="1" name="yourdatefield" type="tns:Date"/>

<xs:element minOccurs="0" maxOccurs="1" name="youramountfield" type="tns:AmountType"/>

And, for the datatype declaration, Date is already available in the existing xml, you just need to declare the AmountType  as below.

<xs:simpleType name="Amount.Content">

	<xs:restriction base="xs:decimal">

		<xs:totalDigits value="28"/>

		<xs:fractionDigits value="6"/>

		<xs:maxInclusive value="9999999999999999999999.999999"/>

		<xs:minInclusive value="-9999999999999999999999.999999"/>

	</xs:restriction>

</xs:simpleType>

<xs:complexType name="AmountType">

	<xs:simpleContent>

		<xs:extension base="tns:Amount.Content">

			<xs:attribute name="currencyCode" type="tns:CurrencyCode"/>

		</xs:extension>

	</xs:simpleContent>

</xs:complexType>

 

Hope this helps.

Regards,

May

[former_member6047]

Hi May,

Thank you very much for the detailed information on this.

Here, I have created an extension field (Field Name: TestAmount) in the Sales Order screen at the item level via Adaptation mode. After that, I have followed the above steps in the XML file. As per your above instruction.

First, I have declared the extension field value in XML. And converted from zip format to xlsx format the field is available in xlsx then I have mapped it in excel. but the value is not updated/added in the Sales Order screen.

Below I have given step by step which I tried in the Standard excel template to get the extension field value in ByD.

Image 1:

Image 2:

Image 3: I have mapped the field successfully without any error on the excel file.

Image 4: I have tested the file with some sample data. I am getting a successful message in an excel file.

Image 5: The given amount value is not added in the Sales Order Item.

Kindly help me with this issue to resolve.

Thanks in advance!

BR,

Yogaraj G