Skip to Content
0
Former Member
Jun 03, 2013 at 10:22 AM

Mapping One file to Many Idocs

15 Views

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

  1. Order Number -> 1 Idoc per Order
  2. OrderLineNumber -> 1 segment per order Item E1EDL24 for the order
  3. Case -> 1 segment E1EDL37 per case for the Order Number
  4. Line Number ->1 segment E1EDL44 per line in the case

Thanks a lot

Jean-Claude