topic Is BAPI_TRANSACTION_COMMIT thread overlapping? in Application Development and Automation Discussions

Is BAPI_TRANSACTION_COMMIT thread overlapping?

friendlycoder — Wed, 06 Jan 2021 10:37:08 GMT

Hi all

We have a huge amount of invoices to book. So we have decided to split the invoices into small blocks and run the booking on several threads to improve the speed.

After the invoice booking BAPI is executed, we need to call of BAPI_TRANSACTION_COMMIT to finalize the commit. The question is, where do I have to call BAPI_TRANSACTION_COMMIT, on main or on every spawned thread?

Thanks

Re: Is BAPI_TRANSACTION_COMMIT thread overlapping?

maheshpalavalli — Wed, 06 Jan 2021 11:54:45 GMT

I believe you should call bapi transaction commit for every invoice bapi call.

You should call it because the invoice might update some tables which need the latest data (internally it might read the latest data from tables and might reupdate it ). I once got an issue of data inconsistency in the system tables, because we were doing bapi_trasaction commit for multiple bapi calls at once.

and your question of running it in multiple threads, I don't think calling bapi transaction commit in the main program will affect the threads bapis

Re: Is BAPI_TRANSACTION_COMMIT thread overlapping?

Sandra_Rossi — Wed, 06 Jan 2021 12:58:57 GMT

I guess that 1 thread = 1 SAP work process.

Each SAP work process is bound to one database process. A database commit applies to only its current database process. BAPI_TRANSACTION_COMMIT does one database commit (+ some ABAP buffer refresh + execute ABAP update tasks).

So...

Re: Is BAPI_TRANSACTION_COMMIT thread overlapping?

friendlycoder — Fri, 08 Jan 2021 12:28:12 GMT

@sandra.rossi

Are you sure, that 1 thread = 1 SAP work process? If yes, calling BAPI_TRANSACTION_COMMIT in the main thread does not do the commit on worker threads?

Thanks

Re: Is BAPI_TRANSACTION_COMMIT thread overlapping?

Sandra_Rossi — Fri, 08 Jan 2021 12:42:21 GMT

I'm not sure, it's just my opinion. But why are you talking about "threads". Threads don't exist in SAP systems. There are only work processes. Moreover you mix SAP and database notions. The commit at database level is not performed by SAP work process, the commit is at database level. One database transaction is linked to exactly one SAP work process.

Anyway, there's no relationship between work processes, how would a "main" work process be aware that another one is its "child"?

Re: Is BAPI_TRANSACTION_COMMIT thread overlapping?

former_member717457 — Fri, 08 Jan 2021 12:59:52 GMT

Hi,

Apply BAPI_TRANSACTION_COMMIT When you split the invoices using internal table (loop). After Booking the invoice BAPI_TRANSACTION_COMMIT has to come.

Thanks

Sathish Kumar Sidhaiyan

Re: Is BAPI_TRANSACTION_COMMIT thread overlapping?

friendlycoder — Fri, 08 Jan 2021 13:12:49 GMT

Yes, but it does not work properly.

Re: Is BAPI_TRANSACTION_COMMIT thread overlapping?

Sandra_Rossi — Fri, 08 Jan 2021 13:54:13 GMT

bifunctor Why don't you want to code it the same way like SAP and other developers do it? i.e. do commit by package (each package can be processed by a dedicated work process, with a unique commit at the end). Do you have a reason to not want to do it? NB: in case it's your question, you cannot commit a big number of updates at once, the database would crash.

Re: Is BAPI_TRANSACTION_COMMIT thread overlapping?

friendlycoder — Mon, 11 Jan 2021 15:23:55 GMT

@Sandra Rossi

Thanks for your advice. However I think I have found a solution:

  DATA(lo_inbound) = cl_bgrfc_destination_inbound=>create( dest_name = 'YCAS1' ).
  DATA(lo_trcf) = lo_inbound->create_trfc_unit( ).


  CALL FUNCTION 'ZAMAR_BG_PROCESS' IN BACKGROUND UNIT lo_trcf
    EXPORTING
      iv_num = 20.

Thanks

Re: Is BAPI_TRANSACTION_COMMIT thread overlapping?

Sandra_Rossi — Mon, 11 Jan 2021 15:40:19 GMT

Okay, so you do it by package.