Sample Alteryx workflows that use SAP Purchasing data

In a previous blog we identified the most important SAP Purchasing (MM-PUR) tables for Alteryx users.  In this blog we go a step further and present a set of predefined workflows for you to use with Alteryx and the DVW Alteryx Connector for SAP.

The list of workflows will be updated from time to time as new workflows become available.

[Last Update: February 27, 2020]

Table Extract Workflows

These table extract workflows use the SAP Table Data tool.

• Extract Purchase Order data
• Extract Contract data
• Extract Scheduling Agreement data
• Extract Request for Quotation (RFQ) data
• Extract Invoice Receipt data

T-Code Extract Workflows

These Transaction  Code (T-Code) workflows use the SAP Report tool.

• Material Analysis (T-Code MCE7)
• Material Group Analysis (T-Code MCE5)
• Purchasing Group Analysis (T-Code MCE1)
• Service Analysis (T-Code MCE8)
• Vendor Analysis (T-Code MCE3)
• Vendor Evaluation Analysis (T-Code ME6H)

Table Extract Workflows

Extract Purchase Order data

Extract Purchase Order data from the Purchasing Document tables EKKO (Purchasing Document Header) and EKPO (Purchasing Document Item).

​Works with: SAP ECC, SAP S/4HANA​

DOWNLOAD THE WORKFLOW

Extract Contract data

Extract Contract data from the Purchasing Document tables EKKO (Purchasing Document Header) and EKPO (Purchasing Document Item).

​Works with: SAP ECC, SAP S/4HANA​

DOWNLOAD THE WORKFLOW

Extract Scheduling Agreement data

Extract Scheduling Agreement data from the Purchasing Document tables EKKO (Purchasing Document Header) and EKPO (Purchasing Document Item).

​Works with: SAP ECC, SAP S/4HANA​

DOWNLOAD THE WORKFLOW

Extract Request for Quotation (RFQ) data

Extract Request for Quotation (RFQ) data from the Purchasing Document tables EKKO (Purchasing Document Header) and EKPO (Purchasing Document Item).

Works with: SAP ECC, SAP S/4HANA​

DOWNLOAD THE WORKFLOW

Extract Invoice Receipt data

Extract Invoice Receipt data from the RBKP (Document Header: Invoice Receipt) and RSEG (Document Item: Incoming Invoice) tables.

Works with: SAP ECC, SAP S/4HANA​

DOWNLOAD THE WORKFLOW

T-Code Extract Workflows

Material Analysis (T-Code MCE7)

The Material Analysis transaction provides answers to questions such as: What is the total value of Purchase Orders for a given Material?  

​Works with: SAP ECC, SAP S/4HANA​

DOWNLOAD THE WORKFLOW

Material Group Analysis (T-Code MCE5)

The Material Group Analysis transaction addresses questions such as: What is the total order quantity of Purchase Orders for a given Material Group?  ​

Works with: SAP ECC, SAP S/4HANA​

DOWNLOAD THE WORKFLOW

Purchasing Group Analysis (T-Code MCE1)

The Purchasing Group Analysis transaction provides answers to questions such as: How many Purchase Orders were created for a given Purchasing Group?  ​

Works with: SAP ECC, SAP S/4HANA​

DOWNLOAD THE WORKFLOW

Service Analysis (T-Code MCE8)

The Service Analysis transaction provides answers to questions such as: What is the total value of Services purchased over a specified period of time?

Works with: SAP ECC, SAP S/4HANA​

DOWNLOAD THE WORKFLOW

Vendor Analysis (T-Code MCE3)

The Vendor Analysis transaction provides answers to questions such as: What is the total quantity of goods and services purchased from a given Vendor?

Works with: SAP ECC, SAP S/4HANA​

DOWNLOAD THE WORKFLOW

Vendor Evaluation Analysis (T-Code ME6H)

The Vendor Evaluation Analysis transaction allows you to perform a range of analyses such as whether Vendors deliver the correct materials on time.

Works with: SAP ECC, SAP S/4HANA​

DOWNLOAD THE WORKFLOW

​Can't see what you are looking for here? If you would like us to define a sample workflow for a specific use case, please contact us with a brief summary of your use case.

---

GET A FREE TRIAL TODAY