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.

Create RFC Destinations

Before you begin, you will need to create RFC Destinations for each of the systems you wish to compare. Although LiveCompare provides a default set of authorizations, the SAP accounts associated with these RFC Destinations may require additional authorizations in order to access the tables that are being compared.

Prepare the workflow

To prepare the Compare Derivative Table Content workflow, drag its workflow template from the Templates > Prerequisites 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 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.

Click Save tool button. to save the workflow.

Run the workflow

To run the Compare Derivative Table Content workflow, click the Run tool button. toolbar button, choose Run Now from the diagram’s context menu, or select 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.