Activating Change log

[Former Member]

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.

[Former Member]

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.

[former_member212124]

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

[rosenberg_eitan]

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.

[former_member201285]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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 ?

[Former Member]

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