R/3 Consistency 
The Database Alert Monitor display contains, among other things, results of the consistency checks between the ABAP Dictionary and the database system.
Prerequisites
The database instance is the basis of the current SAP Web AS system.
Procedure
1. Start the Database Alert Monitor.
2. Choose <Name of the database connection> ® R/3 Consistency.
Result
The system displays the following:
· R/3 Consistency Check: displays when the last consistency check was performed. If no inconsistencies were found, the system displays a green alert.
·
Objects Missing in the Database: yellow and red alerts
indicate that some ABAP Dictionary objects (primary indexes, secondary
indices, tables, and views) could not be found in the database instance. If
you double-click the relevant alert, you can perform additional analyses.
If an object was intentionally deleted in the database instance during
development, or if a database error occurred during creation, this list of
missing objects can be important for the customer objects. Objects that could
not be found in the database instance can cause transports to be incomplete or
contain errors, and conversions to terminate.
Create the missing objects in the database system.
·
Unknown Objects in ABAP Dictionary: yellow and red alerts
indicate that database objects (tables, indices, and views) have not been
defined in the ABAP Dictionary. If you double-click the relevant alert, you
can perform additional analyses.
Since the objects do not belong to the SAP system, this list is mainly
intended for information purposes. The objects are directly created by means
of the database system. If the author is unknown, you can determine the
purpose of the object in some cases by using the display function. Since the
data display in an SAP system is based on the ABAP Dictionary definitions,
data can be displayed only by using the database system.
Always create customer tables, views, and indices with the ABAP Dictionary.
This is the only way of ensuring that the objects are recognized by the SAP
system and that problems are avoided during the upgrade.
·
Inconsistent
Objects: yellow and
red alerts indicate that the definitions of the objects (primary indices,
secondary indices, tables, and views) in the ABAP Dictionary are not the same
as those in the MaxDB database catalog.
Compare the object definition in the ABAP Dictionary with the definition in
the catalog and correct the wrong definition.
· Other Checks: multiple checks are performed, including the check whether the primary indices of the tables defined in the ABAP Dictionary were created exclusively in the database instance, and whether there are objects in the SAP base tables that cannot be described or only incompletely described in the ABAP Dictionary.
·
Optional Indices: the
optional database indices found in the ABAP Dictionary are defined indices.
Also displayed here are all the indices that were defined in the ABAP
Dictionary but that are flagged as not being allowed to be created in your
database instance.
Determine if these indices have either been created or not been created as
intended.
See also: