Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

ROLLBACK

Former Member
0 Likes
862

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..

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
703

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).

2 REPLIES 2
Read only

Former Member
0 Likes
704

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).

Read only

Former Member
0 Likes
703

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.