Compare Selective Table Content

This workflow compares the specified rows and columns from a named table on two SAP systems.

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 the Compare Selective Table Content 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 the name of the table to compare:

  1. Select the Table Name parameter and view its details in the Property Editor.

  2. Enter a table name in the parameter’s ‘String’ property.

To specify which table columns to compare:

Select the Columns to Read parameter and view its details in the Property Editor.

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

  2. Click 'Insert Row' to enter the name of each table column, then click ‘Save’. Each column name should be added as a separate string entry. This parameter should be set to contain all the table's key fields, apart from MANDT.

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. Click ‘Insert Row’ and update the selection criteria table as follows, by completing the lower part of the dialog:

Column Description
Field This field should refer to a column name from the table to be compared.
Operator The comparison operator to use: One of EQ, GT, GE, LT, LE, BT or CP. See the Select List Parameters help topic for details.
Low Value The ‘low’ comparison value.
High Value If the BT (Between) operator is used, this column refers to the ‘high’ comparison value.
I/E Select ‘I’ to include these objects in the filtered results, or ‘E’ to exclude them. If the ‘E’ option is used, you must create an ‘I’ specification for the same object type.

  1. Continue from step 2 to create additional specifications, then click ‘Save’.

Save the workflow using the ‘Save’ toolbar button.

Running the Workflow

To run the Compare Selective Table Content 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 the Compared Table Contents dataset and choose ‘View Details’ from the context menu. The Status column in the dataset lists the comparison status for each of the compared rows.