SAP Purchasing - Extract SAP Purchasing Document Data, Invoice Data and Vendor Master Data

Jie_DvW

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

This workflow provides:

1. Examples of how to extract data from Purchasing Document Header (RBKP) and Item (RSEG) tables, Purchasing Invoice Document Header (EKKO) and Item (EKPO)  tables.

2. An example of how to extract Vendor Master  Data from the primary Vendor Master Data tables (LFA1, LFBK, LFB1).

3. Examples of important Configuration Data tables (EKBE, T169G, TIBAN). 

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

Extract SAP Purchasing Document Data, Invoice Data and Vendor Master Data from SAP ECC & SAP S_4HANA.yxmd