topic Retrieving data's from deleted tables in Application Development and Automation Discussions

Retrieving data's from deleted tables

Former Member — Tue, 11 Nov 2008 12:32:35 GMT

Accidently, I have deleted all the transport requests in development server. How can I retrieve the data's. There are no entries in table E070 and no backup of development server data is taken. Can I retrieve the deleted entries. Is there anyway I can retrieve the data's any log of the table of deleted entries. E070 table is not logged. Any kind of help will be highly appreciated.

Regards,

Debopriyo

Re: Retrieving data's from deleted tables

GauthamV — Tue, 11 Nov 2008 12:34:32 GMT

hi,

you can reimport the transport requests from your production server.

Re: Retrieving data's from deleted tables

Former Member — Tue, 11 Nov 2008 12:37:38 GMT

You can ask the BASIS team to restore the system from the recent ONLINE backup they would have taken for the system. What online backup does is it restores the system to a particular date so you will get the system as it was on that particular date but all changes after that particular days is anyways lost.

Hope it helps.

Thanks,

Jayant

Re: Retrieving data's from deleted tables

ThomasZloch — Tue, 11 Nov 2008 12:48:00 GMT

To be able to (maybe) help, I need to know how you deleted the requests? I assume they had not been released yet. Normally you cannot delete workbench requests as long as there is objects inside.

Thomas

Re: Retrieving data's from deleted tables

Former Member — Tue, 11 Nov 2008 13:03:48 GMT

Accidentally!!!!!!!!

Accidentally, now if all request are already transported to other server(I assume).

Than you may change your Transport route (For the time only) once all required TR import back to DEV ,than again change Transport route as it is.

I't assuming all deleted TR are exsist in either QAT or PRD.

Re: Retrieving data's from deleted tables

Former Member — Tue, 11 Nov 2008 13:29:59 GMT

I had deleted the entries from table E070. I wanted to delete the data for a particular client, but since it is not a cross client table (MANDT) is missing , all the data's for that server gone. About 20% of them have not been transported before. I want those datas back . The rest I can import from quality or production.

Regards,

D.Mallick

Re: Retrieving data's from deleted tables

Former Member — Tue, 11 Nov 2008 13:36:38 GMT

Best will be a online restore as I suggested. Also please update in the same thread which method you thought will be best from the suggestion given in this thread.

Thanks,

Jayant

Re: Retrieving data's from deleted tables

Former Member — Tue, 11 Nov 2008 13:56:16 GMT

Any reason to use the code to delete from E070?

Re: Retrieving data's from deleted tables

christine_evans — Tue, 11 Nov 2008 13:58:02 GMT


> Accidently, I have deleted all the transport requests in development server. How can I retrieve the data's. There are no entries in table E070 and no backup of development server data is taken. Can I retrieve the deleted entries. Is there anyway I can retrieve the data's any log of the table of deleted entries. E070 table is not logged. Any kind of help will be highly appreciated.
> 
> Regards,
> 
> Debopriyo

If you don't have a DEV database backup then you could be stuck. If I found myself in this situation (impossible since I wouldn't have dreamt of doing a direct table update on one of the SAP standard transport tables), I'd forget about the old transports, identify all the changed DEV objects that hadn't yet made it into TEST and create new transports for them.

Re: Retrieving data's from deleted tables

ThomasZloch — Tue, 11 Nov 2008 14:08:55 GMT

Requests that were imported into subsequent systems will be in table E070 of those systems. Maybe you can restore some entries this way.

Requests that were released but not imported anywhere and those that were not released yet are more difficult. Have a look at the contents of table VRSD which stores the object versions along with transport numbers.

In short, I see no easy way of doing this, you need a very good expert with access to your systems to sort this out (if possible at all).

Thomas

P.S. are E071 / E071K entries still there? These could be used to find missing E070 entries and recreate them using some dummy entries for e.g. user, date, time...and E070 without any objects were useless anyway.

Re: Retrieving data's from deleted tables

Former Member — Tue, 11 Nov 2008 14:30:57 GMT

Hi friends,

I have found a way out. Though it won't serve my purpose, but it stills provides some kind of solution. The requests which are released can be imported from quality or production. The rest, of requests are those which have not been released. Fortunately, in my case the subtasks were not deleted. If I go to a program which has not been released, it will open in display mode and won't allow me to create a request. I found out that in table TLOCK, once I put the program name, it shows the flag is locked. I changed the flag setting from 'X' to ' ', and saved the data in table TLOCK. Then I went back to my program , it opened in changed mode. I had to create a separate main task (request) for this. The biggest plus point was I managed to get the subtask containing more than 12 abap objects. I only had to create one main request. If some other better solutions are there, just let me know. Thank you all for your prompt responses. If I manage to retrieve the entire content of E070, I will give rewards accordingly.

Thanks,

D. Mallick