table log 남기기

 

table 생성 시

1. 기술적 세팅에서 데이터 변경사항 로그에 체크

2. 테이블 유지보수 생성기 생성

 

SCU3 에서 log 를 조회 할 수 있다.

 

 

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.

DBTABPRT - Table of log records for table changes