The following section offers Alteryx sample workflows and templates for download.

Xtract BAPI #

Workflow Source System Description Source System
BAPI-ERP-Read-And-Write SAP ERP This workflow demonstrates using Xtract BAPI to create a purchase requisition in SAP and load the data of the purchase requisition into Alteryx.
SAP-Read-Long-Texts SAP ERP This workflow demonstrates reading SAP long texts in different languages.
SAP-Read-Attachment-Files SAP ERP This workflow demonstrates extracting attachments of all formats from an SAP systems, e.g., .pdf files of purchase orders. For more information on this workflow, refer to the knowledge base article Read and Download SAP Attachment Files.
BAPI - Sync PRs from ERP to S4 SAP ERP This workflow demonstrates syncing purchase requisitions from ERP to S/4. It involves creating a new requisition in ERP, checking its absence in S/4, syncing by generating corresponding entries in both systems, and confirming the presence in S/4.

Xtract Cube #

Workflow Source System Description Source System
Cube-BWInfoProvider SAP BW This workflow demonstrates using Xtract Cube to load data from an SAP BW InfoProvider.
Cube-BWQuery SAP BW This workflow demonstrates using Xtract Cube to load data from an SAP BW Query.

Xtract Hierarchy #

Workflow Source System Description Source System
Hierarchy-BW SAP BW This workflow demonstrates using Xtract Hierarchy to load data from an SAP BW CostCenter hierarchy. This workflow also showcases the different hierarchy representations “Parent-Child” and “Natural”.

Xtract ODP #

Workflow Source System Description Source System
ODP-BW-Full SAP BW This workflow demonstrates using Xtract ODP to load sales documents and customer master data from an SAP BW system. The loaded data is then combined, cleaned, and prepared for further analysis.
ODP-BW-Delta SAP BW This workflow demonstrates using Xtract ODP to load delta sales documents and customer master data from an SAP BW system. Sales documents are loaded using Xtract ODP’s delta function, which retrieves only changed data since the last execution.
ODP-ERP-Full SAP ERP This workflow demonstrates using Xtract ODP to load sales documents and customer master data from an SAP ERP system. The loaded data is then combined, cleaned, and prepared for further analysis.
ODP-ERP-Delta SAP ERP This workflow demonstrates using Xtract ODP to load delta sales documents and customer master data from an SAP ERP system. Sales documents are loaded using Xtract ODP’s delta function, which retrieves only changed data since the last execution.
For more information on this workflow, refer to the knowledge base article ODP based Delta Extraction of Sales and Customer Data.
ODP-S4-Full SAP S/4HANA This workflow demonstrates using Xtract ODP to load business partner master data from SAP S/4HANA CDS views. The loaded data is then cleaned and filtered for further analysis.
ODP-S4-Delta SAP S/4HANA This workflow demonstrates using Xtract ODP to load the delta data of suppliers and customers from SAP S/4HANA CDS views. The loaded data is then checked for missing address information.

Xtract Report #

Workflow Source System Description Source System
Report-ERP-ABAPReport SAP ERP This workflow demonstrates using Xtract Report to load data from the ABAP Report RLT10010 (Evaluation of Movements per Storage Type).
Report-S4-TCode SAP S/4HANA This workflow demonstrates using Xtract Report to load a list of sales orders from an SAP S/4HANA transaction.

Xtract Table #

Workflow Source System Description Source System
Table-ERP SAP ERP This workflow demonstrates using Xtract Table to load customer master data and to prepare the data for further analysis in Excel or a 3rd party BI solution.
Table-ERP-Join SAP ERP This workflow demonstrates using Xtract Table to perform a table join of the SAP tables KNA1 (Customer Master Data) and KNVV (Customer Master Sales Data) and to prepare the data for further analysis in Excel or a 3rd party BI solution.
Table-S4 SAP S/4HANA This workflow demonstrates using Xtract Table to load data from SAP S/4HANA’s Universal Journal and to prepare the data for further analysis in Excel or a 3rd party BI solution.
Table-S4-Dynamic-Parameters.yxmd SAP S/4HANA This workflow demonstrates how to use scalar and list parameters with the Xtract Table component.