topic Re: Delete table entries in Application Development and Automation Discussions

Delete table entries

Former Member — Wed, 11 Mar 2009 16:08:38 GMT

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?

Re: Delete table entries

Former Member — Wed, 11 Mar 2009 16:14:29 GMT

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

Re: Delete table entries

Former Member — Wed, 11 Mar 2009 16:16:10 GMT

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

Re: Delete table entries

Former Member — Wed, 11 Mar 2009 16:30:12 GMT

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.

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

Re: Delete table entries

Former Member — Wed, 11 Mar 2009 16:34:35 GMT

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?

Re: Delete table entries

Former Member — Wed, 11 Mar 2009 16:35:50 GMT

Hi,

Yes thats right