This section describes how you analyze data
with the help of the Browse Data function.
This
function is mainly used to analyze metadata for historical rates.
For more information about how to use the Browse data function,
see Browsing Data.
Typically, analyzing metadata is a two step process, where you start
by looking in the saoverview table to find information about the specific
table to look for.
For a more detailed description of the content
of the metadata tables, see the metadata tables appendix.
- Go to Maintain/Special
Utilities/Browse Data.
- Select the saoverview view and the desired fields to include,
for example Table name, controlleruser, actiontype and changedate.
- Click Run.
The saoverview
table is displayed, with information about all the tables where changes
have been logged. All log tables begin with sax.
- Find the table that you want to view log details for, for
example saxkstruc.
- Go to the Browse Data window again,
and select the desired table, in this example saxkstruc, and the fields
that you want to view for that table.
The saxkstruc
table is displayed.
The actiontype column will display
the four possible action types. If a value has been updated, the table
will display the original value on one row, and the new values on
the following row. The action types INSERT and DELETE may be displayed
even if there has been no manual changes by a user. This is because
the system uses these action types for database actions running automatically.