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.
Warning! Missing Authorization To use the Table component, access to the designated authority objects (RFC) in SAP must be available. For more information, see the knowledge base article on SAP User Rights: Table.
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.
Objects supported by the Table Component #
- Transparent tables
- ABAP CDS views
- Pool tables (joining not possible)
- Cluster tables (joining not possible)
How to use the Xtract Table component #
- Drag & drop the “Xtract Table” component to your Alteryx workflow.
- 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.
More information on working with the Xtract Table component is provided in the following sections.