DVW Analytics
  • PRODUCTS
    • ALTERYX CONNECTORS >
      • ALTERYX CONNECTOR FOR SAP
      • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
      • ALTERYX CONNECTOR FOR SUCCESSFACTORS
      • SAP METADATA CONNECTOR FOR ALTERYX CONNECT
    • KNIME CONNECTORS >
      • KNIME CONNECTOR FOR SAP
    • POWER BI CONNECTORS >
      • POWER BI CONNECTOR FOR SAP
    • TABLEAU CONNECTORS >
      • TABLEAU CONNECTOR FOR SAP
  • SERVICES
    • PROFESSIONAL SERVICES
    • TRAINING
  • DEMOS
  • FREE TRIAL
  • PRICING
  • RESOURCES
    • WEBINARS >
      • ON-DEMAND WEBINAR: SAP IN ALTERYX DESIGNER AND SERVER 101 - LEARN HOW TO ACCESS YOUR DATA LIKE A PRO
      • ON-DEMAND WEBINAR: ANALYSE + AUTOMATE YOUR SAP DATA WITH COCA-COLA EUROPEAN PARTNERS
      • ON-DEMAND WEBINAR: ANALYSE + AUTOMATE YOUR SAP DATA FULL DEMO
      • ON-DEMAND WEBINAR: DETAILED WALKTHROUGH OF THE ALTERYX CONNECTOR FOR SAP
      • ON-DEMAND WEBINAR: WHAT'S NEW WITH THE ALTERYX CONNECTOR FOR SAP
      • ON-DEMAND WEBINAR: AN INTRODUCTION TO SAP FOR ALTERYX USERS
      • ON-DEMAND WEBINAR: AN INTRODUCTION TO SAP DATA PREP & ANALYTICS WITH ALTERYX
      • ON-DEMAND WEBINAR: ALTERYX AND THE ALTERYX CONNECTOR FOR SAP
    • EVENTS >
      • BEER AND ANALYTICS 2020
      • BI INNOVATION & TECH FEST 2020
      • ALTERYX INSPIRE 2019
      • ALTERYX INSPIRE EUROPE 2019
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
    • GETTING STARTED
    • INSTALLATION GUIDES
    • SOFTWARE DOWNLOADS
    • TUTORIALS
    • SAMPLE WORKFLOWS
  • BLOG
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS

SAMPLE WORKFLOWS

​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.
Sample workflows are available for download on Alteryx Gallery and are listed with direct links below:
  • How Tos
  • Sample SAP ECC & SAP S/4HANA Workflows
  • Use Cases
 

How Tos 

Picture
How To Extract a Delta Load from an SAP BW Query
​​This workflow provides a template to enable the extract of a Delta load from an SAP BW Query.
  • Works with: SAP BW​
  • SAP Read Tools used:  SAP BW Read tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
How To Use the SAP Table Data tool
​​The SAP Table Data tool is used to extract data from SAP Tables, SAP Views and SAP S/4HANA CDS Views. This workflow shows some of the features of the SAP Table Data tool including field selection, application of filters and the use of splits to optimize workflow performance.
  • Works with: SAP ECC, SAP S/4HANA​
  • SAP Read Tools used:  SAP Table Data tool
  • ​SAP Write Tools used: N/A
Download the workflow
 

Sample SAP ECC & SAP S/4HANA Workflows

SAP Accounting

General

Picture
Extract Attachments for Finance documents
The SAP Document Read tool can extract attachments in any of the SAP supported MIME type formats including texts, images, audio, video and applications including PDF, MS Word, MS Excel, MS Powerpoint etc. This workflow provides a template to enable the extract of attachments for Finance documents stored in SAP ECC & SAP S/4HANA systems.
  • Works with: SAP ECC, SAP S/4HANA​
  • SAP Read Tools used:  SAP Table Data tool & SAP Document Read tool
  • SAP Write Tools used: N/A
​​Download the workflow

SAP Financial Accounting

General Ledger

Picture
Extract G/L Accounting Data (Table Extract)​
This workflow demonstrates how to extract General Ledger Accounting data from the "Big Two" SAP Financial Accounting (FI) Transaction Data Tables: BKPF (Accounting Document Header) and BSEG (Accounting Document Segment).​​​​
  • Works with: SAP ECC, SAP S/4HANA​
  • SAP Read Tools used:  SAP Table Data tool
  • SAP Write Tools used: N/A
