topic ROLLBACK in Application Development and Automation Discussions

ROLLBACK

Former Member — Tue, 20 Nov 2007 14:13:28 GMT

can anybody explain in brief about implicit ROLLBACK and explicit rollback and the difference between them and the procedure to work with it in REAL TIME..

Re: ROLLBACK

Former Member — Tue, 20 Nov 2007 14:15:10 GMT

Implicit Database Rollbacks in the R/3 System

The following cases lead to an implicit database rollback:

· Runtime error in an application program

This occurs whenever an application program has to terminate because of an unforeseen situation (for example, trying to divide by zero).

· Termination message

Termination messages are generated using the ABAP statement MESSAGE with the message type A or X. In certain cases (updates), they are also generated with message types I, W, and E. These messages end the current application program.

Explicit Database Rollbacks in the R/3 System

You can trigger a database rollback explicitly using the ABAP statement ROLLBACK WORK. This statement starts a database rollback, but also performs other tasks (refer to the keyword documentation for ROLLBACK WORK).

Re: ROLLBACK

Former Member — Tue, 20 Nov 2007 14:15:29 GMT

ROLLBACK WORK. this will revert changes to database since last database commit.

suppose u have two insert statements, if second insert fails, u need to revert changes done by first one. u can use this statement.