About the Table Component #

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

For an introduction to the component and its basic functions, see Getting Started with Xtract for Alteryx.

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.

See further information on possible restrictions and on installing the custom function module.

Note: 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., time stamp.

Tip: ODP component is a more convenient option for incremental extraction e.g., using extractors.

To Use Table Component #

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

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

Table Main Window - Functions Overview #

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

The following sections contain details on the component:

Tables and Fields

Table Joins

WHERE Clause

HAVING Clause

Extraction Settings

Avoid Restrictions