topic Re: Follow up data table changes in Application Development and Automation Discussions

Follow up data table changes

Former Member — Mon, 22 Feb 2010 08:09:55 GMT

Hi experts,

I need to modify a data table according to the requirements. I need to log when and who modified the table and what fields are changed, what is the new and old value of the field.

Is there any possibility to follow up the changes in a simple way?

Re: Follow up data table changes

Former Member — Mon, 22 Feb 2010 08:28:51 GMT

Generate a table maintenance of this data table. take the reference of the document mentioned at link below to do the same. This document will give you an insight of how all the things which you require should be fulfilled.

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/60ffac76-93f3-2c10-a4b6-e33fb866d1fb

Hope this helps!!

Kanchan

Re: Follow up data table changes

Former Member — Mon, 22 Feb 2010 08:29:23 GMT

Hi Mr.White,

When you are modifying a field in the table, Go to the data element of the filed -> Further charecteristics tab -> Change Document (check box). If the that check box is checked, you can find the chanegs in the table CDHDR and CDPOS.

Here is reference on that.

http://wiki.sdn.sap.com/wiki/x/KwOmB

Regards,

Amuktha

Re: Follow up data table changes

Former Member — Mon, 22 Feb 2010 08:35:14 GMT

I wanted to avoid the use of these 2 tables. It takes a lot of time to read data from them.

Re: Follow up data table changes

Former Member — Mon, 22 Feb 2010 08:47:57 GMT

Hi Mr.White,

Or try a trace. ST05 is the tansaction 'Switch on the trace'. Do the required changes you have to make and see if you get the required results there and 'Switch off the trace'.

Regards,

Amuktha

Edited by: Amuktha Naraparaju on Feb 22, 2010 10:06 AM

Re: Follow up data table changes

Former Member — Mon, 22 Feb 2010 10:16:49 GMT

Amuktha,

I need to store the changes for a long time, so the trace is not a good solution for me. I think I will set the loging of the database change, but I wanted to avoid this.

Re: Follow up data table changes

christine_evans — Mon, 22 Feb 2010 10:28:20 GMT

You could try logging the changes in a separate custom table - the sort of thing that SAP does with CDHDR and CDPOS but since this will be a much smaller table with only your entries in it it will be quicker to read. This could be maintained either by an exit on your maintenance view if that's how you will maintaining the table or by your own code if it's maintained from a screen you've built yourself.

Re: Follow up data table changes

Former Member — Wed, 24 Feb 2010 09:47:54 GMT

Thanks for the replies.