topic Re: need of commit work statement in Application Development and Automation Discussions

need of commit work statement

Former Member — Wed, 08 Jun 2016 07:01:03 GMT

Hi everyone,

Can you please guide me know when we need to use Commit work statement in SAP-ABAP, and when can we avoid Commit work statement.

Thanks & regards,

Shravan

Re: need of commit work statement

Former Member — Wed, 08 Jun 2016 07:05:44 GMT

Hi,

Check the below link, it will help u.

ABAP Keyword Documentation

Thanks

Re: need of commit work statement

Former Member — Wed, 08 Jun 2016 07:38:48 GMT

From the Keyword Documentation:

The COMMIT WORK statement closes the current SAP LUW and opens a new one

This is very important if you have Situations where multiple datasets have to be modified. If one of the modifications fail, you want to do a ROLLBACK.

But If you made other changes to the database those would be rolled back as well. So COMMIT WORK is basically just doing what the Documentation says:

Closing the current SAP LUW
Opening a new SAP LUW

This helps you to keep databse changes that have to be executed together to be in line even when there is a lock on the table or techical issues appear.