Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Overview

Cross Database Comparison (CDC) can be used to compare data sources with a complex structure or hierarchy. Furthermore the comparison can be executed across different systems. The user can check whether the data in the source and target systems is consistent, e.g. whether the 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.

CDC supports:

  • Creating a data model which contains all tables and fields to be compared
  • Comparing data on demand or schedule regular comparison runs
  • Displaying a result overview including all relevant details

In order to use CDC, the following technical prerequisites have to be fullfilled:

  • Correct version of the software components
  • Activation of necessary services
  • User authorization
  • Connections to the data source system(s)

For detailed information regarding the prerequisites, refer to the documents in the Media Library / SAP notes mentioned at the end of this page.

Motivation

Customers often ask the following questions:

  • How can I check data between different SAP or Non-SAP systems for consistency?
  • How can I proceed if I face an inconsistency that cannot be detected by standard consistency check tools, but I do not want to write additional coding for each of the required checks?

 

 

From those questions, the following requirements for Cross Database Comparison can be derived:

  • ŸData in different systems including Non-SAP systems or XML files needs to be checked for consistency
  • ŸTypical use cases include ad-hoc or regular end-to-end comparison of master or transactional data exchanged between multiple systems including Non-ABAP systems

Architecture

Cross Database Comparison is a generic application. Therefore it is possible to check the data consistency in both ABAP and non-ABAP systems.

Related SAP Notes

SAP Note 521820: Availability of Business Process Monitoring
SAP Note 1819794: CDC: Generic extractor function module
SAP Note 1984964: CDC: Generic extractor function module for IDC-usecase

  • No labels