Skip to Content

log history of SAP tables

Dear Experts,

I want to know whether SAP is maintaining a history file, for example if a standard program or table is changed i want to know the status of the information like who changed the program, value before change, changed value, changed time etc.

for my criteria i want to check the standard table DLV_SYSTC when there is a change i want to know that, what is the changed value, what is the new value, etc.

Regards

Arun.P

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Sep 28, 2010 at 11:42 AM

    activate changes protocollation of that table in SE11 thats all.

    Add comment
    10|10000 characters needed characters exceeded

    • Hey Florian,

      Now press F6 (change). Once in the table there is a button technical settings.

      Just to correct you, you press the "change" button once inside the "Technical Setting" 😊 This is because the table is standard.

      There check the bottom checkbox. now you activated the change protocollation for that table

      But this alone won't help. You have to turn on the "rec/client" parameter from RZ11 !

      Further details on Table logging can be found on the SAP Online help.

      BR,

      Suhas

  • avatar image
    Former Member
    Sep 28, 2010 at 01:02 PM

    STF! (Search the forum)...this is essentially a FAQ!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 06, 2010 at 10:24 AM

    T.code SE95

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 06, 2010 at 11:52 AM

    Hi Arun.

    as just everything with SAP this is not as easy as assumed.

    You can mark database tables in dictionary with 'record changes' which will work as soon on the system the REC/CLIENT parameter is turned on for all (or only specific) clients.

    SAP prefers this for customizing tables.

    For any tables with frequent changes this is not recommended because it slows down performance (and maybe other reasons).

    In business transactions relevant for (external) review, extra functionality is implemented to create so-called change documents.

    A change object is defined and changes can be recorded and retrieved with standard functions (-> change documents).

    This question can be answered more specific if you let us know what you are talking about. Ask a very specific and detailed question and see if you can generalize the answer. The other way round does not work at least not for SAP).

    Regards,

    Clemens

    Add comment
    10|10000 characters needed characters exceeded

    • Seems you led a lot of people the wrong way by not clearly describing the problem.

      What I understand from your last post is that you are looking for the version history of development objects, which is stored in tables VRSD and some others.

      You can try looking for your object in VRSD-OBJNAME to find out if it has been changed, then call the standard version history and comparison in order to find out what has actually been changed in detail.

      Thomas