Show TOC

Procedure documentationCreating Comparison Objects Locate this document in the navigation structure

 

A comparison object contains information about the systems that contain the data sources that you are comparing. You specify the type of data source that contains the data that you want to compare. This means the data can be in different types of data sources – such as ABAP or non-ABAP systems.

Note Note

Cross-database comparison uses RFC function modules to extract data from managed ABAP systems. You can specify which of the following types you want to use.

  • Generated extractor function module: Data-model specific function module, generated for each comparison object and transported from development to production system. For each change in a data model, new extractor function modules are generated and transported again.

  • Generic extractor function module: Receives the selection criteria from the cross-database comparison application, and can be used for all possible data models.

End of the note.

Prerequisites

At least two systems with a data source each are configured.

Procedure

  1. Choose   Comparison Object   Create  .

  2. Enter the name of the comparison object and choose Enter.

  3. Enter a description for the comparison object.

  4. Choose an extraction strategy. The following strategies are available:

    • Default: Individual data selection in each source system

      The data to be compared is selected independently in each system.

    • Use keys of source system 1 to select in source system 2

      The data block to be compared is first extracted from system 1. Then the keys identifying each record are used to extract the required data from system 2.

    • Use keys of source system 2 to select in source system 1

      The data block to be compared is first extracted from system 2. Then the keys identifying each record are used to extract the required data from system 1.

  5. Specify the type of data source in which the data is stored. The remaining details depend on the type of data source.

    You can use the following data sources:

    • SAP ABAP System (RFC to generated extractor): You choose this for an ABAP system. The data is read using a generated function module.

      Enter the following data:

      • RFC Connection (Read): Specify the connection that is used to read the data from the ABAP Dictionary of the source system.

        Choose Test Connection (Test Connection) to test the connection.

      • RFC Connection (Trusted): Specify the connection that is used to create the function module in the source system.

      • Function Module: Specify the name of the function module that is generated by the application.

      • Function Group: Specify the name of the function group (new or existing function group).

    • SAP ABAP System (RFC to generic extractor): You choose this for an ABAP system. The data is read using a generic function module.

      Enter the following data:

      • RFC Destination: Specify the connection that is used to read the data from the ABAP Dictionary of the source system.

        Choose Test Connection (Test Connection) to test the connection.

      • SQL Statement: SELECT: The select clause of the generated select statement identifying the data fields to be extracted.

      • SQL Statement: FROM: The from clause of the generated select statement identifying the tables to be read.

      • SQL Statement: Fixed WHERE: A part of the where clause of the generated select statement corresponding to the fixed filters of the data model.

      • SQL Statement: ORDER BY: Extracted data has to be provided, ordered by the keys.

    • Remote DB (Generic ADBC): You choose this for a non-ABAP system. The data is read using an SQL statement.

      • Database Connection: Specify the connection that is used to read the data for the comparison.

        Choose Test Connection (Test Connection) to test the connection.

      • Database Schema: Specify the name of the database schema from which the data is read.

      • SQL String (Extractor): The SQL statement used to run the comparison is displayed after generation.

      • SQL String (Count Statement): The SQL statement used to count the comparison objects is displayed after generation.

    • XML File on Application Server: You choose this for data that is stored in a XML file on an SAP Solution Manager application server.

      • File Path: Specify the path on the SAP Solution Manager application server under which the XML file containing the data to be compared is saved.

      • File Name: Specify the name of the XML file.

    • XML file on local PC: For comparison objects, no source-specific parameters need to be entered. You enter the file name at comparison instance level. For more information, see Creating Comparison Instances.

  6. The following settings are relevant for the comparison. Therefore, specify the following for all data sources:

    • Comparison Block Size: Specify the block size used to read the data for the comparison. You can use this value for the comparison according to your system performance.

    • Max No. Errors: Specify the number of error messages that are permitted until the system terminates the comparison.

      Enter 0 if you want the comparison job to be executed fully. Use this setting to prematurely terminate an incorrectly configured comparison that returns an error for every data record.

  7. Save your entries.

You have created a comparison object.

In this comparison object, now create the data fields that you want to compare with one another.