topic Re: Database table update in Application Development and Automation Discussions

Database table update

Former Member — Mon, 19 Sep 2005 14:12:26 GMT

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 — Mon, 19 Sep 2005 14:25:11 GMT

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 — Mon, 19 Sep 2005 14:25:59 GMT

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 — Mon, 19 Sep 2005 14:29:05 GMT

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