Skip to Content
0
Former Member
Jun 10, 2016 at 05:19 AM

Multiple supplier ID entry in Material Master by Excel Customization

57 Views

Hi Experts,

In Material Master Excel Template, I would like to add the existing fields (SupplierInternalID and ProductSupplierID) to data import excel template. I added the following codes in that template. I could also add the fields into that excel. But it didn't save(import) the data correctly.

Could you please kindly help?

<xs:element minOccurs="0" maxOccurs="1" name="SupplierPartNumber">

<xs:complexType>

<xs:sequence>

<xs:element minOccurs="0" name="SupplierPartNumber__1" type="tns:SupFlatType"/>

<xs:element minOccurs="0" name="SupplierPartNumber__2" type="tns:SupFlatType"/>

</xs:sequence>

<xs:attribute name="actionCode" type="tns:ActionCode"/>

<xs:attribute name="supplierPartNumberListCompleteTransmissionIndicator" type="tns:Indicator"/>

</xs:complexType>

</xs:element>

<xs:complexType name="SupFlatType">

<xs:sequence>

<xs:element minOccurs="0" maxOccurs="1" name="SupplierInternalID" type="tns:BusinessPartnerInternalID"/>

<xs:element minOccurs="0" maxOccurs="1" name="ProductSupplierID" type="tns:ProductPartyID"/>

</xs:sequence>

<xs:attribute name="actionCode" type="tns:ActionCode"/>

<xs:attribute name="supplierPartNumberListCompleteTransmissionIndicator" type="tns:Indicator"/>

</xs:complexType>

<xs:simpleType name="BusinessPartnerInternalID">

<xs:annotation>

<xs:documentation xml:lang="EN">

<ccts:RepresentationTerm xmlns:ccts="urn:un:unece:uncefact:documentation:standard:CoreComponentsTechnicalSpecification:3.0">Identifier</ccts:RepresentationTerm>

</xs:documentation>

</xs:annotation>

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

<xs:maxLength value="10"/>

<xs:minLength value="1"/>

</xs:restriction>

</xs:simpleType>

<xs:simpleType name="ProductPartyID">

<xs:annotation>

<xs:documentation xml:lang="EN">

<ccts:RepresentationTerm xmlns:ccts="urn:un:unece:uncefact:documentation:standard:CoreComponentsTechnicalSpecification:3.0">Identifier</ccts:RepresentationTerm>

</xs:documentation>

</xs:annotation>

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

<xs:maxLength value="60"/>

<xs:minLength value="1"/>

</xs:restriction>

</xs:simpleType>

<xsl:template match="*[starts-with(local-name(),'SupplierPartNumber__')]">

<xsl:element name="SupplierPartNumber">

<xsl:attribute name="actionCode">

<xsl:value-of select="'04'"/>

</xsl:attribute>

<xsl:attribute name="supplierPartNumberListCompleteTransmissionIndicator">

<xsl:value-of select="'false'"/>

</xsl:attribute>

<xsl:apply-templates/>

</xsl:element>

</xsl:template>

Best Regards,

ThiriZun

Attachments

img-01.png (43.4 kB)