Application Development 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: 

Rollback the changes to Transparent Table records

Former Member
0 Kudos

Hi,

I wrote an ABAP program to update one record in table in ECC. Unfortunately all the records got updated. Is there a way to get them back to original values?

SELECT * FROM ROOSOURCE WHERE OLTPSOURCE = '0FI_GL_10'.

UPDATE ROOSOURCE SET EXMETHOD = 'F1'.

ENDSELECT.

I realized that I have to use WHERE condition on UPDATE command after executing. But all the records were updated... Any help is appreciated..

Thanks,

Hanuma

3 REPLIES 3

Former Member
0 Kudos

Hi

Something is wrong on your code:

- or u use:

SELECT * FROM ROOSOURCE WHERE OLTPSOURCE = '0FI_GL_10'.
  ROOSOURCE-EXMETHOD = 'F1'.
  UPDATE ROOSOURCE.
ENDSELECT.

- or u use:

UPDATE ROOSOURCE SET EXMETHOD = 'F1' WHERE OLTPSOURCE = '0FI_GL_10'.

But you can't use them together.

Now u can only to restore the old data by a backup.

Max

Former Member
0 Kudos

Once the database has been committed (done automatically at the end of the program), you cannot undo the changes. Your only hope would be if your basis folks can restore from backups.

rob

0 Kudos

Max and Rob,

Thanks for your answers.

Hanuma