topic Re: Store database changes in Application Development and Automation Discussions

Store database changes

Former Member — Wed, 20 Sep 2006 14:31:15 GMT

Hello,

i have got a database table where i want to store all changes (insert, delete, update). This database table can be modified by a bsp-application or manuel in the transaktion se16.

I heard that this can be made by "Änderungsbelege" but i have no idea how i can do it.

greetings

Ronny

Re: Store database changes

Former Member — Wed, 20 Sep 2006 14:32:31 GMT

1) Check the check-box for “log changes” option in technical settings for the table.

2) The table which has all the log data is DBTABLOG

3) The FM to read DBTABLOG table is DBLOG_READ_TABLE.

Re: Store database changes

Former Member — Wed, 20 Sep 2006 14:49:26 GMT

Hi,

in se11-technical settings of table->set table log on

all the changes to the table can be stored in

table dbtablog.

check standard program RSTBPROT.

Regards

Amole

Re: Store database changes

Former Member — Wed, 20 Sep 2006 14:56:10 GMT

Table logging and change documents are not the same.

Table logging logs changes to a file, while change documents approach created change documents for every change (these documents are saved in CDHDR/CDPOS tables).

I would suggest you use change documents and not table logging. For more info you can search sap help for "Change documents".

Procedure

Define change document object

Set change document flag

Generate update and INCLUDE objects

Integrating the functionality into the program

Writing the fields in the program

References

Creating change documents

Read and format change documents

Re: Store database changes

Former Member — Mon, 25 Sep 2006 13:40:57 GMT

Thank you for your answer.

I have two questions:

I have generated the change document object in single case mode (without the internal table).

Is this correct to use this mode, if i want to write db changes out of the bsp into the changing documents?

Then I have generated the "Verbucher" to create the include file.

Now I have a problem to compile the inlcude file which will be used for the change document object. I get the message "table-statement is not correct in methods"

Thank you for your help!