Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Follow up data table changes

Former Member
0 Kudos
134

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?

1 ACCEPTED SOLUTION

Former Member
0 Kudos
66

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

7 REPLIES 7

Former Member
0 Kudos
66

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
0 Kudos
67

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

0 Kudos
66

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

0 Kudos
66

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

0 Kudos
66

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.

0 Kudos
66

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
0 Kudos
66

Thanks for the replies.