Skip to Content
avatar image
Former Member

Mapping

Hi,

I have situation where the sales order are coming in Text element. For eg.

1st text element (TDLINE) contains 80010416,80010217,80010318,80010519,80010620,0080010421

It would show in source  XML with Sales order in TDLine

<E1TXTP6 SEGMENT="1">

    <TDFORMAT>*</TDFORMAT>

<TDLINE>80010416,80010217,80010318,80010519,80010620,0080010421</TDLINE>

</E1TXTP6>


Next text element contains 0080010724,0080010425,0080010426,0080010427, it will come as in idoc

<E1TXTP6 SEGMENT="1">

      <TDFORMAT>*</TDFORMAT>

<TDLINE>0080010724,0080010425,0080010426,0080010427</TDLINE>

</E1TXTP6>

Like this there are 13 text elements and each text element will create a segment E1TXTP6 , with TDline containing  sales order no

In target, I would need this to map to segment E1EDL20 where each sales order should create one segment of E1EDL20.

In above case, if i have 13 Text elements & each contains 5 sales order, on target i should have 65 E1EDL20 with each contains sales order info

Also there are 2 fields in the E1EDL20. Field VBELN would be the actual sales order no and fields XBLAN would be the first sales order of the TDLINE.

So for 1st TDLine, the E1EDL20-VBELN will be 80010416 and XBLAN would be 80010416

In next segment, E1EDL20-VBELN will be 80010217 but XBLAN would be 80010416 ( First Sales order of TDLINE)

Both the segment ( E1EDL20 & E1TXTP6 ) are at same level

I am thinking of way to do this mapping & looking for help on this..Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Dec 08, 2014 at 08:31 PM

    you can handle with udf ( queue) - split the text values by comma and store it as a result list and use node function split by value..

    Add comment
    10|10000 characters needed characters exceeded