topic Re: BAPI _TRANSACTION_COMMIT AND ROLLBACK IN LOOP in Application Development and Automation Discussions

BAPI _TRANSACTION_COMMIT AND ROLLBACK IN LOOP

srujanam — Thu, 19 Sep 2019 18:05:54 GMT

Hi,

In the logic that I built, I have to loop , and for each item

1. Goods Issue(GI) using BAPI_GOODSMOVEMENT_CREATE, and if successful commit it.

2. If GI created create Transfer requirement(TR) for GI. Commit if successful. (Question)

3. If TR is created, create Transfer Order for TR. If error (Question).

Question: If there is error creating TR , I would have to reverse the Goods movement which would create another MIGO document. So if I use BAPI_TRANSACTION_ROLLBACK, will it reverse all the previous created/commited GI/TR/TO as all these are in the same LUW?

Re: BAPI _TRANSACTION_COMMIT AND ROLLBACK IN LOOP

GK817 — Thu, 19 Sep 2019 23:12:17 GMT

Hi,

No,BAPI_TRANSACTION_ROLLBACK will not reverse previous commits.

You should use BAPIs in first 2 steps to know if there are any errors. Based on that, call BAPI_TRANSACTION_COMMIT at the end of third step. Then all the 3 steps will be in one LUW and that's how it should be done.

Regards

Re: BAPI _TRANSACTION_COMMIT AND ROLLBACK IN LOOP

Abinathsiva — Fri, 20 Sep 2019 04:17:23 GMT

Hi Srujana Reddy

check out the errors after BAPI_GOODSMOVEMENT_CREATE by filtering Return bapi Internal table for Errors.. if error don't commit the results.

Regards,

Abinath

Re: BAPI _TRANSACTION_COMMIT AND ROLLBACK IN LOOP

former_member1716 — Fri, 20 Sep 2019 04:20:44 GMT

The Logic is simple:

All the transactions that are committed Cannot be Rolled back. In Your Case you are trying to roll back transactions that are committed already which is not possible and correct too.

Probably you can alter your Logic as below:

1) Do not commit any transactions until your complete Cycle is completed successfully.

2) In case if there is failure at any step of the cycle then you Roll back (Without committing any transaction up front), this could be favorable for your scenario.

Regards,