XML for Qualified tables (SP05)

[Former Member]

Hi all

I have a xml file like this

<?xml version="1.0" encoding="UTF-8"?>

<od:schema xmlns:od="http://www.w3.org/2001/XMLSchema" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<od:element name="Test">

<od:complexType>

<od:sequence>

<od:element name="Material_Number_R3"/>

<od:element name="ST_Code"/>

<od:element name="Family"/>

<od:element name="Line"/>

<od:element name="Category"/>

<od:element name="Ginco_R3_Code"/>

<od:element name="Material_Type"/>

<od:element name="Material_Group"/>

<od:element name="Division"/>

</od:sequence>

</od:complexType>

</od:element>

</od:schema>

And when i load it in the syndicator manager i can do the mapping, but i want to add some field of a qualified table: what should i change in my xml?

BR

PP

[KlausDavid · Accepted solution]

Hi Jose,

when you look at the delivered xsd-structures for the material master, you can see, taht Q-Lookup tables are already mirrored in these strcutres. so this could be used as a template.

You simply would define a complex type structure for the Q-lookup-table fields (I call it MFGDATA). This complex type would then be referred to in your main strucutre (I call it MFGInfo).

It would have the following for :

<?xml version="1.0" encoding="UTF-8"?>

<od:schema xmlns:od="http://www.w3.org/2001/XMLSchema" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<od:element name="Test">

<od:complexType>

<od:sequence>

<od:element name="Material_Number_R3"/>

<od:element name="ST_Code"/>

<od:element name="Family"/>

<od:element name="Line"/>

<od:element name="Category"/>

<od:element name="Ginco_R3_Code"/>

<od:element name="Material_Type"/>

<od:element name="Material_Group"/>

<od:element name="Division"/>

<xsd:element name="MFGInfo" type="MFGDATA" maxOccurs="unbounded" />

</od:sequence>

</od:complexType>

</od:element>

<xsd:complexType name="MFGDATA">

######here you define all the fields of the Q-lookup tabel #####

</xsd:complexType>

</od:schema>

Regards Klaus

[MichalKrawczyk]

hi Jose,

this is not an XML file but XML schema (so description of XML schema)

your xml file will look like this:

<?xml version="1.0"?>

<Test xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"">

<Material_Number_R3>string by default</Material_Number_R3>

<ST_Code>some string value </ST_Code>

<Family>some string value</Family>

<Line>some string value</Line>

<Category>some string value</Category>

<Ginco_R3_Code>some string value</Ginco_R3_Code>

<Material_Type>some string value</Material_Type>

<Material_Group>some string value</Material_Group>

<Division>some string value</Division>

</Test>

Regards,

michal

[Former Member]

Hi Michal

Thanks for the answer but, what do i need for add some fields of a qualified table into the xml? eg.

<b>These fields are from the Main Table</b>

<Material_Number_R3>string by default</Material_Number_R3>

<ST_Code>some string value </ST_Code>

<Family>some string value</Family>

<Line>some string value</Line>

<Category>some string value</Category>

<Ginco_R3_Code>some string value</Ginco_R3_Code>

<Material_Type>some string value</Material_Type>

<Material_Group>some string value</Material_Group>

<Division>some string value</Division>

<b>But I have a table: Manufacturer (Qualified table) with:</b>

<Manufacturer_Name>

<Part>

<Drawing>

<Brand>

I think that i need an 'special' structure to agroup this data...

BR

PP