The following section offers Alteryx sample workflows and templates for download.
SAP Migration Scenarios #
The following workflows are designed to support an SAP migration, e.g., ECC to S/4HANA.
| Workflow | Description |
|---|---|
| Data Anonymization and Replication to QA system | This workflow uses the Xtract Table component to create development and testing data sets with anonymized data from the productive system to speed up quality assurance processes. |
| Short-term bridge app.yxwz | This workflow uses the Xtract Table component to support an SAP migration that is done in a phased approach by extracting the data from the relevant system depending on the user input. |
| Source & Target Validations - Report level.yxmd | This workflow uses the Xtract Report component to validate data integrity between source and target. |
| Source & Target Validations - Table level.yxmd | This workflow uses the Xtract Table component to validate data integrity between source and target. |
| Source & Target Validations - Table & other.yxzp | This workflow uses the Xtract Table component to validate data integrity between source and target. This workflow can be used for tests and demos, as it uses a flat file as a target to resemble the source system with minor changes that are discovered in the reconciliation. |
Xtract BAPI #
| Workflow | Source System | Description |
|---|---|---|
| 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 |
|---|---|---|
| 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 |
|---|---|---|
| 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 |
|---|---|---|
| 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. |