Table entries deleted

[Former Member]

Hi all,

All the enteries in the PROJ table got deleted.

Is there any process to retrieve those entries??

And also any way to track hw those entries were deleted??

Regards,

Johnson

[raymond_giuseppi]

Were the dependent entries deleted (MLST, PRHI, PRPS) if yes the deletion may have been executed by a standard report/program and you will get entries in CDHDR/CDPOS with only the keys of the deleted record and the user, date, time and transaction code.

If the deletion is logical, you may build a report to uncheck the deletion flag,

If the deletion is physical (DELETE FROM PROJ) no luck, you will need to ask your BC team to restore the full system at an earlier date time. database will be coherent, but user input and interface since the save will be lost...

Same problem if deletion was lauched from database level.

You may, at your own risk, ask to restore only the PROJ database table but no coherence check will be performed. You may not found newer project which were deleted after the daily save (i hope for you) but some WBS will be orphan.

You may also search for 'DELETE FROM PROJ' in ABAP source of customer package

Regards;

Raymond

[Former Member]

hi,

check out the link :

http://help.sap.com/saphelp_nw70/helpdata/EN/c4/3a7886505211d189550000e829fbbd/content.htm

hope this will help you!!!

Thanks & Regards,

Punit Raval.

[raymond_giuseppi]

This note is for iSeries reorganization of the database, (reorganization) to compress database files with many deleted records to gain storage space.

Nevertheless, for some OS there are tools to recover deleted records, but that out of SAP scope.

Regards,

Raymond

[Former Member]

Not possible if the log is not activated.

sol : download from other client if possible

[Former Member]

Hi,

Dangerous advice removed.

Regards

Sreelakshmi.

Message was edited by: Rob Burbank

[sitakant_tripathy2]

Hi Johnson,

you might have to restore the DB Backup for the table to gt back the data....

Furthermore, if you want to track how the entried were deleted then there are 2 ways to go about it:

If the Deletion of the records was through an application (FM,Program call) then there should be Chande Documents available for them and you can search them by hitting tables CDHDR and CDPOS...

If the Deletion of the records was done physically the you can try looking into the tables UASE16N_CD_KEY and UASE16N_CD_DATA (deletion from transaction UASE16N) or tables SE16N_CD_KEY and SE16N_CD_DATA(Deletion from SE16). This will give change pointer documents if the records were deleted using these transactions...

Another option might be that somebody has used the Database utility and selected the option Delete Data. In this case you can have a look at the object log....

Hope this helps....

Regards,

Sitakant.