topic Re: Regarding Log changes in table in Application Development and Automation Discussions

Regarding Log changes in table

Former Member — Mon, 14 May 2007 07:00:20 GMT

HI All,

1. how can we maintain(create) log whenever changes have been made in z table. normally for tables,we have some log created in SAP.how can we create log explicitly so that it caputres all changes in table.

2.if log is created explicity,how can we extract the information from log, so that it

must be available as report ?

please let me know soon.

Thanks.

Re: Regarding Log changes in table

Former Member — Mon, 14 May 2007 10:15:34 GMT

Hi Jay,

Selecting the check box 'Log data changes' in the technical settings option of the table will log all the data changes in a table.

In the table maintenance screen, we will have an option to see the data changes. However to generate this report we need to carry out some settings in RZ10.

Regards,

Hemanth

Re: Regarding Log changes in table

Former Member — Tue, 15 May 2007 11:34:07 GMT

Hi Hemanth,

I got helpful information from you upto some extent. i got some idea to do this. The information related to this is tablesCDHDR,CDPOS. where we can have infn about changes made to field,tcode,user ,date of changes etc .The idea is, after selecting change document checkbox while creating ztables, we can develop some report by writing some select query.The changes made to ztable is stored in CDHDR AND CDPOS.it can be as follows

select fields from cdhdr where objectid = some value is to be passed and objclass = some value is to be passed

MY question is who will create objclass,objectid. from where this value of objectid objclasscan be obtained related to Ztable.

Waiting for your reply

Thanks .

anilkumar