Track Table chnages

[Former Member]

Hello ,

I would like to know that is there any way to get SAP database( table entries) changes.

By using Change documents (CDHDR , CDPOS) we can only get new and old values of any record.

But I need to entire record. Is there any settings need to perform to save all changes.

Thanks in advance

Jagadeesh

[Former Member]

Hi Jagadeshwar

Enable the table logging option in the technical settings of the table, which will track all the changes of a record.

Details of those changes can be seen in the transaction SCU3.

Regards

Prabumanoharan

P.S: If that table is frequently updated , there will be performance issues.

[Former Member]

It is really helpful .I am able to see all Table list for which LAST CHANGES check button is flagged. But I am unable to see the change log in SCU3 Transaction. Could you guide me from SCU3.

Thank in advance.

Jagadeesh

[Former Member]

You have an input field where u can give the table / view name , date time and the type of display.

Fill in all the required details and execute you'll get the detials.

if u use older versions you may have radio buttons to choose , where u can choose 'List change docs' for the above options.

Regards

Prabumanoharan

[Former Member]

Thanks for your help.

I have given the all information and execute it and I could't see any change documents even i have maintained data in the table.

I doubt about the settings . Do we need to do any setting apart from Checking the LAST CHNAGES at Technical settings in table.

When i exicute the Transction SCU3 . I got the message that 'Table logging is not currently active in your system . Do you want to analyse the logs anyway'. Am I getting the problem due to this message .

I don't have much time to search..

Please guide me .

Thanks in advance.

I am also getting the message 'No authorization group containing the following tables'

Guide me plz..

Edited by: Jagadeshwar Gollapelly on Jun 15, 2009 7:19 PM

[Former Member]

Hi

Make sure that u've checked the 'Log data changes' option in the technical settings of the table and activated it. Then on every chang will be logged and u can see the changes.

Regards

Prabu

[nicholas_steffens]

Hi Jag,

If you get a message saying table logging is not currently active in the system you'll need to set profile parameter 'rec/client' in transaction RZ11.

To switch on logging, the R/3 System must be started with a profile containing parameter rec/client.

This parameter defines whether all clients or only selected clients should be logged.

The parameter can have the following values:

rec/client = ALL (Log all clients.)

rec/client = xxx (Log the specified clients.)

rec/client = OFF (Do not log. )

Log the specified clients is the recommended setting and the system will need to be restarted for the changes take effect.

For more information, see the SAP help page here:

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eaf9446011d189700000e8322d00/content.htm

Regards,

Nick