Table Change log

[Former Member]

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.

[ThomasZloch]

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

[Former Member]

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

[ThomasZloch]

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

[Former Member]

Hi,

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

Regards,

Klaus

[ThomasZloch]

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

[andrea_olivieri]

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

[Former Member]

Hi Folks,

Thanks a lot for your responses.

Andrea , you are right, it works!!!

Thanks once again.

Regards

Nishant Gupta