topic Re: Tracking changes in database tables in Application Development and Automation Discussions

Tracking changes in database tables

Former Member — Thu, 06 Nov 2008 17:53:49 GMT

Hi,

I have a couple of database tables on which more than 20 people work each day, throughout the day. I have the requirement of tracking each and every change made on any row of the table.

For example, If a user accesses a specific row, and updates, or deletes it, i need to keep a track of the userid of the user who did it.

Is that possible?

Re: Tracking changes in database tables

Former Member — Thu, 06 Nov 2008 17:57:38 GMT

USe the Property Log Data Changes in the Tech Setting of the Table. You need to Select the CheckBox provided for this.

Re: Tracking changes in database tables

KalC — Thu, 06 Nov 2008 19:06:39 GMT

Hi Bharat,

If they are Z tables i.e custom tables then you can incorporate two more fields userid and time. Now goto Table maintanence generator through SE11.Then select Environment->Modification->events. Now in the next screen select F4 for first field to select the event i.e when your code has to be executed.Then give a new form name and click on editor icon. write your code here. When ever a user changes any record his name will be included in user id and sy-uzeit in time field. This way you can track who has changed the record. Other option is activating table changes recording by selecting "LogChanges " check box in technical settings of table.and profile parameter rec/client should also be switched on. Then you can see your table changes in SCU3 transaction. Hope this helps.

Regards,

Kalyan.

Re: Tracking changes in database tables

Former Member — Fri, 07 Nov 2008 06:00:27 GMT

My tables are present in ECA (ecatt) system. I guess they have turned off logging of the database table changes system wide. I tried with scu3, and no logs are being displayed. The only alternative is the one you have mentioned is it?