Standard table deleted in se11 by mistake

[Former Member]

Hi All,

The standard table IFLOT has been deleted by mistake and using the "create" option it has been created in se14 and Activated by adjusting the database in SE14. Now my issue is the standard table related objects are not working and some of the objects like the views where the table is been used i have activated.But still inconsistency. Can some one help me how to restore the standard table and all the objects related to it work Normally.

Please advice me.

Thanks & Regards,

Durga Naresh B

[Former Member]

Dear Durga,

I'm afraid your best options are:

- System restore

or

- Write OSS message to SAP

Nevertheless do check here

[;

Kind Regards

/Ricardo Quintas

[Former Member]

Hi Ricardo,

Thanks for the reply,

Actually i have created the table again using the create option and where ever i am facing the problem

for example when executing ih06, the system goes dump with IFLO view doesnot exist in database. then i have activate and working fine.In that way i could solve the issue to some extent. System restore means to install a new server?

Thanks & Regards,

Durga Naresh B

[Former Member]

There should be a transport that shows all the objects that were deleted. You can use this to tell you what needs re-creating.

Ranther than using the 'create' option, it would probably be better to use version management to pull back the latest version.

Also, make sure this transport is never exported!

The data will have to be restored by the DBAs.

Rob

[Former Member]

Thanks for replying Rob.

Actually , i want to delete the data in IFLOT table, so instead of deleting the data by mistake i deleted the table and again created in the se14. Now my data is deleted which is fine.the table IFLOT which is deleted and again created exits in the database.

My problem is the database views which are dependent on this table also deleted from the data base. So, i have activated the Views and are now exists.Is there any objects effected by this deletion and creation of standard table IFLOT in se14 ?

what is the best option to delete the entries in standard table with out effecting the database table and its related objects.

Please Guide me.

Thanks and Regards,

Naresh

Edited by: NareshBD on Sep 30, 2011 1:31 AM

[Former Member]

Search helps? I really don't know. Did you check the transport to see what was in it?

Rob

[Former Member]

Hi Naresh

The best option to delete the database entries without affecting other objects is to delete via Database Utility

i.e via Utilities -> Database Object -> Database Utility

There you have the option Activate&Adjust Database (Save Data/Delete Data)

Use Delete Data option, if you want to remove entries in database table.

Thanks.

Rakhi

Edited by: Rakhi Nair on Oct 4, 2011 7:21 PM

[koolspy_ultimate]

Hi, naresh ,

you need not worry about this if you request your basis admin to system copy the production data. (actually the basis admin must system copy production data into dev server for every 3 months )

So that every thing will be fine .

Note: make sure that you do not repeat this again

Regards,

koolspy.

[derrick_hurley]

Hi Durga Naresh B

The best option to delete entire entries from a table without it effecting the DDIC runtime object (nametab) is to perform this at Database level (outside of R/3 etc) using an sql statement. There is of course the option in SE14 using the 'Activate and adjust' with option 'Delete data' - but you should be confident to use this etc. (not to mention users should not be accessing the table at the time)

With regards to your initial problem you could attempt to make the table consistent again by transporting the table from another system and then performing a reconstruct as per note 1248769.

http://service.sap.notes -> note 1248769

Best regards,

-Derrick

[Former Member]

dear friend.

if you have deleted only data by mistake then there is solution available.

go to other system.

download all the data from that table in to excel file or any binary file

create lsmw and with the

use of lsmw upload data in to your table.

now using se14 activate and adjust table without delete table data.

hope this works.

[Former Member]

Hi durga,

the privious ly created object which were mapped to table which you accidently deleted will not work. you either need to create atransport request or ask your BASIS admin for system restore. Getting system restore is simplest and best option.

[prakashjasti]

Dear Naresh,

Please make sure while deleting any table.

You have to restore the backup upto previous date and proceed

(Ask your basis).

If there is the same data available in another system you can restore with the help of your basis.

Regards,

Prakash.