Show TOC

Component documentationCross-Database Comparison Locate this document in the navigation structure

 

You use this application to compare data sources with a complex structure or hierarchy. You can also do this across systems. You check whether the data is consistent in the source and target systems, for example, whether updates in the source system have been replicated to the target system. Examples of complex data sources are sales orders with several billing items, or a customer master record containing multiple addresses, partner roles, and bank details.

The data sources must contain the same data logically, but they can have different values once they have been forwarded to a different system, for example, from an ERP system to a CRM system.

Implementation Considerations

You perform this comparison to check the data consistency of your systems, because there may be inconsistencies between them.

Prerequisite: You have the roles and authorizations required by the application.

The following roles are delivered for cross-database comparison:

Generic roles:

  • SAP_CDC_ADMIN: Process champion

    Contains full authorization for all cross-database comparison tasks.

  • SAP_CDC_DISPLAY

    Contains display-only authorizations for various cross-database comparison tasks, related to comparison objects, instances, and results.

Specific roles for typical cross-database comparison tasks:

  • SAP_CDC_OBJECT_MODELER: Object Modeler

  • SAP_CDC_INSTANCE_CREATOR: Instance Creator

  • SAP_CDC_INSTANCE_EXECUTER: Instance Executer

  • SAP_CDC_INSTANCE_ANALYZER: Instance Analyzer

Each role has full authorization for one task, and display only authorization for the others.

Features

You can:

  • Model the data you want to compare

  • Compare data at any time, or schedule regular comparisons

  • Display the results in an overview containing all the relevant details

This is a generic application, which means that you can use it to check the data consistency in both ABAP and non-ABAP systems. You can use this application to compare the following data sources:

  • Tables from the ABAP Dictionary

  • Tables that are linked via ABAP Database Connectivity (ADBC)

  • XML files on a Solution Manager application server, or on your local PC

  • Tables in an SAP HANA database

You use the application as follows:

  • Once, to check new links between data sources

  • When necessary, to check existing links

  • Regularly, to monitor important data

You can display the results of the comparison in business process monitoring, by making the relevant settings in Customizing for business process monitoring.

The cross-data comparison application is in the BPO dashboard. You can create a dashboard for specific comparison instances. For more information, see Business Process Operations Dashboard.