Compare Derivative Table Content

This workflow compares rows in a given table that have different keys. You specify the name of the table, the key field that is different, the columns to read, and optionally other selection criteria for the rows to be compared. Since the table keys are different, the table data being compared can be from two different SAP systems or the same SAP system.

Creating RFC Destinations

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

Preparing the Workflow

To prepare the Compare Derivative 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. Save the workflow using the ‘Save’ toolbar button.

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 the key field that is different:

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

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

  3. Select the Key in Sys 1 parameter and view its details in the Property Editor.

  4. Enter the key field value for System 1 in the parameter’s ‘String’ property.

  5. Select the Key in Sys 2 parameter and view its details in the Property Editor.

  6. Enter the key field value for System 2 in the parameter’s ‘String’ property.

By default the workflow will select rows in the table on System 1 that have the key field value for System 1 that you specified above. Likewise on System 2, the workflow will select rows on System 2 that have the key field value for System 2. If you need to specify additional selection criteria, you can modify the Statements parameter as follows:

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

  2. Use the dialog to enter additional SQL statements that define the additional selection criteria. If, for example, you want to compare only those rows that have PROGRAMM = 'ABCD', you would add the SQL statement.

INSERT INTO Result (FIELD, OP, LO, HI, IE) SELECT 'PROGRAMM', 'EQ', 'ABCD', 'I'

By default the workflow will compare all columns of the table. You have the option to specify which table columns to compare. To do this:

  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 to read, then click 'OK'. This parameter should be set to contain all the table's key fields, apart from MANDT.

Save the workflow using the ‘Save’ toolbar button.

Running the Workflow

To run the Compare Derivative 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.