​​Download the workflow
Picture
Extract Sales & Purchasing Tax Data (Table Extract)​
This workflow demonstrates how to extract Sales & Purchasing Tax data from the BKPF (Accounting Document Header) and BSET (Tax Document Segment) tables.
  • Works with: SAP ECC, SAP S/4HANA​
  • SAP Read Tools used:  SAP Table Data tool
  • SAP Write Tools used: N/A
​​Download the workflow
Picture
G/L Account Line Item Display (T-code FBL3N)​
SAP T-Code FBL3N (G/L Account Line Item Display) provides a list of G/L Account Line Items based on the entered selection critria.​​​​
This workflow demonstrates how to extract G/L Account Line Item data directly from the G/L Account Line Item Display transaction (T-Code FBL3N) into Alteryx.
  • Works with: SAP ECC, SAP S/4HANA​
  • SAP Read Tools used:  SAP Report tool
  • SAP Write Tools used: N/A
​​Download the workflow
Picture
G/L Document List (T-code FB03)​
SAP T-Code FB03 (Document List) provides a list of posted FI documents based on the entered selection critria.​
This workflow demonstrates how to extract G/L Document List data directly from the G/L Document List transaction (T-Code FB03) into Alteryx.
  • Works with: SAP ECC, SAP S/4HANA​
  • SAP Read Tools used:  SAP Report tool
  • SAP Write Tools used: N/A
​​Download the workflow

Accounts Payable

Picture
Vendor Line Item Display (T-code FBL1N)​
​​​​This workflow demonstrates how to extract Vendor Line Item data directly from the Vendor Line Item Display transaction (T-Code FBL1N) into Alteryx.
  • Works with: SAP ECC, SAP S/4HANA​
  • SAP Read Tools used:  SAP Report tool
  • SAP Write Tools used: N/A
​​Download the workflow

Accounts Receivable

Picture
Customer Line Item Display (T-code FBL5N)
​​This workflow demonstrates how to extract Customer Line Item data directly from the Customer Line Item Display transaction (T-Code FBL5N) into Alteryx.
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP Report tool
  • SAP Write Tools used: N/A
Download the workflow

SAP Controlling

Cost Center Accounting

Picture
Cost Centers: Change Cost Center (BAPI_COSTCENTER_CHANGEMULTIPLE)
​This workflow demonstrates how to change Cost Center data in an SAP ECC or SAP S/4HANA system from Alteryx. Using BAPI_COSTCENTER_CHANGEMULTIPLE is the BAPI equivalent of using T-Code KS02 (Individual Processing: Change Cost Center) or KS12N (Collective Processing: Change Cost Center).
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP BAPI Read tool & SAP BAPI Parse tool
  • SAP Write Tools used: SAP BAPI Write tool
Download the workflow
Picture
Cost Centers: Actual Line Items (T-Code KSB1)
​This workflow demonstrates how to extract data direcly from the Cost Centers: Actual Line Items transaction (T-Code KSB1) into Alteryx.
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP Report tool
  • SAP Write Tools used: N/A
Download the workflow

SAP Logistics

General

Picture
Extract Attachments for Plant Maintenance and Customer Service documents
The SAP Document Read tool can extract attachments in any of the SAP supported MIME type formats including texts, images, audio, video and applications including PDF, MS Word, MS Excel, MS Powerpoint etc. This workflow provides a template to enable the extract of attachments for Plant Maintenance and Customer Service documents stored in SAP ECC & SAP S/4HANA systems. For example you can extract the attachments for Plant Maintenance Notifications (IW21 / IW22 / IW23), Plant Maintenance Orders / Service Orders (IW31 / IW32 / IW33), Service Notifications (IW51 / IW52 / IW53), Functional Locations (IL01 / IL02 / IL03), Equipment (IE01 / IE02 / IE03) and so on.
  • Works with: SAP ECC, SAP S/4HANA​
  • SAP Read Tools used:  SAP Table Data tool & SAP Document Read tool
  • SAP Write Tools used: N/A
​​Download the workflow

SAP Materials Management

Purchasing

