topic Re: LOG changes in Application Development and Automation Discussions

LOG changes

Former Member — Wed, 08 Nov 2006 16:36:02 GMT

Hi All,

When we create a database table and in the technical settings if we set LOG changes flag ticked where will the changes get logged into. I mean the table where the changes will be logged. Can somebody please help me with this.

Regards,

Kiran

Re: LOG changes

Former Member — Wed, 08 Nov 2006 16:38:25 GMT

Hi,

I believe it is stored in the table DDNTT_HIST..Which is not in the DDIC..

Check the FM DD_NTAB_HIST_GET of how to get the data..

Thanks,

Naren

Re: LOG changes

Former Member — Wed, 08 Nov 2006 16:41:00 GMT

Hi Naren ,

When I am trying to access the above said tables its giving me an error like

Table DDIC is not active in the Dictionary

Is there anyway we can see the changes please.

Regards,

Kiran.

Re: LOG changes

ferry_lianto — Wed, 08 Nov 2006 16:41:12 GMT

Hi Kiran,

Please check table DBTABPRT and also you can use transaction SCU3 to display record changes.

Regarsd,

Ferry Lianto

Re: LOG changes

Former Member — Wed, 08 Nov 2006 16:41:38 GMT

DBTABLOG stores db table changes. Report RSVTPROT can be used to read the logs.

Re: LOG changes

Former Member — Thu, 09 Nov 2006 13:14:11 GMT

hai kiran

check SU53

regds

kiran

Re: LOG changes

Former Member — Fri, 10 Nov 2006 20:25:26 GMT

in addition to activating LOG changes flag for the table you'll need to enable logging on the system, and it will log changes to ALL tables which have this flag ticked.

Re: LOG changes

Former Member — Mon, 13 Nov 2006 15:06:13 GMT

You can display logs for a table by using SCU3 transaction.

But just checking the Log option in the technical settings of a table is not enough to maintain modification history; <i>rec/client</i> parameter has to be set which is usually done by basis guys.

Regards

Surya.