topic About commit transaction in Application Development and Automation Discussions

About commit transaction

Former Member — Wed, 21 Nov 2007 02:59:13 GMT

I have a BDC which will call a add-on program, In the add-on program, which will call a bapi to create po, the following is a snapshot of source code

CALL FUNCTION '/AFS/BAPI_PO_CREATE'

EXPORTING

PO_HEADER = wa_po_header

PO_HEADER_ADD_DATA = wa_po_header_add

IMPORTING

PURCHASEORDER = WA_POGR-EBELN

RETURN = WA_RET

TABLES

PO_ITEMS = wa_po_items

PO_ITEM_SCHEDULES = wa_po_item_sch.

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

EXPORTING

WAIT = 'X'.

Once I using debug to trace what's problem, i found that once i call the BAPI_TRANSACTION_COMMIT. after that the following instruction will not execute and jump to end of BDC, it means i can't commit the transaction. Anyone can give me some idea. Thanks!

Re: About commit transaction

naimesh_patel — Wed, 21 Nov 2007 03:04:57 GMT

It is essential to use the 'BAPI_TRANSACTION_COMMIT' to save the data which is there in the BAPI's LUW. If you don't use this FM then your document will not be saved in the database.

If this FM creates a problem, then try to put the FM in the end portion of that subroutine.

Regards,

Naimesh Patel

Re: About commit transaction

Former Member — Wed, 21 Nov 2007 03:07:05 GMT

commit work and wait.

Re: About commit transaction

Former Member — Wed, 21 Nov 2007 03:34:45 GMT

Well, you're trying to put two commits in one LUW. I think you have to separate the BAPI from the BDC session.

Rob

Re: About commit transaction

Former Member — Wed, 21 Nov 2007 03:36:14 GMT

How to separate, thanks!

Re: About commit transaction

Former Member — Wed, 21 Nov 2007 03:39:39 GMT

Thae BAPI is in a custom transaction being called by the BDC right?

Rob

Re: About commit transaction

Former Member — Wed, 21 Nov 2007 04:13:33 GMT

Yes