Picture
Extract Purchase Order Data (Table Extract)​
This workflow demonstrates how to extract Purchasing Order data from Purchasing Document tables EKKO (Purchasing Document Header) and EKPO (Purchasing Document Item).
  • Works with: SAP ECC, SAP S/4HANA​
  • SAP Read Tools used:  SAP Table Data tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
Extract Purchase Order Items (BAPI_PO_GETITEMS)
​This workflow demonstrates how to extract Purchase Order items from an SAP ECC or SAP S/4HANA using BAPI_PO_GETITEMS.
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP BAPI Read tool & SAP BAPI Parse tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
Extract Purchase Requisition Items (BAPI_REQUISITION_GETITEMS)
​This workflow demonstrates how to extract Purchase Requisition items from an SAP ECC or SAP S/4HANA using BAPI_REQUISITION_GETITEMS.
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP BAPI Read tool & SAP BAPI Parse tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
Extract Purchase Information Records (BAPI_INFORECORD_GETLIST)
​This workflow demonstrates how to extract Purchase Information Record data from an SAP ECC or SAP S/4HANA using BAPI_INFORECORD_GETLIST.
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP BAPI Read tool & SAP BAPI Parse tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
Extract Contract Data (Table Extract)​
This workflow demonstrates how to extract Contract data from Purchasing Document tables EKKO (Purchasing Document Header) and EKPO (Purchasing Document Item).
  • Works with: SAP ECC, SAP S/4HANA​
  • SAP Read Tools used:  SAP Table Data tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
Extract Scheduling Agreement Data (Table Extract)​
This workflow demonstrates how to extract Scheduling Agreement data from Purchasing Document tables EKKO (Purchasing Document Header) and EKPO (Purchasing Document Item).
  • Works with: SAP ECC, SAP S/4HANA​
  • SAP Read Tools used:  SAP Table Data tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
Extract Request for Quotation (RFQ) Data (Table Extract)​
This workflow demonstrates how to extract Request for Quotation data from Purchasing Document tables EKKO (Purchasing Document Header) and EKPO (Purchasing Document Item).
  • Works with: SAP ECC, SAP S/4HANA​
  • SAP Read Tools used:  SAP Table Data tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
Extract Invoice Receipt Data (Table Extract)​
This workflow demonstrates how to 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​
  • SAP Read Tools used:  SAP Table Data tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
Extract Purchasing Document Data (Table Extract)​
This workflow demonstrates how to extract Purchasing Document data (including Purchase Order, Contract, Scheduling Agreement & Request for Quotation) from Purchasing Document tables EKKO (Purchasing Document Header) and EKPO (Purchasing Document Item).
  • Works with: SAP ECC, SAP S/4HANA​
  • SAP Read Tools used:  SAP Table Data tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
Material Analysis (T-Code MCE7)
​This workflow demonstrates how to extract Material Analysis data directly from the Material Analysis transaction (T-Code MCE7) into Alteryx.
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP Report tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
Material Group Analysis (T-Code MCE5)
​This workflow demonstrates how to extract Material Group Analysis data directly from the Material Group Analysis transaction (T-Code MCE5) into Alteryx.
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP Report tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
Purchasing Group Analysis (T-Code MCE1)
​This workflow demonstrates how to extract Purchasing Group Analysis data directly from the Purchasing Group Analysis transaction (T-Code MCE1) into Alteryx.
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP Report tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
Service Analysis (T-Code MCE8)
​This workflow demonstrates how to extract Service Analysis data directly from the Service Analysis transaction (T-Code MCE8) into Alteryx.
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP Report tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
Vendor Analysis (T-Code MCE3)
​This workflow demonstrates how to extract Vendor Analysis data directly from the Vendor Analysis transaction (T-Code MCE3) into Alteryx.
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP Report tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
Vendor Evaluation Analysis (T-Code ME6H)
​This workflow demonstrates how to extract Vendor Evaluation Analysis data directly from the Vendor Evaluation Analysis transaction (T-Code ME6H) into Alteryx.
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP Report tool
  • SAP Write Tools used: N/A
Download the workflow

Inventory Management

