LOG changes

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[ferry_lianto]

Hi Kiran,

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

Regarsd,

Ferry Lianto

[Former Member]

hai kiran

check SU53

regds

kiran

[Former Member]

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.

[Former Member]

Hi

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.