topic Re: Activating Change log in Application Development and Automation Discussions

Activating Change log

Former Member — Mon, 04 Aug 2014 05:05:10 GMT

Hi Experts,

I need to activate change log for Ztable.

Can You please tell me how to do the step by step process.

Is there any effects of this particular change.

Thanks in advance.

Re: Activating Change log

former_member212124 — Mon, 04 Aug 2014 05:16:29 GMT

Hi Nagireddy,

Goto Techincal settings (application tool bar) in SE11

and check the log data changes check box.

To check the Log Go to CDPOS table...

Go To CDPOS table -> GIve your ztable Table Name or View Name in field TABNAME and Execute..

we will get all changes for your Table or View.

If you want know Change Log for Particular Field give your ZTable field as FNAME.

By Seeing VALUE_OLD and VALUE_NEW u can get Changed values.

Thanks,

vidyasagar

Re: Activating Change log

rosenberg_eitan — Mon, 04 Aug 2014 05:38:30 GMT

Hi,

If you interested in change documents you can use in your maintenance program :

CALL FUNCTION 'CHANGEDOCUMENT_OPEN'
CALL FUNCTION 'CHANGEDOCUMENT_SINGLE_CASE'
CALL FUNCTION 'CHANGEDOCUMENT_CLOSE'

Please use se37 "where use" for FUNCTION CHANGEDOCUMENT_SINGLE_CASE .

Make sure that your z* fields have "Indicator for writing change documents" .

Other useful functions:

CHANGEDOCU_KEY_ANY2CHAR
CHANGEDOCUMENT_READ
CHANGEDOCUMENT_DISPLAY

Regards.

Re: Activating Change log

Former Member — Mon, 04 Aug 2014 05:50:10 GMT

Hi,

As mentioned by vidyasagar,

Goto Techincal settings (application tool bar) in SE11

and check the log data changes check box.

Than you can also use transaction SCU3 transaction evaluate the logs. To the log the changes apart from technical setting , profile parameter ''rec/client' also has to be set ( Consult the basis team)

Thanks & Regards,

Arun

Re: Activating Change log

Former Member — Mon, 04 Aug 2014 07:25:34 GMT

Thanks Aruna.

can u please tell me more abt profile parameter "rec/client". where we need to mention and whose responsibility is this and all

Re: Activating Change log

Former Member — Mon, 04 Aug 2014 07:38:20 GMT

To know about the parameter goto RZ11 transaction and put the parameter and display the documentation. You need to check with Basis team whether this parameter maintained ?.In production system they will usually maintain this parameter but in quality or development system you need to check with your basis team. Simply Don't activate change log for a table (like transaction table), if it necessary than only use it.

Thanks & Regards,

Arun

Re: Activating Change log

former_member201285 — Mon, 04 Aug 2014 09:22:19 GMT

Hi,

you can also use transaction SCDO, where you can create a customer individual object. The system will generate a suitable FM for you automatically. This generated FM encapsulates the other FMs mentioned by you.

Maybe, this way is a little bit more comfortable...

Regards,

Ulrich

Re: Activating Change log

Former Member — Mon, 04 Aug 2014 09:28:03 GMT

Hi,

Check this it has step by step process

http://wiki.scn.sap.com/wiki/display/ABAP/ABAP+-+Data+Change+Tracker+for+Custom+Tables

Regards,

Nitin

Re: Activating Change log

Former Member — Tue, 05 Aug 2014 10:34:06 GMT

I Have done the activation of change log. I have checked RZ11 tocode. it is also activated.

but I am unable to see the change log in SCU3 TOCE.

can u please tell me how to check the changes.

what is the main purpose of this activation of change log.

Thanks in advance.

Re: Activating Change log

Former Member — Tue, 05 Aug 2014 11:15:35 GMT

Have you checked the F1 documentation of Log Data Changes (Technical Setting -> Log Data Changes)? Change log will record the changes done to table which will give change history of table like last person, old value, new value which will be useful in auditing, troubleshooting the issues etc

Its only recommend for configuration tables because it will slowdown the table access(Please read document for more details)

Have you done any changes to table after activating the change log ?