Read SAP Table and Join actions join a source
Table parameter or dataset with matching rows retrieved from an SAP table.
The results are stored in a Table dataset, which includes all the columns
from the source table, plus the specified columns from the SAP table.
Action Property
Description
Adds
A Pair List
parameter specifying which columns from the SAP table should be added
to the Result dataset. The first item in each pair is the name to be used
for the column in the result dataset. The second item in each pair refers
to a column from the SAP table.
Default Data
A Table parameter
or dataset which provides a structure
for the SAP table if the table specified in the Table Name parameter could
not be found, or returns no rows.
Key Map
A Pair List
parameter specifying how rows from the Source table should be matched
with rows from the SAP table. The first item in each pair refers to a
column name in the Source table. The second item in each pair refers to
a column name from the SAP table. For SAP data to be included in the result
dataset, each of the Pair Lists in the Key Map parameter must produce
a successful match. The Key Map parameter should normally identify a single row in the SAP table for each row in the Source table.
Result
A Table dataset
which stores all the columns from the Source table, plus the SAP table
columns specified in the Adds parameter.
RFC Destination
An RFC Destination parameter
or dataset referring to the
system from which to retrieve the SAP table.
Rows to Read
A Select
List parameter specifying which SAP table rows to read. If this action
property is not set, all the rows from the SAP table will be read. SAP
table columns from the Key Map may not be used in the Rows to Read parameter.
Source
A Table parameter
or dataset specifying the source table
to be joined.
Table Name
A String parameter
or dataset containing the name of the
SAP table to be read. Table names should be specified using UPPER CASE.
Example:
To examine the details for a Read SAP Table
and Join 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 table, the number of records in the Result table,
the number of records read from the joined SAP table and the number of
records used from the joined SAP table. The time taken for the action
to complete is also shown.
The progress of a Read SAP Table and Join action
may be monitored by viewing the Details screen while the action is running.
Time estimates are available after a sufficient number of table rows have
been processed, relative to the total number of rows. The following details
are shown:
Item
Description
Objects done
The number of SAP table rows read so far.
Total elapsed time hh:mm:ss
The time for which the Read SAP Table and Join
action has been running in hours, minutes and seconds.
Press the F5 key periodically to update the
display.