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
|
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.
|
|
|
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.
|
Sample SAP ECC & SAP S/4HANA Workflows
SAP Accounting
General
|
|
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.
|
SAP Financial Accounting
General Ledger
|
|
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).
|
|
|
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.
|
|
|
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.
|
|
|
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.
|
Accounts Payable
|
|
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.
|
Accounts Receivable
|
|
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.
|
SAP Controlling
Cost Center Accounting
|
|
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).
|
|
|
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.
|
SAP Logistics
General
|
|
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.
|
SAP Materials Management
Purchasing
|
|
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).
|
|
|
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.
|
|
|
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.
|
|
|
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.
|
|
|
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).
|
|
|
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).
|
|
|
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).
|
|
|
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.
|
|
|
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).
|
|
|
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.
|
|
|
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.
|
|
|
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.
|
|
|
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.
|
|
|
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.
|
|
|
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.
|
Inventory Management
|
|
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.
|
|
|
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).
|
|
|
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).
|
SAP Sales and Distribution
Master Data
|
|
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
|
|
|
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.
|
Sales
|
|
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.
|
|
|
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).
|
|
|
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.
|
SAP Plant Maintenance
Management of Technical Objects
|
|
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.
|
|
|
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.
|
|
|
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.
|
Use Cases
|
|
Identify Inactive Customers in SAP (Table Extract)
This workflow demonstrates how to identify inactive customers in SAP
|
|
|
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?
|