2013 Oct 08 11:31 AM
Dear Everyone,
I'm facing issue relate to rollback after performing command CALL TRANSACTION, Please suggest a solution or work around
Scenario: Create a program as below:
1. Update database table Zxxxxx
2. CALL TRANSACTION 'Zxxxxx'
USING BDC_TAB
xxxx.
3. Write log of call transaction
Issue:
Scenario 1: Execute report, When cursor jump to step 3(step 1 has executed successfully, step 2 occurs error).
Scenario 2: Sever SAP shut down while report is excuting at step 3.
In 2 scenario above, I cannot rollback database table at step 1.
Please advice how to rollback database table at step 1 after step 2(CALL TRANSACTION) was executed.
Thank you very much!!!
Best regards,
DucTV
2013 Oct 08 1:43 PM
Hello Tran,
"CALL TRANSACTION" will leave your actual program and call a transaction independent of your running program.
So you cant make a ROLLBACK WORK after returning to your program because it is allready commited.
Regards Nico
2013 Oct 08 2:19 PM
No luck, even if CALL TRANSACTION will be executed in another luw, using it you have triggered a (an implicit) database commit, and your table is already updated in database.
You could use a Z-BAPI that has same behaviour than your Z-transaction as long as no implicit database commit are triggered.
Regards,
Raymond