如何给Add-on的透明表加更改Log

第零步：

维护系统参数 rec/client 。

 

第一步：

透明表的Technical settings里面勾中“Log data changes”，重新激活之。

 

第二步：

用Tcode：SCU3（程序RSTBHIST）来查看修改的Log，还可以看哪些表被Log了

 

注：

1.如果是全部清空然后再次插入，则不能捕捉到这个Log

2.如果SCU3不能看到数据，给这个表建立一个表维护再试试看

3.这样做的前提是系统的rec/client 参数已经维护了“ALL”或者指定的Client号

4.Log的数据记录在表DBTABLOG和DBTABPRT中

5.具体可以看Notes：1916、112388.

 

----------------------------------------------------------------------------------

 

Logging Table History

You can log the changes of data like append, modification or delete fields in a table.

When you create your transparent table, you can go to the technical settings screen and set the flag "Log data changes".
SE11 -> Technical Settings -> tick the Log data changes

Remember that you must have the parameter rec/client set in the system profile.
RZ10 - Extended Maintenance

• rec/client = ALL (log all clients)
• rec/client = 000(,...) (log all specified clients)
• rec/client = OFF (do not log)

You can see the changes to the table in the transaction OY18 or SCU3.

Logging is independent of update. Obviously, it will slow down the accesses when you change the table as record have to be written into the log table for each change.

DBTABLOG - Table of log records for table changes