What is the difference between BAPI_TRANSACTION_COMMIT and COMMIT WORK?

-Both are used to update data into database table.

-Difference between BAPI_TRANSACTION_COMMIT and COMMIT WORK is that BAPI_TRANSACTION_COMMIT refreshes BAPI buffer.

-BAPI buffer holds data to be updated into database table. IF we use COMMIT WORK and if it fails for any reasone then buffer does not refreshes. Hence when we call COMMIT WORK again then the previous data which is present in the buffer is updated. While in BAPI_TRANSACTION_COMMIT Function Module we use BUFFER_REFRESH_ALL function module right after COMMIT WORK. Hence if it fails then buffer is refreshed.

-Hence it is good to use BAPI_TRANSACTION_COMMIT instead of COMMIT WORK.