Find out the user who deleted a record (table entry)

[former_member199632]

Hello,

From table LIKP , one record is deleted

Is it possible to find who has deleted this.

(For table LIKP , log data changes is NOT enabled)

regards,

[former_member199632]

Hi,

to some extent it is possible using CDHDR and CDPOS.

from there you can view some information of entered values and deleted values

[Former Member]

Hi..

You can check it from Security Audit log (T code - sm20) if it is on, other wise you cannot find it because, when we delete the delivery, there is not delete flag exist. it directly deletes it from LIKP & LIPS table.

Cheers

KHS

[former_member182034]

HI zerandib,

You can't get the log against deleted record from Table, you can get the log of last change.

if you want to enable for SAP Tables then check following link

http://wiki.sdn.sap.com/wiki/display/ABAP/MaintainingChangeLogforDatabase+Tables

Regards,

[Former Member]

Hello Zerandib,

on Oracle level all you could find out is that user SAPSR3 (or whatever the schema name

is on your installation) deleted the record. It is not possible on Oracle level to identify

SAP users who delete records. So if the SAP system doesn't log the change, there is

no way of finding out via Oracle internal records.

The best you could hope for is to identify the time when some specific record was deleted.

You could use either Flashback Query, Flashback Version Query, Flashback Transaction

Query or Oracle Logminer to accomplish this. Anyway these procedures aren't trivial and

it is questionable whether the effort is justified for the result.

Regards,

Mark