on 04-01-2014 4:14 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
I am getting MATNR from each of E1EDP01 and E1EDL44 and sometimes they are same values so I need to remove if any duplicate values coming and only pass single value to target material field. I will need to map MATNR to both E1EDP01 and E1EDL44 and filter either by queue or context. I had seen above mapping but could not think of using it for two source fields.
Thanks,
Marko
Dear Marko P
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.