C - Data Analysis

The Data Analysis Consolidation workflows compare application data from a SAP table on two specified SAP systems. In each workflow, the name of the SAP table to be compared is stored in a String dataset, with a node label that corresponds to the workflow’s application area. For example, the Purchase Order Data Analysis workflow compares the EKKO table, whose name is stored in the Purchase Order string dataset.

The comparison results are stored in four table datasets showing:

  • Table rows that are different (conflicting) in each of the compared systems.

  • Table rows that are the same in each of the compared systems.

  • Table rows that are unique to the first compared system.

  • Table rows that are unique to the second compared system.

Creating RFC Destinations

Before you begin, you will need to create RFC Destinations for each of the SAP systems you wish to compare.

Preparing the Workflow

To prepare a Data Analysis workflow, drag its workflow template from the Templates folder into your own workspace, and modify the workflow as follows:

To specify the systems to compare:

  1. Select the System 1 parameter and choose ‘Edit RFC Destination’ from its context menu to display the RFC Destination dialog.

  2. Select the RFC Destination for the first system to compare, then click ‘Save’.

Repeat the above steps to link the System 2 parameter to the RFC Destination for the second system to compare.

To specify which table rows to compare:

  1. Select the Rows to Read parameter and choose ‘Edit Select List’ from its context menu to display the Select List Editor dialog.

  2. Modify the selection criteria to define which table rows to compare. See the Select List Parameters help topic for details.

Save the workflow using the ‘Save’ toolbar button.

Running the Workflow

To run a Data Analysis workflow, click the 'Run' toolbar button, choose ‘Run Now’ from the diagram’s context menu, or press F5. The currently running workflow action is marked with an animated display. When the workflow execution has completed, select each of the Conflicting Records, Same Records, Unique Sys1 Records and Unique Sys2 Records datasets, and choose ‘View Details’ from the context menu to view the result tables.