Skip to Content
avatar image
Former Member

Duplicate values in message mapping

Hi Guys,

I have IDoc to file scenario and source IDoc have two same fields from two different segments but target there is only one field to send to. What is the best way and how to map two source fields to one target field by removing duplicate values from source fields? Can this be done with graphical mapping or need UDF?

Source:
<E1EDP01 SEGMENT="">
    <MATNR>12345</MATNR>
     </E1EDP01>
<E1EDL44 SEGMENT="">
<MATNR>12345</MATNR>
</E1EDL44>

Target:
<Material>12345</Material>

Thanks,

Marko

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 01, 2014 at 03:19 PM

    Hi Marko - How are you creating the target root element.. one for each E1EDL44 ?

    If so to remove the duplicates  try the below mapping.

    MATNR (E1EDL44 ) -> remove contexts ->sort -> split by value (value changed) ->collapse context -> split by value(for each value) - target field

    if there would be only one material always, then it doesn't matter which one you map.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Mark - it is a bit unclear on the target structure.

      Can you please share the sample source xml and expected output?

      If you just want to remove duplicates(MATNR) then above mapping should work. Did you try..

  • avatar image
    Former Member
    Apr 01, 2014 at 05:43 PM

    Dear Marko P

    Validate your specification ... since the E1EDL44-MATNR segment (Handling Unit Item) field can be different from E1EDP01-MATNR (Item General Data), you should check with consultant SAP which position the delivery to be mapped. Based on this definition should apply the mapping.
    regards
    Juan

    Add comment
    10|10000 characters needed characters exceeded