The Transaction Server supports SAP table parameters. When you specify a SAP RCF interface module that contains a table, the To Enterprise section of the transport map identifies the table parameters.
Notice the record structure is indented.Tables in SAP can take arrays as input and output. When the parameter is identified as a table, the Transaction Server allows you to specify a row count for that table. A row count can be Rows In, Rows Out, and Rows In and Rows Out.
Rows In
When a SAP table is used as an Import or Changing
parameter, you can specify the maximum number of rows that
can be passed to the RFC interface module at run time. This
is the Rows In value under the
Value column which is only available for
parameters identified as Table with an
In parameter type.
The following example shows a Table
parameter that takes an array of records as input.
From the Table parameter row, double-click
the Value column and then type a value for
Rows In. For this example 2.
To automatically associate variables to the RFC interface parameters, click Map Parms. The value specified in Rows In is used to set the row count for the automatically generated input map variables.
If you do not specify a count for the array using
Rows In (before you click Map
Parms), you must manually edit the count for each
corresponding variable on the Input
tab.
Rows Out
When a SAP table is used as an Export or Changing parameter, you can specify the maximum number of rows that can be returned from the RFC interface module. This is the Rows Out value under the Value column which is only available for parameters identified as Table with an Out parameter type.
The following example shows a Table parameter that takes an array of records as output.
From the Table parameter row, double-click
the Value column and then type a value for
Rows Out. For this example 3.
To automatically associate variables to the RFC interface parameters, click Map Parms. The value specified in Rows Out is used to set the row count for the automatically generated output map variables.
If you do not specify a count for the array using
Rows Out (before you click Map
Parms), you must manually edit the count for each
corresponding variable on the Output
tab.
Row In and Rows Out
When a SAP table is used as a Changing parameter or as a table parameter, you can specify both a Rows In and Rows Out count. The Rows In value sets the maximum number of rows that can be passed to the RFC interface module, while the Rows Out value sets the maximum number of rows that can be returned from the RFC interface module.
The Rows In and Out value under the Value column is only available for parameters identified as Table with an In/Out parameter type. The following example shows a Table parameter that takes an array of records as input and output.
The Rows In and Rows Out
values do not have to be the same. If the table parameter
returns more rows than specified as the value in
Rows Out, they are ignored.
Example trigger with SAP transport map and special variable
This example describes a trigger that uses a transport map as an action. The transport map has a SAP table and Changing parameter with a Rows In and Rows Out count. When a transport map that contains a SAP table is added as a trigger action, the Input tab on the Trigger window contains the In parameters and the count value specified in Rows In.
When the trigger uses the transport, a special variable
appears at the bottom of the Input tab
where the number of rows can be overwritten and dynamically
assigned a value. The variable is identified by the table
name from the transport map followed by
_nbrRows. For example:
At runtime, the value of the special variable is used to
control how many rows to send. You can map the special
variable to a device variable, local variable, or constant.
Otherwise, it will default to the number specified in the
transport map (Count column) and will
always be the same number for each run.
Likewise, the Output tab on the Trigger window contains the Out parameters and the count value specified in Rows Out.
At the bottom of the Output tab of the
transaction, the _nbrRows variable is the
actual number of rows returned by the RFC interface
module.
The Rows Out value from the transport map
is the maximum number of rows that the Transaction Server
will keep from the transaction. However, if fewer rows are
returned than specified in Rows Out for a
given table, then this is the number returned in the
trigger Output tab.
The last step for the Transaction Server to interface with a SAP system is to create a trigger. When you create the trigger, you must have write authorization to the device variables that you assign to the map variables.