The following section describes the functions of the Table component of Xtract for Alteryx.
The Table component can be used to extract content from SAP tables and views and process it in Alteryx. The Table component is also used to join several tables on the SAP side, see Table Joins.

Table component supports the following table types:

  • Transparent tables
  • Pool tables
  • Cluster tables

Note: when extracting tables from SAP you may encounter several restrictions when using the SAP standard function module (RFC_READ_TABLE). To avoid possible restrictions, you can use the Theobald Software custom function module Z_THEO_READ_TABLE on your SAP system. For further information on possible restrictions and on installing the custom function module, see Custom function module for Table.

Tip: The Table component is generally used for full load. For incremental data extraction from tables and views, you can define a WHERE-clause on specific fields e.g., timestamp. The ODP component is a more convenient option for incremental extraction e.g., using extractors.

How to use the Table component #

  1. Drag & drop the “Xtract Table” component to your Alteryx workflow.
  2. Select an SAP connection, navigate to Selected Extraction and click [Edit]. The main window of the component opens.

The majority of the functions of the component can be accessed using the main window.

Tip: To get information on the basics of Xtract for Alteryx, refer to Getting Started with Xtract for Alteryx.

Functions overview #

The following sections give an overview over the functions that can be accessed over the main component window. Table Extractor

More information on working with the Table component is provided in the following sections.


Tables and Fields

Table Joins

WHERE Clause

HAVING Clause

Extraction Settings

Avoid Restrictions