SAP Query - Extract Data from SAP ECC & SAP S/4HANA with SQ01 Queries

[#1]

This workflow from DVW Analytics uses the Alteryx Connector for SAP (ACS) to demonstrate how to extract Extract Data from SAP ECC & SAP S/4HANA with SQ01 Queries into Alteryx.

This workflow provides:

1. An example of how to extract data from SAP Queries to give detailed information of a named table and the associated fields of that table. The SAP query has been created in SAP using transaction code SQ01. It contains two tables DD02L and DD03L which have been joined together using the key fields TABNAME.

2. The table name is passed dynamically via a text input using the ACS Filter tool

3. The table name is then passed into the SAP Query tool when executed and the relevant data is extracted.

• Works with: SAP ECC, SAP S/4HANA
• SAP Read Tools used: SAP Query tool, ACS Filter tool 
• SAP Write Tools used: N/A