topic Re: Logging changes in a Custom Table in Application Development and Automation Discussions

Logging changes in a Custom Table

sharadendu_agrawal — Thu, 23 Aug 2007 13:15:57 GMT

Hi All,

We have two custom tables. Now the requirement is to log the changes of the first table in the second table.

In the second table if any value in the first table is changed then both the old and the new values should be stored as two different entries. The second table has fields for all the entries in the first table with the names like field1_old, field1_new, field2_old, field2_new.

So we need to log both the old and the new entries.

Plz help me.

Regards,

Sharadendu

Re: Logging changes in a Custom Table

Former Member — Thu, 23 Aug 2007 13:39:08 GMT

How do you maintain the first table? Did you create the maintenance module yourself or did you get it generated by SAP? If you have your own maintenace module, all you have to do is get the values from the table at the time when you update it and seve the necessary values in the second table. If you have a generated maintenance module, then you would have to do this in there, problem is you will need to register the onject when you change it.

Let me know if this helps.

Re: Logging changes in a Custom Table

former_member194669 — Thu, 23 Aug 2007 13:46:00 GMT

Hi,

Same functionality you can get it thru by creating a Change document using transaction SCDO.

aRs