Hello Guru’s,
I have a complex mapping to do, and I’m a little bit lost.
I have a XML file, and I need to generate for each file one to many Idocs following the OrderNumber.
The XML structure and the Idoc DELVRY05 rules for this mapping are explain next.
ASN xml file
www.bia.be:komatsu">
<InvoiceNumber>PSI/13002432</InvoiceNumber>
<Supplier>
<Identifier>Supplier1</Identifier>
<Name>Supplier</Name>
...
</Supplier>
<ShipTo>
<Identifier>Supplier1</Identifier>
<Name>Supplier</Name>
...
</ShipTo>
<Invoicee>
<Identifier>Supplier1</Identifier>
<Name>Supplier</Name>
...
</Invoicee>
<Case Identifier="Box 1" Type="Carton">
<CaseSize Unit="CM" Height=" 21" Length=" 42" Width=" 25"/>
<CaseWeight Unit="KG" Gross=" 14.00" Net=" 13.70"/>
<Line Number="1">
….
<OrderNumber>10</OrderNumber>
<OrderLineNumber> 1</OrderLineNumber>
…
</Line>
<Line Number="2">
….
<OrderNumber>10</OrderNumber>
<OrderLineNumber> 2</OrderLineNumber>
…
</Line>
<Line Number="3">
….
<OrderNumber>10</OrderNumber>
<OrderLineNumber> 4</OrderLineNumber>
…
</Line>
</Case>
<Case Identifier="Box 2" Type="Carton">
<CaseSize Unit="CM" Height=" 21" Length=" 42" Width=" 25"/>
<CaseWeight Unit="KG" Gross=" 14.00" Net=" 13.70"/>
<Line Number="1">
….
<OrderNumber>10</OrderNumber>
<OrderLineNumber> 3</OrderLineNumber>
…
</Line>
<Line Number="2">
….
<OrderNumber>10</OrderNumber>
<OrderLineNumber> 5</OrderLineNumber>
…
</Line>
</Case>
<Case Identifier="Box 3" Type="Carton">
<CaseSize Unit="CM" Height=" 21" Length=" 42" Width=" 25"/>
<CaseWeight Unit="KG" Gross=" 14.00" Net=" 13.70"/>
<Line Number="1">
….
<OrderNumber>11</OrderNumber>
<OrderLineNumber> 1</OrderLineNumber>
…
</Line>
<Line Number="2">
….
<OrderNumber>11</OrderNumber>
<OrderLineNumber> 2</OrderLineNumber>
…
</Line>
<Line Number="3">
….
<OrderNumber>11</OrderNumber>
<OrderLineNumber> 3</OrderLineNumber>
…
</Line>
</Case>
</Message>
</ns0:MT_ASN>
Idoc Splitting
Thanks a lot
Jean-Claude