on 11-03-2006 10:12 AM
Hello "Every 1"
I m facing a problem during mapping between a XML file & IDoc Str.
Problem:-
Dest IDoc is GLMAST01 whic have a str called E1SKATM which have 0 to unbound occurence. it's field are
1.MSGFN
2.SPRAS
3.TXT20
4.TXT50
The Source File That i m getting from MDM have following Str:
Occurence
1.MSGFN 0 to 1
2.SPRAS 0 to unbound
3.TXT20 0 to unbound
4.TXT50 0 to unbound
Basically it is giving all language & corresponding Act grp Name looping under single msgfn but we need it seprately
for example:
Suppose we have three lang EN, DE, Let us say French.
Then i m getting
Source source str in the following format
<-Start of Source Str>
MGSFN - 004
SPARS-E
TXT20- any string
TXT50-any string
SPARS-D
TXT20- any string
TXT50-any string
SPARS-French
TXT20- any string
TXT50-any string
<-End of Source Str>
But MY DESTINATION Str is excepting the following format
<--First Copy/Segment>
MGSFN - 004
SPARS-E
TXT20- any string
TXT50-any string
<--Second Copy/Segment>
MGSFN - 004
SPARS-D
TXT20- any string
TXT50-any string
<--Third Copy/Segment>
MGSFN - 004
SPARS-French
TXT20- any string
TXT50-any string
Thanx in advance for ur reply
In target format you need 3 MGSFN nodes.
Use the input field SPARS-e as an index.
Map
SPARS-e --> MGSFN
(check the output queue there should be 3 empty queue values, no context change)
Now check your output and you will get three MGSFN nodes.
Daniel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
that sounds well but in such a case I am not a fan of customer functions.
I tried to rebuild your scenario without a customer function and it seems to work.
<?xml version="1.0" encoding="UTF-8"?>
<ns0:Source >
<MSGFN>0004</MSGFN>
<SPRAS>e</SPRAS>
<TXT20>wer</TXT20>
<SPRAS>d</SPRAS>
<TXT20>sdfs</TXT20>
<SPRAS>g</SPRAS>
<TXT20>qqqq</TXT20>
</ns0:Source>
<?xml version="1.0" encoding="UTF-8" ?>
<ns0:Target >
<E1SKATM>
<MSGFN>0004</MSGFN>
<SPARS>e</SPARS>
<TXT20>wer</TXT20>
</E1SKATM>
<E1SKATM>
<MSGFN>0004</MSGFN>
<SPARS>d</SPARS>
<TXT20>sdfs</TXT20>
</E1SKATM>
<E1SKATM>
<MSGFN>0004</MSGFN>
<SPARS>g</SPARS>
<TXT20>qqqq</TXT20>
</E1SKATM>
</ns0:Target>
Mapping:
SPRAS --> E1SKATM
MSGFN --> CopyValue --> MSGFN
SPRAS --> SplitByValue --> SPARS
TXT20 --> SplitByValue --> TXT20
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.