Delete table entries

[Former Member]

I have question like when i delete a record from database table or custom table, will this deletion is recorded any where in the sap system.

kindlu update me if you have any suggestions?

[Former Member]

Hi,

yes the system maintains the logs for important transactions...

and if the change document is active for the table then possibly even the change documents would be maintained.

Regards

Siddarth

[Former Member]

below are the two settings to table logging :

1. In SE11 -> Technical Settings -> 'Log data changes'

2. The rec/client instance parameter

by default many SAP tables come with 'Log data changes' set on. the changes log to tables DBTABLOG and DBTABPRT.

Mathews

[Former Member]

Hi you mean to say that when the log data changes (check box) in the technical settings is checked then the table will maintain log. else the log is not maintained for the table right?

[Former Member]

Hi,

Yes thats right

[Former Member]

Hi

all the changes made to the tables in sap are logged in change log table.In the attributes of

the table you will get the last changed by option,just press F1 there and try to get the table name

fron there.

OR

If Change document is enabled in the data element level under further characteristic tab,the changes will be updated in tables CDHDR and CDPOS.

Regards

Hareesh