topic Re: Dictinary table to log changes in Application Development and Automation Discussions

Dictinary table to log changes

Former Member — Tue, 30 Jun 2009 12:09:23 GMT

Hi Gurus

I was wondering if there is a table in SAP which stores a log of changes made to any given table which details the date modified and user who modified it. I don't mean just the last modification, I mean all or at least the 10-20 last changes made.

Regards,

Simon

Re: Dictinary table to log changes

former_member188829 — Tue, 30 Jun 2009 12:13:29 GMT

Hi,

Check the table:DBTABLOG

Re: Dictinary table to log changes

Former Member — Tue, 30 Jun 2009 12:20:05 GMT

Hi,

DBTABLOG is the only table that store all the log changes to any database.

Regds,

Anil

Re: Dictinary table to log changes

former_member188829 — Tue, 30 Jun 2009 12:24:30 GMT

Hi,

If you are talking about Database Records, You can check the tables CDHDR and CDPOS.

Re: Dictinary table to log changes

Former Member — Wed, 01 Jul 2009 03:46:09 GMT

Hi,

Use table CDPOS...

Re: Dictinary table to log changes

Former Member — Wed, 01 Jul 2009 06:36:16 GMT

DD02L also logs the time changed

Re: Dictinary table to log changes

Former Member — Wed, 01 Jul 2009 11:48:40 GMT

Hi,

If you want to check the table entries log, USe CDPOS/CDHDR table.

To check the table structure change log, Use the Version management utility.

GO to Se11/12 --> utilities --> version management

compare the verison....

Re: Dictinary table to log changes

Former Member — Thu, 02 Jul 2009 11:29:33 GMT

Hi,

please check table CDHDR. IT maintans all table changes.