Picture
Material Document List (T-Code MB51)
​This workflow demonstrates how to extract Material Document List data directly from the Material Document List transaction (T-Code MB51) into Alteryx.
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP Report tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
Post Goods Receipt (BAPI_GOODSMVT_CREATE)
​This workflow demonstrates how to post a Goods Receipt in an SAP ECC or SAP S/4HANA system from Alteryx. Using BAPI_GOODSMVT_CREATE) is the BAPI equivalent of using T-Code MIGO (Goods Movement).
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP BAPI Read tool & SAP BAPI Parse tool
  • SAP Write Tools used: SAP BAPI Write tool
Download the workflow
Picture
Transfer Posting (BAPI_GOODSMVT_CREATE)
​This workflow demonstrates how to make a Transfer Posting in an SAP ECC or SAP S/4HANA system from Alteryx. Using BAPI_GOODSMVT_CREATE) is the BAPI equivalent of using T-Code MIGO (Goods Movement) & MIGO_TR (Transfer Posting).
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP BAPI Read tool & SAP BAPI Parse tool
  • SAP Write Tools used: SAP BAPI Write tool
Download the workflow

SAP Sales and Distribution

Master Data

Picture
Extract Pricing Condition Record Data from SAP ECC (Table Extract)
This workflow demonstrates how to extract SAP Pricing Condition Data from SAP ECC. Data is extracted from the Conditions Header table (KONH) and combined with data from the Condition Items table (KONP) to provide a consolidated output
  • ​Works with: SAP ECC
  • SAP Read Tools used: SAP Table Data tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
Extract Customer Material Information Records (BAPI_CUSTMATINFO_GETLIST)
​This workflow demonstrates how to extract Customer Material Information Record data from an SAP ECC or SAP S/4HANA using BAPI_CUSTMATINFO_GETLIST.
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP BAPI Read tool & SAP BAPI Parse tool
  • SAP Write Tools used: N/A
Download the workflow

Sales

Picture
List of Sales Orders (T-Code VA05)
​This workflow demonstrates how to extract data from the List of Sales Order transaction (T-Code VA05) into Alteryx.
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP Report tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
Create Sales Orders (BAPI_SALESORDER_CREATEFROMDAT2)
​This workflow demonstrates how to create Sales Orders in an SAP ECC or SAP S/4HANA system from Alteryx. Using BAPI_SALESORDER_CREATEFROMDAT2) is the BAPI equivalent of using T-Code VA01 (Sales Order Create).
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: N/A
  • SAP Write Tools used: SAP BAPI Write tool
Download the workflow
Picture
Create Sales Orders (BAPI_SALESORDER_SIMULATE)
​This workflow demonstrates how to simulate the creation of Sales Orders in an SAP ECC or SAP S/4HANA system from Alteryx. Using BAPI_SALESORDER_SIMULATE you can incorporate real-time pricing and material availability into an Alteryx workflow.
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP BAPI Read tool
  • SAP Write Tools used: N/A
Download the workflow

SAP Plant Maintenance

Management of Technical Objects

Picture
Display Functional Location List (T-Code IH06)
SAP T-Code IH06 (Display Functional Location List) provides a list of Functional Locations based on the entered selection criteria.​
​This workflow demonstrates how to extract data from the Display Functional Location List transaction (T-Code IH06) into Alteryx.
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP Report tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
Display Equipment List (T-Code IH08)
SAP T-Code IH08 (Display Equipment List) provides a list of Equipment based on the entered selection criteria.​
​This workflow demonstrates how to extract data from the Display Equipment List transaction (T-Code IH08) into Alteryx.
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP Report tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
Display Serial Number List (T-Code IQ09)
SAP T-Code IQ09 (Display Serial Number List) provides a list of Serial Numbers based on the entered selection criteria.​
​This workflow demonstrates how to extract data from the Display Serial Number List transaction (T-Code IQ09) into Alteryx.
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP Report tool
  • SAP Write Tools used: N/A
Download the workflow
 

Use Cases

Picture
Identify Inactive Customers in SAP (Table Extract)
This workflow demonstrates how to identify inactive customers in SAP
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP Table Data tool
  • SAP Write Tools used: N/A
