topic Re: How to rollback saved data from database (custom) table in Application Development and Automation Discussions

How to rollback saved data from database (custom) table

vinayad — Tue, 11 Jun 2019 05:45:57 GMT

I want to rollback the record from the table which is modified or deleted.

Normally when we do undo, it works for unsaved data but here I need the record even it's changed in database level.

Let me know how to approach?

Any suggestions would be appreciated.

Thanks!!

Re: How to rollback saved data from database (custom) table

ankurch — Tue, 11 Jun 2019 05:58:21 GMT

Hi There,

Normally we can maintain entries in custom table through SM30, try with same tcode whether you are able to delete entries from the table or not!

Thanks,

Re: How to rollback saved data from database (custom) table

matt — Tue, 11 Jun 2019 06:48:36 GMT

Once you've saved it, you've committed it. No chance of rollback. If the table has database logging you'll be able to find out what changed and manually change it back. Otherwise talk to your basis team about recovering from backup.

Re: How to rollback saved data from database (custom) table

vinayad — Tue, 11 Jun 2019 07:00:35 GMT

Hi Ankur,

I would appreciate for your response.

Yes I can delete, insert, modify even 'UNDO' in SM30. But I want to rollback which is last modified or deleted data, this when you try to undo it won't work. I have implemented same options in my program for the custom table operations.

Hope my question is cleared.

Thanks.

Re: How to rollback saved data from database (custom) table

RaymondGiuseppi — Tue, 11 Jun 2019 07:01:18 GMT

In Abap SQL when database is updated and commited you have no tool to reverse the change, the commit is an end.

If no database commit was executed, explicitly or implicitly, use FM DB_ROLLBACK, else

You could either log data change and use the log to reverse changes, or use some Admin Database Tool to reverse journalized entries, but that's not Abap relevant.
Try to use standard SAP way to update database and commit only at end of transaction. Perform some search in online help with keywords such as Database Logical Unit of Work (LUW)