Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

log history of SAP tables

former_member206441
Contributor
0 Kudos

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

9 REPLIES 9

Former Member
0 Kudos

activate changes protocollation of that table in SE11 thats all.

0 Kudos

Hi

I m monitoring the DLV_SYSTC because the transaction SE06(Change Monitoring) when the modifiable field is updated it is changed in DLV_SYSTC table

Where should we do protocollation? pls explain me in detail.

Regards

Arun.P

0 Kudos

transaction SE11.

input table name in top input field. in your case DLV_SYSTC.

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

There check the bottom checkbox. now yxou activated the change protocollation for that table, which means once something gets changed in your table DLV_SYSTC you will get a new records in tables CDHDR and CDPOS containing the old value and the new.

0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

T.code SE95

Clemenss
Active Contributor
0 Kudos

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

0 Kudos

Hi Clemens

I want to know the table or a RFC of SAP which maintains log history of ABAP objects, any inputs regarding the same will be much helpful

Regards

Arun.P

0 Kudos

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