on 11-08-2011 9:10 PM
Hi friends,
I am mapping CREMAS02 idoc to target structure and sending it to SQL.
The Graphical mapping is as below and is one to one between idoc segments and the below target structure. I am posting the xml of the target.
<BANKS type="Char">BOA</BANKS>
<BANKL type="char">0016669</BANKL>
<BANKN type="char">7669-5</BANKN>
<LIFNR type="char">9000000220</LIFNR>
<KOINH type="char">varchar</KOINH>
<BKONT type="char">01</BKONT>
<BANKA type="varchar">Banco do Brasil S.A.</BANKA>
Everything works fine when there is one bank account but when the IDOC has two bank accounts it replicates the E1LFBKM segment twice.
<E1LFBKM SEGMENT="1">
<MSGFN>005</MSGFN>
<LIFNR>9000000220</LIFNR>
<BANKS>SS</BANKS>
<BANKL>00103329</BANKL>
<BANKN>7559-5</BANKN>
<BKONT>01</BKONT>
<BANKA>B S.A.</BANKA>
<BNKLZ>005559</BNKLZ>
</E1LFBKM>
- <E1LFBKM SEGMENT="1">
<MSGFN>005</MSGFN>
<LIFNR>9000000220</LIFNR>
<BANKS>SS</BANKS>
<BANKL>1055686</BANKL>
<BANKN>0061-2</BANKN>
<BKONT>02</BKONT>
<BANKA>C FAl</BANKA>
<BNKLZ>1046686</BNKLZ>
</E1LFBKM>
The SQL is expecting the target to be in the following order XML below.
<BANKS type="Char">SS</BANKS>
<LIFNR type="char">9000000220</LIFNR>
<KUNNR type="char"></KUNNR>
<BANKL type="char">666</BANKL>
<BANKN type="char">7579-5</BANKN>
<KOINH type="char">varchar</KOINH>
<BKONT type="char">01</BKONT>
<BANKA type="varchar">B S.A.</BANKA>
<BANKL type="char">1040776</BANKL>
<BANKN type="char">0032-2</BANKN>
<KOINH type="char">varchar</KOINH>
<BKONT type="char">02</BKONT>
<BANKA type="varchar">C F A</BANKA>
Is this possible to arrange the order of the target?
Thanks,
Teresa
Hi,
i think you dealing with stored procedures at target side, you can map E1LFBKM to statement and change occurance of staement to 1 to unbounded.
Regards,
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.