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