Mapping One file to Many Idocs

[Former Member]

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

<ns0:MT_ASN xmlns:ns0="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

[Former Member]

I have another similar thread with some answers.

Thanks

JC

[ambrish_mishra]

Hi Jean-Claude,

I saw a similar post to which I have replied. Please close one of the threads. It will help you find solution better.

Ambrish