Compare Objects Actions
The Compare Objects action compares a list of objects on two specified RFC Destinations. The results are stored in a Table dataset.
| Action Property | Description |
|---|---|
| Columns to Compare | A Table parameter or dataset specifying the table columns to be displayed and compared in the Result dataset. If this action property is not set, all table columns will be displayed and compared. |
| Extractor Mode | A Boolean parameter which determines the mode in which the action will run. If this parameter is set to ‘true’, the Compare Objects action retrieves code in the same way as the LiveCompare Data Extract program, using a separate function to retrieve code for object types PROG, MODP, SUBP, FUGR, INCL and CLAS. If the parameter is set to ‘false’, the action does not use a separate function, and runs in the same manner as LiveCompare 3.2.1 and earlier releases. If this property is not set, ‘false’ is used as the default value. |
| Object Attribute Filter | An Object Attribute Filter parameter specifying which object attributes are to be considered during the comparison. |
| Result | A Table dataset in which to store the comparison results. |
| RFC Destination1 | An RFC Destination parameter or dataset referring to the first SAP system for which to compare data. |
| RFC Destination2 | An RFC Destination parameter or dataset referring to the second SAP system for which to compare data. |
| Rows to Read | A Table parameter or dataset specifying the table rows to be displayed and compared in the Result dataset. If this action property is not set, all table rows will be displayed and compared. |
| Source | A Table parameter or dataset specifying a list of objects to be compared. The table should have at least a NAME column containing the name of each object, and a TYPE column specifying each object’s type. Object types should be specified using UPPER CASE. |
| Source Name Column | A String parameter set to the name of a column from the Source table which contains the names of the objects to be compared. The default value for this parameter is NAME. |
| Source Type Column | A String parameter containing the name of a column from the Source table which contains the types of the objects to be compared. The default value for this parameter is TYPE. |
| Types to Compare | A String List parameter containing the object types to be compared. If this action property is not set, all object types in the Source table will be compared. |
The Result dataset includes all the columns from the Source table, and a STATUS column which indicates the comparison status for each object:
| STATUS | Description |
|---|---|
| Same | The object is the same in each of the compared systems. |
| Different | The object is different in each of the compared systems. |
| In1 | The object exists in the first compared system only. |
| In2 | The object exists in the second compared system only. |
| NotCompared | The object was not compared. |
| CantCompare | The object could not be compared. |
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 a retrieved table. Alternatively, use the wildcard character ‘*’ to create a specification that applies to all the retrieved tables. |
| FIELD | The name of a retrieved table. Alternatively, use the wildcard character ‘*’ to create a specification that applies to all the retrieved tables. |
| 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 the ‘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 compared for tables that do not have a ‘Rows to Read’ specification.
| 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. |
| OP | The comparison operator to use: One of EQ, GT, GE, LT, LE, BT or CP. |
| 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. |
See the Select List Parameters help topic for further details.
Example:
To examine the details for a Compare Objects action, double-click the action node, or select ‘View Details’ from the node’s context menu. The Details screen displays the number of records in the Source and Result tables, a summary of the objects’ comparison statuses, and the time taken for the action to complete.
The progress of a Compare Objects 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 compared, relative to the total number of objects. The following details are shown:
| Item | Description |
|---|---|
| Total objects | The total number of objects to compare. |
| Remaining objects | The number of objects that have not yet been compared. |
| Elapsed time (seconds) | The time for which the Compare Objects action has been running. |
| Estimated total time (seconds) | The estimated total time for which the Compare Objects action will run. |
| Remaining time (seconds) | The estimated remaining time for which the Compare Objects action will run. |
| Remaining time (hours/minutes) | The estimated remaining time (in hours or minutes) for which the Compare Objects action will run. |
| Total elapsed time hh:mm:ss | The time for which the Compare Objects action has been running in hours, minutes and seconds. |
Press the F5 key periodically to update the display.
If a Compare Objects 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.