Skip to Content
avatar image
Former Member

[HELP] how retrieve table data sap


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?



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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

    Add comment
    10|10000 characters needed characters exceeded