topic Re: DELETE FROM TABLE with rollback work in Application Development and Automation Discussions

DELETE FROM TABLE with rollback work

Former Member — Mon, 16 Jan 2012 18:31:14 GMT

Hi,

I try to do the command DELETE FROM TABLE for delete all regist that exist on database table from my internal table.

The command delete all the regist but i need to do a rollback work doesn't work. All the that are removed.

Anyone can help me to go back with delete data if i wan't to recovery data ?

Thank you in advance.

Miguel Silva

Re: DELETE FROM TABLE with rollback work

Former Member — Mon, 16 Jan 2012 18:33:20 GMT

You have to do the rollback before the COMMIT or before the program ends. Did you do that?

Rob

Re: DELETE FROM TABLE with rollback work

Former Member — Mon, 16 Jan 2012 18:40:36 GMT

if you are using commit inside loop then take it out...

and use ROLLBACK WORK before the commit(based on your condition). here is the SAP help link. read to know more..

http://help.sap.com/abapdocu_702/en/abaprollback.htm

Re: DELETE FROM TABLE with rollback work

surajarafath — Tue, 17 Jan 2012 03:26:50 GMT

try this code..

IF  itab IS NOT INITIAL.
    DELETE <db> FROM TABLE itab.
    IF sy-subrc NE 0 .
      ROLLBACK WORK.
      MESSAGE e0398(00)."Error while Saving data
      RETURN.
    ENDIF.
  ENDIF.

Re: DELETE FROM TABLE with rollback work

RaymondGiuseppi — Tue, 17 Jan 2012 07:32:28 GMT

You must execute the ROLLBACK WORK before any DATABASE COMMIT.

Database Commit is triggered by COMMIT WORK, a call to DB_COMMIT or a native sql commit statement.

But it is also triggered Implicitly by end of dialog step, Call of a function module in a synchronous or asynchronous Remote Function Call or end of such a call, receive. Remember that sending a message, warning, error or information will trigger the end of a dialog step, so also trigger a db commit. (Read some documentation on [Database Commit|http://help.sap.com/abapdocu_70/en/ABENDB_COMMIT.htm])

Regards,

Raymond