Define Input & Output

This page contains an overview and description of the Import, Export, Changings and Tables parameter in the Xtract BAPI component.

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.

Scalar Parameters

Assign single values to an import parameter by using one of the following options:

• If the input field is empty, enter a static value.
• If a checkbox is displayed in the input field, the parameter is predefined in SAP. The value in SAP is displayed in a light gray font. To disable the predefined value, activate the checkbox and leave the field empty or enter a new value.
• If [ ] is displayed in the input field, enter a static value. Click [ ] to switch between static values and dynamic values that are set at runtime.
• If [ ] is displayed in the input field, select a runtime parameter. Click [ ] to switch between dynamic values and static values.

When using runtime parameters, make sure the data type of the input matches the data type in SAP.

Structure Parameters

When a Function Module / BAPI uses structures as import parameters, you can assign structure elements (i.e. fields) similarly to single scalar fields. Setting a single value or a parameter for the whole structure is not possible.

1. Click [ ]. The window "Edit Structures" opens.
2. Enter static values ( [ ] icon or no icon) or assign runtime parameters ( [ ] icon).
   

Export Parameters

Export parameters represent the output values sent from SAP back to the client after the execution of a Function Module. In the tab Export you can select the items you want to add to the output of the component.

Add Items to Output

Mark the checkbox in the output column to add an item to the output of the component. The selected output is assigned to the output anchor 'E' of the Xtract BAPI component.

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 the changing parameters.

Table Parameters

Table 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 data into and from an SAP Function Module or BAPI.

Tables represent a structure of multiple rows of the same data type.

To use the filtering function, enter text in the headers of the columns Name and Description.

• Click [ ] to check the names and data types of the table fields .
• Activate the checkbox in the output column to add items to the output .
• Click [ ] to edit tables .

Access Metadata of Tables

Click [ ] to display the metadata of a table. The metadata includes the name and the data type of all fields.

Add Tables to Output

Mark the checkbox in the output column to add a table to the output.

The selected tables are assigned to the output anchors of the Xtract BAPI component. The number of tables that can be added to the output is limited to 5 tables.

Edit Tables

You can assign tables elements (i.e. fields) similarly to single scalar fields:

1. Click [ ]. The window "Edit Table Contents" opens.
   
2. Click [Add] to add new set of parameters.
   
3. Enter values or runtime parameters.
   When using runtime parameters, make sure the data type of the input matches the SAP data type.
   
4. Click [Remove] to delete a row.

Map Input Tables

To correctly map the data of an input table, the following requirements apply:

• 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 [ ] next to a table to look up column names and data types in the Xtract BAPI component.

Follow the steps below to pass tables to the Xtract BAPI component at runtime:

1. Define or load the input tables into your workflow.
2. Connect the input tables to the Xtract BAPI component using the input anchor "I".
   The number that is displayed in the connection arrow is used to identify tables in the Xtract BAPI component.
   
3. Open the Xtract BAPI component and navigate to the table you want to parameterize.
4. Select an input table from the dropdown list.
   

To remove an input table from a structure, click [ ].

Exceptions

Exceptions refer to ABAP exceptions / errors messages of an SAP BAPI. If an exception occurs during runtime, Xtract for Alteryx returns a corresponding error message.

By default, all exceptions result in errors when running the Xtract BAPI component. To ignore exceptions during runtime, deselect the exceptions in the Exceptions tab.