SAP Sales - Extract Sales Document Data, Customer Master Data and Configuration Data

[#1]

This workflow from DVW Analytics uses the Alteryx Connector for SAP (ACS) to demonstrate how to extract  Sales Document Data, Customer Master Data and Configuration Data from SAP ECC & SAP S/4HANA into Alteryx.

This workflow provides:

1. Examples of how to extract data from Sales Document Header (VBAK) and Item (VBAP) tables, Delivery Document Header (LIKP) and Item (LIPS) tables and Billing Document Header (VBRK) and Item (VBRP) tables.

2. Examples of the primary Customer Master Data tables ( KNA1, KNB1, KNKK, KNVV).

3. Examples of important Configuration Data tables including Sales Organizations (TVKO, TVZBT, TVFKT, AUFK).

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