Skip to Content
avatar image
Former Member

How to find tables that log changes in CDHDR

Hello,

I am not sure this is the right forum, but other forums do not let me to post a new thread.

I wonder how can I find out the complete list of tables that have Log Data changes checked, meaning which tables will log changes in CDHDR and CDPOS.

Thanks

Galina

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 05, 2007 at 08:49 PM

    Hello Galina,

    The easiest and obvious way is to use transaction SCU3 and select the "List of logged tables" button. There are several dependencies which determine whether or not you will find a log there.

    If you search SDN and "OSS" (service.sap.com/notes) for "rec/client", "recclient" (without "/"!), "vers_at_imp" and "sobj" then you will find usefull information on the logging options.

    Note that if you have activated "recclient" in the transport profile, then the user ID for the change to the table will often be a transport request number. Changes to many tables and customizing objects are of course made in development systems. So you might want to consider activating some logging there as well.

    In my opinion, another usefull "log" is preventing changes, rather than finding them. Giving a little bit more users a little bit too much change access for S_TABU_DIS, S_DEVELOP, etc is like having a little bit more inflationhttp://en.wikipedia.org/wiki/Inflation">inflation> than you would want. 😊

    Cheers,

    Julius

    PS: It is strange that you cannot create threads in other forums. There was some "talk" about limiting the number of open threads per SDN user (10 was suggested) - because some people do not follow-up on and close the questions they have opened...

    That should not apply to you, and I am not aware that it is implemented (yet).

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Galina,

      >> Let say, we had a system's crash.

      That is again a different story. Are you a DB admin? You are stretching my knowledge here... in that case you need to restore DB logs. But I dont think that it is physically possible to get absolutely everything back again, because many objects which contain data only exist at runtime of the programs. You will have a tough time trying to find those in SE16 for example 😊

      >> However, I see entries for user C, who is in the same group as user A.

      >> I wonder, can it be that user A is using user's C login?.

      Strictly speaking, yes. The programmer can define that certain tasks triggered by user A are performed using "destinations" for example, and send the "table data" to the interface of a function module. Those tables, processing, and even creation of documents or change documents, can be running under user C (which is defined in the destination - see transaction SM59). A common solution to use is Workflow, where you can send tasks to "user C" so that user A's performance is better (and user A does not need the authorizations for those tasks). Ideally, those destinations are boring ones with limited boring authorizations.

      >> or it is because table CDHDR only logs fraction of changes, for some of

      >> the tables, but not for the others. So, I am on the search to find out.

      I am not sure about the construct of that table, but as mentioned before, if you want to go looking for data in SAP tables, then I think you are taking the wrong approach.

      Kind regards,

      Julius

  • avatar image
    Former Member
    Nov 06, 2007 at 10:03 PM

    I cannot award point in "answered" state

    Add comment
    10|10000 characters needed characters exceeded