Problem with restore a data in one table.

[Former Member]

Hi people!

In the client 100 of QA I delete the table FAGLFLEXT in the se14 transaction.

Someone know what can I do to restore the data?

Thanks!

[Former Member]

How can I go to the data level or make the restore?

[Former Member]

Hi,

At a field level, go to data element if the chek-box for data element is checked, the i think you can retrive it from CDHDR and CDPOS tables.

Regards,

Santosh

[RichHeilman]

ooops........... The data is gone. The only way I know, is to restore the table on the underlying database from your backup.

Regards,

Rich Heilman

[Former Member]

How can I go to the data level or make the restore?

[RichHeilman]

Well, you would have to know a little bit about what the "Behind the Scenes" of your SAP System. For example, what is the underlying database and the system in which it runs on and how do you manipulate it. In my case, I come from an DB2 / AS/400 background, so I know exactly how to restore a table from tape on my system, of course, it varies from system to system. It would be totally different if you are running Oracle on a UNIX box.

Right about now is the time which you want to get your basis people involved in helping you to restore the data in the table.

Regards,

Rich Heilman

[Former Member]

Hi,

A user deleted entries out of a Z table. This table is in the PSAPBTABD tablespace. The size of this tablespace is 22GB. We have an online backup of this tablespace and the log files. (from Oracle) Is there a way to restore a single table out of the tablespace or do we have to restore the entire DB (which is 1TB, which is too big).

Thanks.

JP