Compare Table Set Actions
Compare Table Set actions compare the table objects retrieved into two Table Set datasets. These datasets may be populated by the Retrieve Table Set or HR Get Payroll Data actions. Tables with the same name in each dataset are compared.
| Action Property | Description |
|---|---|
| Counts | A Table Set dataset containing a comparison summary for the compared tables. |
| Result | A Table Set dataset in which to store the comparison results. |
| Source1 | A Table Set dataset containing tables to be compared from the first SAP system. |
| Source 2 | A Table Set dataset containing tables to be compared from the second SAP system. |
The Counts dataset has the following columns:
| Column | Description |
|---|---|
| Name | The name of each compared table. |
| NumRows | The number of rows in the table. |
| In1 | The number of table rows that exist only in the first system compared. |
| In2 | The number of table rows that exist only in the second system compared. |
| Same | The number of rows that are the same in the compared table. |
| Different | The number of rows that are different in the compared table. |
| Status | The comparison status for the table. |
| Description | The description for the table. |
Example:
To examine the details for a Compare Table Set action, double-click the action node, or select ‘View Details’ from the node’s context menu. The Details screen displays the number of objects compared in each table.
The progress of a Compare Table Set action may be monitored by viewing the Details screen while the action is running. Time estimates are available after a sufficient number of tables have been compared, relative to the total number of tables. The following details are shown:
| Item | Description |
|---|---|
| Total objects | The total number of tables to compare. |
| Remaining objects | The number of tables that have not yet been compared. |
| Elapsed time (seconds) | The time for which the Compare Table Set action has been running. |
| Estimated total time (seconds) | The estimated total time for which the Compare Table Set action will run. |
| Remaining time (seconds) | The estimated remaining time for which the Compare Table Set action will run. |
| Remaining time (hours/minutes) | The estimated remaining time (in hours or minutes) for which the Compare Table Set action will run. |
| Total elapsed time hh:mm:ss | The time for which the Compare Table Set action has been running in hours, minutes and seconds. |
If a Compare Table Set action is interrupted (for example because its RFC Destination becomes unavailable) choose ‘Continue’ from the action’s context menu to continue the analysis from the point at which it was interrupted.
Press the F5 key periodically to update the display.