Skip to Content
author's profile photo
Former Member

Logging changes in a Custom Table

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Posted on Aug 23, 2007 at 01:39 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 23, 2007 at 01:46 PM

    Hi,

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

    aRs

    Add comment
    10|10000 characters needed characters exceeded