Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
venkateshorusu
Active Contributor
0 Kudos

Program RSTBHIST which has been provided by SAP which can be used to track the changes made to a table or customizing object by an user.


Log data changes

The logging flag defines whether changes to the data records of a table should be logged. If logging is activated for the specific table, every change (with UPDATE, DELETE) to an existing data record by a user or an application program is recorded in a log table in the database.


Note: Activating logging slows down accesses that change the table. First of all, a record must be written in the log table for each change. Secondly, many users access this log table in parallel. This could cause lock situations even though the users are working with different application tables.


Logging flag activation can be decided by a technical consultant while designing a table i.e all standard table technical setting are made by SAP.

Dependencies


Logging only takes place if parameter rec/client in the system profile is set correctly. Setting the flag on its own does not cause the table changes to be logged.


The existing logs can be displayed with Transaction Table history (SCU3) as well.


Let we will see how to use.


Go to SE38 - RSTBHIST or Transaction code SCU3.









By passing the Input parameters on selection screen like above we can log the changes made to specific table or particular customizing Object with User name,Date,Time,etc.


Here in my case i would like to know the changes made to table T52C5 with specific period,T52C5 table being used to store the Personnel calculation rules i.e it gives all PCR's with details, When and Who has created, changed, Deleted for a particular period, Which has been entered on the selection screen.












Where we can see the details Date,User name,Time, Rule name,and the content what we have created,changed and deleted similarly we can find out for other tables as well.
















Regards

Venkatesh






9 Comments
Labels in this area