BAPI Commit issue

[Former Member]

Gurus,

I want to update SAP with some batch characteristics data that i have in local DB(MS SQL Server). The problem is only the last row of values are getttiing updated in SAP.I checked the message in the response and there is no error message.

My sQL server table has the following records

<b>Charact</b> <b>CharVal</b>

Density 5.6

Cut 1

I created the following transaction

Sequence 1: Query the SQL server for the records

Sequence 2: Repeater Action to iterate through the records.Xpath Expr-(IllumSQLQuery_0.Results{/Rowsets/Rowset/Row})

Sequence 3:SAP JCo Interface -mapped to BAPI_OBJCL_CHANGE and all the inputs are mapped for the repeater output.I have checked the Auto Commit option check box while configuring the BAPI object.

After executing the transaction, in sap we see the cut values are updated and the density value is blank.

PLease guide me as to where i may have gone wrong?

Thanks and Regards,

Ram

[Former Member · Accepted solution]

This may help:

<a href="/people/abesh.bhattacharjee/blog/2007/06/05/calling-a-bapi-with-a-table-as-an-input-parameter-from-xmii:///people/abesh.bhattacharjee/blog/2007/06/05/calling-a-bapi-with-a-table-as-an-input-parameter-from-xmii

[Former Member · Accepted solution]

Thanks christian...it did help!

[Former Member]

Hi Ram,

Are you sure that the query is returning all the records. Did you try adding a tracer after the repeater & check for all the records before the bapi call.

Thanks,

Sushma.