Context mapping for target segment not creating as desired

[Former Member]

Hi All,

I have the following mapping requirement :

Source Structure : Multiple delivery document with line numbers,batch numbers ,toteid's & Serial numbers.Each row in the table below is a record (0.. many).

One Target Idoc is created for one delivery.

Del#	Item#	Batch#	Material#	Serial#	ToteID	Qty
123	10	1	ABC		8123	2
123	20	1	DEF		8123	3
124	10	89	ABC		8123	2
124	10	90	ABC		8124	4
124	20	1	DEF		8123	3
125	10	1	XYZ	78	810	5
125	10	1	XYZ	79	810	1
125	10	1	XYZ	80	810	1
125	10	1	XYZ	81	810	1
125	20	1	DEF		810	3

How segments should  be created

IDOC  ( 1...9999) 1 delivery per Idoc

|

E1EDL20 ( 1...9999) ONLY 1 segment per Idoc

|_______E1EDL18

|_______E1EDT13

|_______E1EDL24 (0...9999) multiple segments per line item for a delivery

|                    |_______E1EDL11 (for serialize items only)

|                   |_______E1EDL19

|_______E1EDL37 (0...9999) multiple segments created for each tote

|                  |_______E1EDL44 (0...9999) multiple segments created for each line item under each tote

|_______ZE1EDL37 (for serialized items only)  (0...9999) multiple segments created for each tote

                   |_______ZE1EDL44 (for serialized items only)  (0...9999) multiple segments created for each line item under each tote

Everything works fine except for ZE1EDL44 segment .. I need to create 4 ZE1EDL44 segment under ZE1EDL37 occurring under 3rd Idoc (Del #125) , but it is not getting created.

This ZE1EDL44 segment is created as many times as the occurrence of Serial Number and Line Number for a delivery where the Serial Number field is not Blank.

Everything works above except for ZE1EDL44 segment below...

This ZE1EDL44 segment is created as many times as the occurrence of Serial Number and Line Number for a delivery where the Serial Number field is not Blank.

In the above example it is Del # 125 and ZE1EDL44 will be created 4 times based on 78,79,80,81 AND lineItem 10,10,10,10

Regards,

Collins

[Former Member]

Hi.

IMO ,I would recommend create a UDF for this situation. Your logic is too long.

Regards

Lucho..