Store database changes

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

Thank you for your answer.

I have two questions:

1)

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?

2)

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!