Multiple line items for One Order

[Former Member]

Hi SDners,

I am working on scenario in which I have one Order which can have multiple line items as below in mapping

Order 51444 Quantity 4 Material Number 11111

Order 51444 Quantity 5 Material Number 22222

Order 51444 Quantity 6 Material Number 33333

in IDOC

segment for Line Item Material Number 11111

segment for Line Item Material Number 2222

segment for Line Item Material Number 3333

how can I achieve this

Thannks,

[former_member182412]

Hi Ritu,

For IDOC node you can use same as raghu suggested.

For ORDER and ITEM you can use below mapping.

For Material and Quantity mapping:

Output:

Regards,

Praveen.

[former_member186851]

Hello Ritu,

What you wish to acheieve?

Wish to map the mutliple segments to any structure?

[Former Member]

Hi Raghu,

I have multiple records in file which should map to IDOC structure.

if same order number has multiple line item then one IDOC should be created with multiple segments

for line items for same order with different details...

so in file

row1- Order 51444 Quantity 4 Material Number 11111

row2-Order 51444 Quantity 5 Material Number 22222

row3 Order 51444 Quantity 6 Material Number 33333

in IDOC

One IDOC

segment for Line Item Material Number 11111

segment for Line Item Material Number 2222

segment for Line Item Material Number 3333

Thanks

[former_member186851]

Hello Ritu,

Try the below Logic

OrderNumber---->Removecontexts---->Sort------>splitbyvalue---->CollapseContexts-->IdocRootNode

                                                                              (ValueChange)

MaterialNumber------------>RemoveContexts------------>Segment-----

                                                                                                              FormatByexample---->Segment

OrderNumber-------->RemoveContexts--->sort---->splitByValue------

                                                                                  (ValueChange)