Skip to Content
avatar image
Former Member

Graphical mapping issue

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 09, 2011 at 04:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded