on 08-22-2013 4:04 PM
Hi,
I have a mapping as below and want to map qualifers in in each segment to target structure. In below source code there are two E1EDP01 segmentes but have different POSEX type. At the same time they have subnode called E1EDP19 with same qualifier. How to take first POSEX:000010's qualifer of E1EDP19. ?
Im using useoneasMany function but don't know how to seperate two same qualifer as their root posex number.
Source
<E1EDP01 SEGMENT="1">
<POSEX>000010</POSEX>
<MENGE>1.000</MENGE>
<E1EDP02 SEGMENT="1">
<QUALF>001</QUALF>
<BELNR>54321</BELNR>
</E1EDP02>
<E1EDP19 SEGMENT="1">
<QUALF>010</QUALF>
<IDTNR>A12345678</IDTNR>
</E1EDP19
</E1EDP01>
<E1EDP01 SEGMENT="1">
<POSEX>000020</POSEX>
<MENGE>1.000</MENGE>
<E1EDP02 SEGMENT="1">
<QUALF>001</QUALF>
<BELNR>54321</BELNR>
</E1EDP02>
<E1EDP19 SEGMENT="1">
<QUALF>010</QUALF>
<IDTNR>A12345678</IDTNR>
</E1EDP19
</E1EDP01>
Target
- <E1EDP19 SEGMENT="1">
<QUALF>010</QUALF>
<IDTNR></IDTNR>
<IDTNR_EXTERNAL></IDTNR_EXTERNAL>
<IDTNR_GUID></IDTNR_GUID>
</E1EDP19>
this is repating node
Thanks in advcance
Tahir
Thanks for fast responses. The target should look like below.
<LIN> // From POSEX = 10
<QUALF>001</QUALF>
<BELNR>21938</BELNER>
<LIN>
<LIN> // From POSES = 20
<QUALF>001</QUALF>
<BELNR>1212</BELNER>
<LIN>
As you can see same qualf from different E1EDP01 line item.
My rule basically should be like this
Source: E1EDP01(POSEX=10) -> E1EDP19(QUALF=001)-> BELNR to Target: LIN->BELNR
Source: E1EDP01(POSEX=20) -> E1EDP19(QUALF=001)-> BELNR to Target: LIN->BELNR
Each E1EDP01 line can have same QUALF as you know.This is what i coulndt resolved. If there would be a key value inside E1EDP19 childnode which match to E1EDP01 rootnode. Then i may extract the value.
Thanks in advcance
Tahir
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tahir,
E1EDP01 are line item segments and E1EDP19 is a child segment. Depends upon how you are populating the target. Can you share your target structure and rule for the parent node and subsequent fields.
Ambrish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Could you elaborate on how will the target will look like. Is it such that target E1EDP19 will be created as many times as different Qualifiers are there. This can be done by having Split by value(Value Change) but please explain in detail. Also where will you map POSEX in target?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.