Skip to Content

[HELP] how retrieve table data sap

Apr 17, 2017 at 05:18 PM


avatar image
Former Member


I need help,I deleted all data from the tables pa0000 and pa0001

i execute a report in RHT (system test) and this report call function move employees to RHD (system development) and this function delete all data of RHD in tables PA0000 and PA0001...

how can retrieve data?



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Apr 18, 2017 at 08:40 AM

Hello Eugenio,

You can flashback the data from PSAPUNDO tablespace.

Create a copy of table first with timestamp until which the data was correct using below command

create table sapsr3.<tablename>_date as select * from sapsr3.<tablename> as of timestamp to_timestamp('01-01-2020 12:00:00','DD-MM-YYYY H24:MI:SS');


the time stamp '01-01-2020 12:00:00' must be replaced by the point in time to which the table should be flashed back.

So the table is created at DB level, the same needs to be created at SAP level also with same structure and indexes as source and data can be copied to original table.

Sandeep V

10 |10000 characters needed characters left characters exceeded