How can I customize an Excel import template with PDI fields created in SDK?

[former_member25364]

Hello

The goal is to modify the quote creation excel template of the Sales Quote.

Step 1 : In SAP Cloud Application Studio, create the extension fields, extend the UI, extend the webservices.

Step 2 : Modify the excel template

Step 1 :

In SAP Cloud Applications Studio, I have extended the Customer Quote BO with 3 text fields. The type is LANGUAGEINDEPENDANT_EXTENDED_Text for the three fileds.

One is at Root level. The two others are at the Item Node level.

I have extended the Sales Quote Work Center UI in UI designer to display these fields.

I have created an Process Extension Scenario to extend the webservices ManageCustomerQuoteIn and QueryCustomerQuoteIn at Root and Item Level.

I have tested the webservices in SOAPUI with the following results :

1) Query Customer Quote In : I query an existing quote and I take the new fields values entered in the Work Center.

2) Manage Customer Quote In : I request a change of values in the extension fields of an existing quote, I have a change confirmation as response and when I query the modified quote, I have the new values in the extension fields. But when I display the quote in the work center, the values of the extension fields didn't change. So I check the values in the Repository Explorer and the new values appear in the table.

I think the problem comes from the extension fields' type. Is it better to use a LanguageDependantText type if the fields will be used in a webservice ? Or does the problem come from elsewhere ?

Step 2 :

I have followed the steps described in how-to-customize-excel-import-template-example-for-marketing-leads to add the fields but I faced the following problem:

In the wsdl file, the extension fields are defined as :

In the root node :

<xsd:group ref="xi7:Ext00163E0C0ED81ED888E76C5DD68E4BBF"/>

In the Items node :

<xsd:group ref="xi7:Ext00163E0C0ED81ED888E8B33353D7F515"/>

<xsd:group ref="xi7:Ext00163E0C0ED81ED888E8B4C3A5D5F520"/>

The xsd:group with the generated types are defined as :

<xsd:schema targetNamespace="http://XXXXXXXXXX-one-off.sap.com/YFROULMZY_" xmlns="http://XXXXXXXXXX-one-off.sap.com/YFROULMZY_" xmlns:ccts="urn:un:unece:uncefact:documentation:standard:CoreComponentsTechnicalSpecification:3.0" xmlns:xi12="http://sap.com/xi/AP/Extensibility/GeneratedObjects" xmlns:xi14="http://sap.com/xi/AP/FO/PriceAndTax/Global" xmlns:xi2="http://XXXXXXXXXX-one-off.sap.com/YFROULMZY_" xmlns:xi4="http://sap.com/xi/SAPGlobal20/Global" xmlns:xi5="http://sap.com/xi/AP/Common/Global" xmlns:xi6="http://sap.com/xi/A1S/Global" xmlns:xi7="http://sap.com/xi/DocumentServices/Global" xmlns:xi8="http://sap.com/xi/AP/Common/GDT" xmlns:xi9="http://sap.com/xi/BASIS/Global">
			<xsd:import namespace="http://sap.com/xi/AP/Extensibility/GeneratedObjects"/>
			<xsd:group name="Ext00163E0C0ED81ED888E76C5DD68E6BBF">
				<xsd:sequence>
					<xsd:element form="qualified" minOccurs="0" name="Z_DSCustomerContact" type="xi12:Ext00163E0C0ED81ED7B7F9BFABD6008E4B"/>
				</xsd:sequence>
			</xsd:group>
			<xsd:attributeGroup name="Ext00163E0C0ED81ED888E76C5DD68E6BBF"/>
			<xsd:group name="Ext00163E0C0ED81ED888E8B33353D7D515">
				<xsd:sequence>
					<xsd:element form="qualified" minOccurs="0" name="Z_DSCharacter" type="xi12:Ext00163E0C0ED81ED7B7F9D9AC79188F48"/>
				</xsd:sequence>
			</xsd:group>
			<xsd:attributeGroup name="Ext00163E0C0ED81ED888E8B33353D7D515"/>
			<xsd:group name="Ext00163E0C0ED81ED888E8B4C3A5D5D520">
				<xsd:sequence>
					<xsd:element form="qualified" minOccurs="0" name="Z_DSProduct" type="xi12:Ext00163E0C0ED81ED7B7F9E92F6BE29011"/>
				</xsd:sequence>
			</xsd:group>
			<xsd:attributeGroup name="Ext00163E0C0ED81ED888E8B4C3A5D5D520"/>
		</xsd:schema>

How Can I insert these definition in the xmlMaps file ?

Regards

Emmanuel Da Costa