Read SAP Table and Join Actions
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.