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 (1) or structures (2).

Define-Bapi-Data-Source

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

Add Scalar Parameters (1)

Use one of the following options to set scalar parameters:

  • A static constant value - static-value icon or no icon.
  • A dynamic value set at runtime - dynamic-value icon, see Runtime Parameters.

Click on the icon next to the input field to switch between static input values and runtime parameters. When using runtime parameters, make sure the input matches the data type.

Note: Parameters that are predefined by SAP are displayed in a light gray font.
To disable these parameters, activate the checkbox next to the parameter and leave the field empty.

Add Structures as Parameters (2)

When a structure is available, 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 pen. The window “Edit Structures” opens.
  2. Enter constant values ( static-value icon or no icon) or assign runtime parameters ( dynamic-value icon). BAPI import parameters

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 define export parameters that can be presented as scalar values, structures or tables.

Add Items to Output

Mark the checkbox in the output column to add an item to the output.

BAPI export parameters

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.

Within the tab Tables you can define table parameters for importing and exporting into and from an SAP 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.

Note: Only 5 tables are available for parallel exporting.

  • Click glasses to check the names and data types of the table fields (1).
  • Activate the checkbox next to the items to add items to the output (2).
  • Click pen to edit tables (3).

BAPI table

Access Metadata of Tables (1) #

Click the glasses icon to display the metadata of the selected table including the name and the data type of all fields.

Add Tables to Output (2) #

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

Edit Tables (3) #

  1. Click the pen icon. 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 input matches the data type.
    BAPI edit table
  4. Click [Remove] to delete a row.

Mapping 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 glasses-icon 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 Xtract BAPI 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.
    bapi-input-table2
  3. Open the Xtract BAPI component and navigate to the table you want to parameterize.
  4. Select an input table from the dropdown list.
    bapi-input-table

To remove an input table from a structure, click x-icon.

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.

BAPI edit table