Skip to Content
author's profile photo Former Member
Former Member

ROLLBACK

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2007 at 02:15 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2007 at 02:15 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.