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.
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.