Compare SAP Tables Actions
Compare SAP Tables actions perform a row by row comparison of a list of SAP tables from two specified RFC Destinations. The results are stored in a Table Set dataset.
| Action Property | Description |
|---|---|
|
Columns to Compare |
A Table parameter or dataset providing a specification for the SAP table columns to be compared. If this parameter is not set, all table columns will be compared. |
|
Counts |
A Table dataset containing a comparison summary for each of the SAP tables. |
| Exceptions | A Table dataset which stores any exceptions generated by the Compare SAP Tables action. |
|
Result |
A Table Set dataset in which to store the compared tables. |
|
RFC Destination1 |
An RFC Destination parameter or dataset referring to the first SAP system from which tables are to be compared. |
|
RFC Destination2 |
An RFC Destination parameter or dataset referring to the second SAP system from which tables are to be compared. |
|
Row Status to Keep |
A String List parameter defining the row comparison statuses to include in the Result dataset. The String List parameter may contain the values ‘Same’, ‘Different’, ‘In1’ or ‘In2’. If this action property is not set, all comparison statuses are included. |
|
Rows to Read |
A Table parameter or dataset providing a specification for the SAP table rows to be retrieved. If this parameter is not set, all table rows will be retrieved. |
|
Table List |
A Table parameter or dataset containing the names of the SAP tables to compare. The Table parameter should include a NAME column in which the table names are listed. |
If the ‘Columns to Compare’ table is specified, it should include at least the following columns. All table columns are compared for tables that do not have a ‘Columns to Compare’ specification.
| Column | Description |
|---|---|
|
TABLE |
The name of table from the Table List parameter or dataset. Alternatively, use the wildcard * to create a specification that applies to all the tables. |
|
FIELD |
An SAP table column name. |
|
IE |
Enter ‘I’ to include this column in the table comparison results, or ‘E’ to exclude it. If there are any ‘I’ entries for a table, all ‘E’ entries for the table are ignored. |
If the ‘Rows to Read’ table is specified, it should include at least the following columns. All table rows are retrieved for tables that do not have a ‘Rows to Read’ specification.
| Column | Description |
|---|---|
|
TABLE |
The name of table from the Table List parameter or dataset. Alternatively, use the wildcard * to create a specification that applies to all the tables. |
|
FIELD |
An SAP table column name. |
|
OP |
A comparison operator to use for the specification: One of EQ, GT, GE, LT, LE, BT or CP. |
|
LO |
The ‘low’ comparison value. |
|
HI |
If the ‘BT’ operator is used, this field refers to the ‘high’ comparison value. |
|
IE |
Enter ‘I’ to include table rows that match the specification, or ‘E’ to exclude them. |
See the Select List Parameters help topic for further details.
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 tables. |
|
Description |
The description for the table. |
The Exceptions dataset has the following columns:
| Column | Description |
|---|---|
|
Table |
The table for which the exception was generated. |
|
Message |
The exception raised. |
Example:
To examine the details for a Compare SAP Tables action, double-click the action node, or select ‘View Details’ from the node’s context menu. The Details screen displays the total number of rows retrieved for each compared table and the time taken for the action to complete.
The progress of a Compare SAP Tables action may be monitored by viewing the Details screen while the action is running. Time estimates are available after a sufficient number of objects have been processed, relative to the total number of objects. The following details are shown:
| Item | Description |
|---|---|
|
Total objects |
The total number of tables to be compared. |
|
Remaining objects |
The number of tables that have not yet been compared. |
|
Elapsed time (seconds) |
The time for which the Compare SAP Tables action has been running. |
|
Estimated total time (seconds) |
The estimated total time for which the Compare SAP Tables action will run. |
|
Remaining time (seconds) |
The estimated remaining time for which the Compare SAP Tables action will run. |
|
Remaining time (hours/minutes) |
The estimated remaining time (in hours or minutes) for which the Compare SAP Tables action will run. |
|
Total elapsed time hh:mm:ss |
The time for which the Compare SAP Tables action has been running in hours, minutes and seconds. |
Press the F5 key periodically to update the display.
The Compare SAP Tables action does not support the comparison of SAP tables with variable length fields, for example, fields with the STRG data type. Views may be created for these SAP tables if they need to be compared.
If a Compare SAP Tables action is interrupted (for example because an RFC Destination becomes unavailable), choose ‘Continue’ from the action’s context menu to continue the comparison from the point at which it was interrupted.