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

More Function Module
Functions / SAP Script / ALV

Tables
Database Table

ABAP Books List
ABAP/4 Certification, Programming, Smartforms, Sapscripts and Object Oriented Programming Books

Smart Forms
SAP Smartforms

ABAP Menu:
ABAP Example Hints and Tips

Return to Index:-
SAP ABAP/4 Programming, Basis Administration, Configuration Hints and Tips

(c) www.gotothings.com All material on this site is Copyright.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
All product names are trademarks of their respective companies.  The site www.gotothings.com is in no way affiliated with SAP AG.
Any unauthorised copying or mirroring is prohibited.