topic Re: Log Data Changes ...... in Application Development and Automation Discussions

Log Data Changes ......

Former Member — Mon, 25 Oct 2010 08:55:10 GMT

Hello Friends

I am a functional consultant, looking for some inputs from Log Data Changes Setting.

My problem is there is a Z table for which in SE11----under technical setting -

Log data changes Tick has not been marked. Because of this, the change and deletion records are not updated in CDHDR and CDPOS table.

I want to know, if i mark the setting as Log Data Changes, whether the change and delete history will be updated in CDHDR and CDPOS table. In case if the history will not generate ...... is there any other way to do so ...... like creating a function module so that these changes will be stored ......

can some one let me know what logic will be require for this issue to be resolved. Since i am functional consultant my understanding on the technical part is limited.

Many thanks

Vikul

Re: Log Data Changes ......

Former Member — Mon, 25 Oct 2010 09:00:40 GMT

Hi,

Check if the entries are logged in DBTABLOG table.

Regards,

Srini.

Re: Log Data Changes ......

Former Member — Mon, 25 Oct 2010 09:11:56 GMT

Hello

Thanks for the update ...... I have checked and the entries are coming in th DBTABLOG table. However i am looking for old value and the new value which i am not able to see ........ this table is giving the details such as when the record was created and the user id details ......

Any further inputs .....????

Many thanks

Vikul

Re: Log Data Changes ......

Former Member — Mon, 25 Oct 2010 09:15:02 GMT

Hi,

You can find whether the record is created , deleted or updated with the field : OPTYPE

I think it will also contain the old and new values.

Regards,

Srini.

Re: Log Data Changes ......

nabheetscn — Mon, 25 Oct 2010 09:18:03 GMT

For that you need to have log data changes checked as well as for the data element change document indicator should be set.

F1 help for data element

Indicator for writing change documents

Use

This flag is used to create change documents for business objects.

You can create a change document object for a business object. This change document object contains the tables in which the data of the business object is stored. Function modules that are called in the corresponding application programs and that log the changes at runtime can be generated from the change document object.

Logging only takes place if the fields whose contents were changed refer to a data element that was flagged as relevant for the change document.

You can go to the maintenance screen for change documents from the initial screen of the ABAP Workbench with Development -> Other tools -> Change documents.

Nabheet

Re: Log Data Changes ......

ThomasZloch — Mon, 25 Oct 2010 09:23:28 GMT

Why don't you use "DBTABLOG" as search term for example here in SDN, you would find plenty of information on how the values are stored in this table, which transaction or program to use in order make the logged data "human readable", etc...

Thomas