BTE failing to commit insert to custom table, why?

[Former Member]

Greetings to you all,

We are using Business Transaction Event 1030 in FI document posting to update a custom table. Initially all inserts to the table were committed, except mass reversals (F.80).

I replaced the Insert statement with a call to a Function Module, which does the inserts. I verified in the debugger that the insert command gets a return code of zero. And yet when the document has been posted, the inserts to the custom table do not occur. It does not matter whether function module is call 'in update task' or not.

Any insights or comments would be greatly appreciated.

Thanks ... Jameel

Message was edited by: Jameel Khan

[Former Member]

Greetings to you all,

We are using Business Transaction Event 1030 in FI document posting to update a custom table. Initially all inserts to the table were committed, except mass reversals (F.80).

I replaced the Insert statement with a call to a Function Module, which does the inserts. I verified in the debugger that the insert command gets a return code of zero. And yet when the document has been posted, the inserts to the custom table do not occur. It does not matter whether function module is call 'in update task' or not.

Any insights or comments would be greatly appreciated.

Thanks ... Jameel

Message was edited by: Jameel Khan

[LucianoBentiveg]

Are you sure that F.80 calls BTE 1030? I was looking for sring "OPEN_FI_PERFORM" in report code, and didn´t find anything.

Regards.

[Former Member]

Transaction F.80 Calls FB08 which invokes the BTE 1030. I have proved to myself that it is getting called and it is doing the table inserts, but for some reason they are not being commited to the database.

We have been successfully publishing BOR Events from this BTE for a couple years for most FI transactions.

Thanks ... Jameel

[Former Member]

Looks like you are coming across some COMMIT WORK problems...please check where the trigger for BTE occurs ..is it ON COMMIT..and details around calls made to FM etc.

if it is an normal FM O think the update should happen assuming a commit work is triggered after the update to the table.

[Former Member]

Thanks for all the good suggestions. This problem is now resolved.

I am sorry to say, or actually happy to say, there was no problem to start with. The BTE was happily inserting to the custom table, but I was looking for the records with the wrong key.

Thanks for all the help anyway ... Jameel