Download the workflow
Picture
SAP Vendor Payment Payment Terms Review (Table Extract)
This workflow addresses the following questions related to SAP Vendor Payment Terms:
1. Which Vendors have no Payment Terms?
2. What Payment Terms are actually being used?
3. What Payment Terms have duplicate conditions (terms)?
4. Which of our Payment Terms don't make any sense?
  • ​Works with: SAP ECC, SAP S/4HANA
  • SAP Read Tools used: SAP Table Data tool
  • SAP Write Tools used: N/A
Download the workflow

PRODUCTS

ALTERYX CONNECTOR FOR SAP​
​
ALTERYX CONNECTOR FOR BUSINESSOBJECTS
​ALTERYX CONNECTOR FOR SUCCESSFACTORS
SAP METADATA CONNECTOR FOR ALTERYX CONNECT​
​KNIME CONNECTOR FOR SAP

POWER BI CONNECTOR FOR SAP
TABLEAU CONNECTOR FOR SAP

SERVICES

PROFESSIONAL SERVICES
TRAINING

DEMOS

FREE TRIAL

FREE TRIAL OF ALTERYX CONNECTOR FOR SAP
FREE TRIAL OF ALTERYX CONNECTOR FOR BUSINESSOBJECTS
FREE TRIAL OF ALTERYX CONNECTOR FOR SUCCESSFACTORS
​FREE TRIAL OF KNIME CONNECTOR FOR SAP
​
​FREE TRIAL OF POWER BI CONNECTOR FOR SAP
​​
​FREE TRIAL OF TABLEAU CONNECTOR FOR SAP

PRICING

BLOG

ABOUT US

CONTACT US

DVW Analytics, from De Villiers Walton, is dedicated to bringing the power of SAP to users of Alteryx, KNIME, Power BI, Tableau & other global leaders in BI and analytics.

© COPYRIGHT 2003 - 2021 DE VILLIERS WALTON LIMITED. ALL RIGHTS RESERVED.

SAP® Business Suite, SAP® BusinessObjects™, SAP® BW, SAP® SuccessFactors are the trademarks or registered trademarks of SAP SE in Germany and in several other countries.
PRIVACY POLICY
  • PRODUCTS
    • ALTERYX CONNECTORS >
      • ALTERYX CONNECTOR FOR SAP
      • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
      • ALTERYX CONNECTOR FOR SUCCESSFACTORS
      • SAP METADATA CONNECTOR FOR ALTERYX CONNECT
    • KNIME CONNECTORS >
      • KNIME CONNECTOR FOR SAP
    • POWER BI CONNECTORS >
      • POWER BI CONNECTOR FOR SAP
    • TABLEAU CONNECTORS >
      • TABLEAU CONNECTOR FOR SAP
  • SERVICES
    • PROFESSIONAL SERVICES
    • TRAINING
  • DEMOS
  • FREE TRIAL
  • PRICING
  • RESOURCES
    • WEBINARS >
      • ON-DEMAND WEBINAR: SAP IN ALTERYX DESIGNER AND SERVER 101 - LEARN HOW TO ACCESS YOUR DATA LIKE A PRO
      • ON-DEMAND WEBINAR: ANALYSE + AUTOMATE YOUR SAP DATA WITH COCA-COLA EUROPEAN PARTNERS
      • ON-DEMAND WEBINAR: ANALYSE + AUTOMATE YOUR SAP DATA FULL DEMO
      • ON-DEMAND WEBINAR: DETAILED WALKTHROUGH OF THE ALTERYX CONNECTOR FOR SAP
      • ON-DEMAND WEBINAR: WHAT'S NEW WITH THE ALTERYX CONNECTOR FOR SAP
      • ON-DEMAND WEBINAR: AN INTRODUCTION TO SAP FOR ALTERYX USERS
      • ON-DEMAND WEBINAR: AN INTRODUCTION TO SAP DATA PREP & ANALYTICS WITH ALTERYX
      • ON-DEMAND WEBINAR: ALTERYX AND THE ALTERYX CONNECTOR FOR SAP
    • EVENTS >
      • BEER AND ANALYTICS 2020
      • BI INNOVATION & TECH FEST 2020
      • ALTERYX INSPIRE 2019
      • ALTERYX INSPIRE EUROPE 2019
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
    • GETTING STARTED
    • INSTALLATION GUIDES
    • SOFTWARE DOWNLOADS
    • TUTORIALS
    • SAMPLE WORKFLOWS
  • BLOG
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS