Each Import, Export, Changings and Tables parameter can have one of the following representations:
- A scalar field (e.g., characters, date, time, number, amount etc.).
- A structure consisting of several components.
- A table (tabular array of data) consisting of columns (data values of the same type) and rows (data records).
Import Parameters #
Import parameters represent the input values sent from the client to SAP.
In the tab Imports you can define import parameters that can be presented as scalar values or structures.
To use the filtering function, enter text in the headers of the columns Name and Description.
Add Scalar Parameters (1)
Scalar fields for inputs are usually set using the following two options:
- A static constant value (
icon or no icon).
- An SSIS variable / parameter (
icon).
Click on the icon next to the input field to switch between static input values and SSIS variables / parameters.
When using variables, make sure the input matches the data type.
Note: Parameters that are predefined by SAP are displayed in a light grey font.
To disable these parameters, activate the checkbox next to the parameter and leave the field empty.
Add Structures as Parameters (2)
When using a structure, a value for each scalar field can be set similarly to a scalar field. Setting a single value or a parameter for the whole structure is not possible.
When a structure is available, you can assign structure elements (i.e. fields).
- Click the
icon. The window “Edit Structures” opens.
- Enter constant values (
or assign SSIS variables / parameters (
icon) under Values.
Export Parameters #
Export parameters represent the output values sent from SAP back to the client after execution of a function module.
In the tab Exports you can add scalar values, structures or tables to the output.
Add Items to Output
Mark the checkbox in the output column to add an item to the output.
To use the filtering function, enter text in the headers of the columns Name and Description.
Changing Parameters #
Changing parameters represent parameters that can be used for input and output.
In the tab Changings you can define changing parameters that can be presented as scalar values, structures or tables.
Table Parameters #
Tables parameters are parameters presented in a table structure consisting of multiple rows. Tables can be used for input and output.
In the tab Tables you can define table parameters for importing and exporting into and from an SAP BAPI.
To use the filtering function, enter text in the headers of the columns Name and Description.
Note: Only 5 tables are available for parallel exporting.
Access Metadata of Tables (1) #
Click the icon to display the metadata of the selected table including the name and the data type of all fields.
If the function module was edited in SAP, you can refresh the data by clicking Refresh metadata
Add Tables to Output (2) #
Mark the checkbox in the output column to add a table to the output.
Edit Tables (3) #
When using a structure, a value for each scalar field can be set similarly to a scalar field. Setting a single value or a parameter for the whole structure is not possible.
When a structure is available, you can assign structure elements (i.e. fields).
- Click the
icon to edit the table. The window “Edit Table Contents” opens.
- Click [Add] to add new set of parameters.
- Enter values or parameters.
When using variables, make sure the input matches the data type. - Click [Remove] to delete a row.
Mapping Input Tables #
When connecting tables to the Xtract BAPI component, a data mapping is executed automatically.
To correctly map the data, the following requirements must be met:
- The column names of the input table must be the same as in the Xtract BAPI component.
- The data types in the input table must be the same as in the Xtract BAPI component.
Click on the icon next to a table to look up column names and data types in the Xtract BAPI component.
Tip: If the column names and / or datatypes of the input table and the Xtract BAPI table do not match, add a Derived Column component to convert the input data.