topic Re: Table Change log in Application Development and Automation Discussions

Table Change log

Former Member — Mon, 13 Dec 2010 09:52:21 GMT

HI folks,

I have activated change log for a custom table but I am unable to see the changes in SCU3. System parameter rec/client is configured fine.

Table DATA class is APPL1 size cat. 0 There is no maintainenace view This table is updated from a custom report.

Pls advice.

Re: Table Change log

ThomasZloch — Mon, 13 Dec 2010 11:45:14 GMT

Did you check directly in table DBTABLOG for the TABLE name? Are there any entries? If yes, try all different options of SCU3 and see if any of them works. If not, then let's investigate further.

Thomas

Re: Table Change log

Former Member — Mon, 13 Dec 2010 11:51:40 GMT

Hi,

check the table field's data elements. There must be flag "Change Document" set in "Further Characteristics".

Regards,

Klaus

Re: Table Change log

ThomasZloch — Mon, 13 Dec 2010 11:54:21 GMT

Klaus, this is a widespread misunderstanding, this checkbox is only effective for creation of change documents in CDHDR/CDPOS, but not for table logging in DBTABLOG.

Thomas

Re: Table Change log

Former Member — Wed, 15 Dec 2010 11:52:18 GMT

Hello Thomas,

Thanks for your reply. I checked in the table entries are there but nothing is displayed in SCU3. Even I am able to see changes in AUT10.

Regards

Nishant Gupta

Re: Table Change log

ThomasZloch — Wed, 15 Dec 2010 11:58:43 GMT

So DBTABLOG has entries but SCU3 is not showing them, and you tried all options like "table" instead of "customzing object", all output options, and the selected period is also correct?

Sorry, no further idea at this point. Try debugging SCU3 to find the problem.

Thomas

Re: Table Change log

andrea_olivieri — Wed, 15 Dec 2010 13:57:07 GMT

Hi,

the table logging doesn't work because the assignment of your table to an authorization group is missing (because you didn't define a maintenance dialog).

So, in order to solve your issue, you have to create an entry for your table in the view view V_DDAT_54 via SM30.

For more information check the following OSS note:

[Note 323636 - Log analysis: Table is not in authorization group|https://service.sap.com/sap/support/notes/323636]

Regards,

Andrea

Edited by: Andrea Olivieri on Dec 15, 2010 2:59 PM

Re: Table Change log

Former Member — Thu, 16 Dec 2010 08:49:37 GMT

Hi Folks,

Thanks a lot for your responses.

Andrea , you are right, it works!!!

Thanks once again.

Regards

Nishant Gupta