Database table update

[Former Member]

Hi All,

I have a table say A, i have a lot of entries in it& has been used in several pgms.

now i hav to create a table B and if any row in table A is modified, B should contain the Old & new value of that row.

now the logic for copying the modified row is done.

but i want to schedule the program only when table A is accessed by any of the pgm's. is there any way to do it.

Regards

Raghavendra

[Former Member]

You need not create a new table B.

Just activate the Log Data Changes in SE11 in Technical Settins of the table.

All the chnages are logged in table DBTABLOG.

Later you can see the changes in transaction SCU3.

Give the table name , date range and execute.

Cheers

[Former Member]

hi,

you mean to say about change logs.. In this case select the check box in the data element - > further characteristics - > change document.

then the changes will be captured and available in the cdpos table.

Cheers,

Sasi

[christian_wohlfahrt]

Hi Raghavendra!

Your requirement can be fulfilled with change documents. Have a look at documentation of transaction SCDO.

Shortly:

- create your own change document object (SCDO)

- with generation you get ~4 includes, one FM

- put these includes in every program, which updates your table

- call FM with old value / new value parameters.

Now SAP will create change documents, so some functions are already available for display purpose.

Regards,

Christian