Compare SAP Tables
This workflow compares a selection of tables retrieved from two SAP systems, and generates an HTML report from the comparison results.
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 SAP Tables 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:
-
Select the System 1 parameter and choose ‘Edit RFC Destination’ from its context menu to display the RFC Destination dialog.
-
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 tables to compare:
-
Select the Table List parameter and choose ‘Edit Table’ from its context menu to display the Table Editor dialog.
-
Complete the following columns, removing the sample entries first, then click ‘Save’.
| Column | Description |
|---|---|
| NAME | The name of an SAP table to compare. |
| TYPE | Set this column to TABL. |
To specify the table rows to be compared and reported upon (optional):
o specify the table rows to be compared and reported upon (optional):
-
Select the Rows to Read parameter and choose ‘Edit Table’ from its context menu to display the Table Editor dialog.
-
Click ‘Insert Row’, complete the following columns.
| Column | Description |
|---|---|
| TABLE | The name of a retrieved table. |
| FIELD | The name of a column in the retrieved table. |
| OP | The comparison operator to use. One of BT, CP, EQ, GE, GT, LE, LT or NE. See the Select List Parameters help topic for details. |
|
LO |
The ‘low’ comparison value. |
| HI | If the BT (Between) operator is used, this column refers to the ‘high’ comparison value. |
| IE | Enter ‘I’ to include table rows that match this specification, or ‘E’ to exclude them. |
-
Continue from step 2 to create additional specifications, then click ‘Save’.
To specify the table columns to be compared and reported upon (optional):
-
Select the Columns to Compare parameter and choose ‘Edit Table’ from its context menu to display the Table Editor dialog.
-
Click ‘Insert Row’ and complete the following columns:
| Column | Description |
|---|---|
| TABLE | The name of a retrieved table. Alternatively, use the wildcard character ‘*’ to create a specification that applies to all the retrieved tables. |
| FIELD | The name of a table field. |
| IE | Enter ‘I’ to include this table field in the comparison results, or ‘E’ to exclude it. If there are any ‘I’ entries for a table, all ‘E’ entries for the table are ignored. |
-
Continue from step 2 to create additional specifications, then click ‘Save’.
To specify the table row comparison statuses to include in the report:
-
Select the Row Status to Keep parameter and choose ‘Edit String List’ from its context menu to display the String List Editor dialog.
-
Enter the comparison statuses to include. By default, the workflow reports on table rows with comparison statuses Different, In1 or In2. Each comparison status should be added as a separate string entry.
Save the workflow using the ‘Save’ toolbar button.
Running the Workflow
To run the Compare SAP Tables 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 Report URL dataset and choose ‘View Details’ from the context menu to access the generated report. Select the Counts dataset ‘View Details’ from the context menu to display a comparison summary for each of the tables.