Follow up data table changes

[Former Member]

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?

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[christine_evans]

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.

[Former Member]

Thanks for the replies.