Skip to Content
0
Former Member
Mar 18, 2009 at 01:44 PM

Split input Message to several IDOCs Message

83 Views

Hi together,

i'am a PI starter and I have a problem with the mapping. I customize a JDBC Scenario from DB2 Database to an IDOC Adpater. The Scenario works fine and I can see the IDOC Meassges in the ERP System.

so far so good.

Now i got more rows in the output Message from the DB2 database. Only the last one I see in the target System. Here is the example of the extract payload.

<?xml version="1.0" encoding="utf-8" ?>

- sap.com:jdbcAdapter">

- <row>

<D1ERF>25</D1ERF>

<D2ERF>6</D2ERF>

<D3ERF>91</D3ERF>

<D4ERF>19</D4ERF>

<Z1ERF>13</Z1ERF>

<Z2ERF>39</Z2ERF>

<ERFUS>UMSTELLUNG</ERFUS>

<D1AEN>28</D1AEN>

<D2AEN>1</D2AEN>

<D3AEN>4</D3AEN>

<D4AEN>20</D4AEN>

<Z1AEN>11</Z1AEN>

<Z2AEN>7</Z2AEN>

<AENUS>MEIER</AENUS>

<STATU>N</STATU>

<GSBER>1</GSBER>

<PKKDN>1040253</PKKDN>

<PKANR>04</PKANR>

<PKNA1>DEBITOR1</PKNA1>

<PKNA2>CO. KG</PKNA2>

<PKNA3 />

<PKSTR>FISCHERWEG 10</PKSTR>

<PKPOF />

<PKLND>A</PKLND>

<PKPLZ>4063</PKPLZ>

<PKORT>HOERSCHING</PKORT>

<PKOID>102518</PKOID>

<PKKUS>F & B</PKKUS>

<PKTEL>07221/707-0</PKTEL>

<PKKTX />

<PKTTX />

<PKFAX>07221/73617</PKFAX>

<PKBBK>321</PKBBK>

<PKDIV>N</PKDIV>

<PKBRS>6000</PKBRS>

<PKSPS />

<PKBUN>64</PKBUN>

<PKBON>1</PKBON>

<PKSPZ>J</PKSPZ>

<PKBBN>0</PKBBN>

<PKBBS>0</PKBBS>

<PKKON />

<PKFIR>64</PKFIR>

<PKPVS>N</PKPVS>

<PKPVB>N</PKPVB>

<PKPVV>N</PKPVV>

<PKPVZ>N</PKPVZ>

<D1PKA>0</D1PKA>

<D2PKA>0</D2PKA>

<D3PKA>0</D3PKA>

<D4PKA>0</D4PKA>

<PKABZ>0</PKABZ>

<D1PKE>0</D1PKE>

<D2PKE>0</D2PKE>

<D3PKE>0</D3PKE>

<D4PKE>0</D4PKE>

<PKEMZ>0</PKEMZ>

<D1PKB>0</D1PKB>

<D2PKB>0</D2PKB>

<D3PKB>0</D3PKB>

<D4PKB>0</D4PKB>

<PKBUZ>0</PKBUZ>

<PKVKN>684</PKVKN>

<PKVGB>0</PKVGB>

<PKEKD>0</PKEKD>

</row>

- <row>

<D1ERF>25</D1ERF>

<D2ERF>6</D2ERF>

<D3ERF>91</D3ERF>

<D4ERF>19</D4ERF>

<Z1ERF>13</Z1ERF>

<Z2ERF>39</Z2ERF>

<ERFUS>UMSTELLUNG</ERFUS>

<D1AEN>11</D1AEN>

<D2AEN>9</D2AEN>

<D3AEN>3</D3AEN>

<D4AEN>20</D4AEN>

<Z1AEN>11</Z1AEN>

<Z2AEN>39</Z2AEN>

<AENUS>BRANCHE080</AENUS>

<STATU>J</STATU>

<GSBER>1</GSBER>

<PKKDN>1050002</PKKDN>

<PKANR>00</PKANR>

<PKNA1>Debitor2 GMBH</PKNA1>

<PKNA2 />

<PKNA3 />

<PKSTR>DRAIweg. 13</PKSTR>

<PKPOF />

<PKLND>D</PKLND>

<PKPLZ>77815</PKPLZ>

<PKORT>BUEHL</PKORT>

<PKOID>23223</PKOID>

<PKKUS>APHINA</PKKUS>

<PKTEL />

<PKKTX />

<PKTTX />

<PKFAX />

<PKBBK>80</PKBBK>

<PKDIV>N</PKDIV>

<PKBRS>9999</PKBRS>

<PKSPS />

<PKBUN>1050002</PKBUN>

<PKBON>1</PKBON>

<PKSPZ>J</PKSPZ>

<PKBBN>0</PKBBN>

<PKBBS>0</PKBBS>

<PKKON />

<PKFIR>1050002</PKFIR>

<PKPVS>N</PKPVS>

<PKPVB>N</PKPVB>

<PKPVV>N</PKPVV>

<PKPVZ>N</PKPVZ>

<D1PKA>0</D1PKA>

<D2PKA>0</D2PKA>

<D3PKA>0</D3PKA>

<D4PKA>0</D4PKA>

<PKABZ>0</PKABZ>

<D1PKE>0</D1PKE>

<D2PKE>0</D2PKE>

<D3PKE>0</D3PKE>

<D4PKE>0</D4PKE>

<PKEMZ>0</PKEMZ>

<D1PKB>0</D1PKB>

<D2PKB>0</D2PKB>

<D3PKB>0</D3PKB>

<D4PKB>0</D4PKB>

<PKBUZ>0</PKBUZ>

<PKVKN>417</PKVKN>

<PKVGB>0</PKVGB>

<PKEKD>0</PKEKD>

</row>

</ns:PAKSTP.resultSet>

The problem is, that I must say to the Message Mapping, that I want to create several IDOCs.

Thanks for qour help.

Wolfgang