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 different systems. By doing so, you check whether the data in the source and target systems is consistent, for example, whether updates in the source system have been correctly 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.

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

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 Connectivitiy (ADBC)

  • XML files on a Solution Manager application server

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. To do so, configure the relevant settings in Customizing for business process monitoring.

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

Implementation Considerations

You use this application because you suspect that there are inconsistencies between systems and want to check the data consistency of your systems.

Prerequisite: You have the roles and authorizations required to use 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 to edit a specific task, but display-only authorization for the other tasks.

Integration

The cross-database comparison is a separate application and therefore independent of other applications. No further components are required to use this application.

Features

  • You create comparison objects. In a comparison object, you specify which data from which data sources you want to compare and create filters.

  • You create comparison instances. A comparison instance contains a comparison object. In a comparison instance, you specify which specific systems are to compared using which filter settings.

  • You schedule comparisons. By doing so, you specify when and how often you compare the relevant data sources.

  • You display the comparison results. By doing so, you can see where the inconsistencies are in the data sources.

  • You can create guided procedures. By doing so, you can provide guidance to investigate the potential root causes of inconsistencies reported.

    For more information, see Guided Procedure Authoring (GPA).