Data recovery from SAP table

30 pts.
Tags:
Data Recovery
SAP
Hello,
I have accidentally deleted data from an SAP table. How can I get the data back?
Regards.
James.
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 8  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    Restore it from your backups or re-enter it from the source. That's essentially how it's done for all data deleted from any tables.
    32,380 pointsBadges:
    report
  • TheRealRaven
    If the tables are journaled, you might be able to use journal recovery; but you'll need a DBA to review things to get it done.
    32,380 pointsBadges:
    report
  • Jimmiewam
    The code below is an oracle code for recovering deleted records. For my case am using SQL database. Is there a way I can modify this code to give me back the lost data?
    SQL> SELECT MANDT, MATNR FROM
    (SELECT MANDT, MATNR FROM SAPR3.MARA AS OF TIMESTAMP
     TO_TIMESTAMP('2008-04-21 13:00:00','YYYY-MM-DD HH24:MI:SS')) MINUS
    (SELECT MANDT, MATNR FROM SAPR3.MARA AS OF TIMESTAMP
     TO_TIMESTAMP('2008-04-21 13:30:00','YYYY-MM-DD HH24:MI:SS'));
    Regards.
    30 pointsBadges:
    report
  • TheRealRaven
    In general, Oracle is a "SQL database". As is DB2 and MySQL and PostgreSQL and MS Access and... well... most DBMSs we normally think of are "SQL databases".

    But they can all have their own ways of doing things such as returning deleted rows to tables. We need to know more about which "SQL database" (i.e., which DBMS) is being asked about.
    32,380 pointsBadges:
    report
  • Jimmiewam
    Its MySQL DBMS

    30 pointsBadges:
    report
  • TheSameGuy
    Hey guys, i also have the same problem of retrieving the deleted rows from standard table in SAP. I have been searching over the internet on how to get lost data back and i found the same SQL code as above oracle sql but my database is MS SQL. My question is, how do i convert the same oracle sql to OpenSQL so that i can run the program in ABAP Workbench?
    10 pointsBadges:
    report
  • TheRealRaven
    The posted SQL SELECT statement appears appropriate for Oracle, but it should be close for MySQL also. For SQL Server, the "EXCEPT" syntax should pretty match the "MINUS" syntax.

    I can't run the statement for any DBMS, nor would I want to without an appropriate test environment for it, so I can't guess what the point of it is. It doesn't really seem to do much except to act as a basic template. If so, it would need to be modified to fit whatever data needed to be recovered.

    Whether it can return any results or not is totally dependent on the audit/change/log configurations that have been enabled.
    32,380 pointsBadges:
    report
  • Elizine

    Table NRIV has no log changes activated in technical settings. So that's no option. You can restore it from the backup option. 

    If you have a recent client copy of the affected client and not too much changed in the meantime, this could also help you to restore NRIV.



    1,145 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: