Skip to Content
0

[HELP] how retrieve table data sap

Apr 17, 2017 at 05:18 PM

36

avatar image

Hi,

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?

thx,

regards

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

1 Answer

Sandeep Vasudevan Apr 18, 2017 at 08:40 AM
0

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');

commit;

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.


Regards,
Sandeep V

Share
10 |10000 characters needed characters left characters exceeded