Products

Solutions

Pricing

Free Trial

Blog

Demos & Recordings

Webinars

Events

Contact Us

DVW Analytics
  • Products
    • DVW Connectors for SAP >
      • DVW Alteryx Connector for SAP
      • DVW KNIME Connector for SAP
      • DVW Dataiku Connector for SAP
    • DVW Flow Tool >
      • DVW Flow Tool
      • DVW Employee Master Data Migration for SAP Solutions
    • DVW RPA Tools for SAP >
      • DVW Alteryx RPA Tools for SAP
      • DVW KNIME RPA Tools for SAP
      • DVW Flow Tool RPA Tools for SAP
  • Solutions
    • SAP Analytics
    • SAP Data Migration
    • SAP Process Automation
    • SAP Data for AI and Machine Learning
  • Pricing
    • DVW Connectors for SAP >
      • DVW Alteryx Connector for SAP Pricing
      • DVW KNIME Connector for SAP Pricing
      • DVW Dataiku Connector for SAP Pricing
    • DVW Flow Tool >
      • DVW Flow Tool Pricing
    • DVW RPA Tools for SAP >
      • DVW RPA Tools Pricing
  • Free Trial
  • Resources
    • About Us
    • Customers
    • Partners
    • Resellers
    • Services
    • Help Centre
    • Sample Workflows
    • License
  • Insights
    • Blog
    • SAP Data Models >
      • SAP FI/CO Table Relationships - Interactive Data Model Diagram
      • SAP SD Table Relationships - Interactive Data Model Diagram
      • SAP Inventory Management Table Relationships - Interactive Data Model Diagram
      • SAP Purchasing Table Relationships - Interactive Data Model Diagram
      • SAP PP Table Relationships - Interactive Data Model Diagram
      • SAP QM Table Relationships - Interactive Data Model Diagram
      • SAP PM Table Relationships - Interactive Data Model Diagram
      • SAP WM Table Relationships - Interactive Data Model Diagram
      • SAP HCM Table Relationships - Interactive Data Model Diagram
      • SAP PS Table Relationships - Interactive Data Model Diagram
    • Demos & Recordings >
      • DVW Connectors for SAP >
        • DVW Alteryx Connector for SAP Demos
        • DVW KNIME Connector for SAP Demos
        • DVW Dataiku Connector for SAP Demos
      • DVW Flow Tool >
        • DVW Flow Tool Demos
      • DVW RPA Tools for SAP >
        • DVW RPA Tools for SAP Demos
    • Webinars
    • Events
  • Contact Us

Blog

Using the most commonly used SAP Transactions (T-Codes) with Alteryx

27/1/2023

 
Picture
In this blog we present a list of the most commonly used SAP Transactions (T-Codes) and the DVW ACS tools that can be used to either read (extract) data from them or write (load / create / update) data  to them.

​The list of T-Codes was compiled based on a combination of web search and personal experience. So, if there's a particular T-Code that is used extensively within your company and is not on this list, let us know and we will update the blog with details.
The primary DVW ACS tools referenced in the list are: 
  • SAP Report Tool
  • SAP Table Data Tool
  • SAP Query Tool
  • SAP BAPI Read Tool
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
Finally, before we get into the list, links are being added to relevant additional content and sample workflows. This will take some time to complete, so please keep checking back.

The most commonly used SAP Transactions (T-Codes)

The list is organised by SAP functional area. 
  • Logistics
  • Accounting
  • Human Resources
 

Logistics

Logistics > Materials Management (MM)

Material Master (LO-MD-MM)

T-Code
T-Code Name
​DVW ACS Tools
MM01
Create Material
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
MM02
Change Material
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
MM03
Display Material
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool

Customer Master Data (LO-MD-BP-CM)

T-Code
T-Code Name
​DVW ACS Tools
XD01
Create Customer
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
XD02
Change Customer
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
XD03
Display Customer
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool

Vendor Master Data (LO-MD-BP-VM)

T-Code
T-Code Name
​DVW ACS Tools
FK03
Display Vendor Accounting
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool
XK01
Create Vendor
  • SAP IDoc Write Tool
  • SAP RPA Tool
XK02
Change Vendor
  • SAP IDoc Write Tool
  • SAP RPA Tool
XK03
Display Vendor
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool

Material Bill of Material (LO-MD-BOM)

T-Code
T-Code Name
​DVW ACS Tools
CS01
Create Bill of Material
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
CS02
Change Bill of Material
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
CS03
Display Bill of Material
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool

Purchasing (MM-PUR)

T-Code
T-Code Name
​DVW ACS Tools
ME2L
List Purchase Order by Vendor
  • SAP Report Tool
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool
  • SAP RPA Tool
ME21N
Create Purchase Order
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
ME22N
Change Purchase Order
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
ME23N
Display Purchase Order
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool​

Inventory Management (MM-IM)

T-Code
T-Code Name
​DVW ACS Tools
MB51
Material Document List
  • SAP Report Tool
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool
MB52
List of Warehouse Stocks on Hand
  • SAP Report Tool 
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool
  • SAP RPA Tool
MD04
Stock/Requirements List
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool​
  • SAP RPA Tool
MIGO
Goods Movement
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • ​SAP RPA Tool

Logistics Invoice Verification (MM-IV)

T-Code
T-Code Name
​DVW ACS Tools
MIR4
Display Invoice Document
  • SAP Table Data Tool 
  • SAP Query Tool  
  • SAP BAPI Read Tool
MIRO
Enter Invoice
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • ​SAP RPA Tool

Logistics > Sales and Distribution (SD)

Sales (SD-SLS)

T-Code
T-Code Name
​DVW ACS Tools
VA01
Create Sales Order
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
VA02
Change Sales Order
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
VA03
Display Sales Order
  • SAP Report Tool
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool

Billing (SD-BIL)

T-Code
T-Code Name
​DVW ACS Tools
VF01
Create Billing Document 
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
VF02
Change Billing Document 
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
VF03
Display Billing Document 
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool

Condition Records (SD-MD-CM)

T-Code
T-Code Name
​DVW ACS Tools
VK11
Create Condition Records 
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
VK12
Change Condition Records
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
VK13
Display Condition Records
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool

Logistics > Production (PP)

Routing (PP-BD-RTG)

T-Code
T-Code Name
​DVW ACS Tools
CA01
Create Routing 
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
CA02
Change Routing 
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
CA03
Display Routing 
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool

Logistics > Plant Maintenance (PM)

Mangement of Technical Objects (PM-EQM-EQ)

T-Code
T-Code Name
​DVW ACS Tools
IE01
Create Equipment 
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
IE02
Change Equipment
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
IE03
Display Equipment
  • SAP Report Tool
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool
IL01
Create Functional Location
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
IL02
Change Functional Location
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
IL03
Display Functional Location
  • SAP Report Tool
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool

Maintenance Processing (PM-WOC-MO)

T-Code
T-Code Name
​DVW ACS Tools
IW31
Create Order
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
IW32
Change Order
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
IW33
Display Order
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool

Preventive Maintenance (PM-PRM-TL)

T-Code
T-Code Name
​DVW ACS Tools
IA05
Create General Maintenance Task List
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
IP02
Change Maintenance Plan
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
IP10
Schedule Maintenance Plan
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool
 

Accounting

Accounting > Financial Accounting (FI)

General Ledger (FI)

T-Code
T-Code Name
​DVW ACS Tools
F-02
Enter G/L Account Posting 
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
F-03
Clear G/L Account
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
FB01
Post Document
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
FB02
Change Document
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
FB03
Display Document
  • SAP Report Tool 
  • ​SAP Table Data Tool 
  • SAP Query Tool
FB05
Post with Clearing
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
FB50
Enter G/L Account Document
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
FS10N
​G/L Account Balance Display
  • SAP Report Tool
  • ​SAP Table Data Tool 
  • SAP Query Tool
FBL1N
Vendor Line Items
  • SAP Report Tool 
  • ​SAP Table Data Tool 
  • SAP Query Tool
  • SAP RPA Tool
FBL3N
​G/L Account Line Items
  • SAP Report Tool 
  • ​SAP Table Data Tool 
  • SAP Query Tool
  • SAP RPA Tool
FBL5N
Customer Line Items
  • SAP Report Tool 
  • ​SAP Table Data Tool 
  • SAP Query Tool
  • SAP RPA Tool

Accounts Receivable (FI)

T-Code
T-Code Name
​DVW ACS Tools
FB70
Enter Customer Invoice
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool

Accounts Payable (FI)

T-Code
T-Code Name
​DVW ACS Tools
F-44
Clear Vendor
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
FB60
Enter Vendor Invoice
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
FD32
Customer Credit Management Change
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool

Fixed Assets (FI-AA-AA)

T-Code
T-Code Name
​DVW ACS Tools
AS01
Create Asset 
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
AS02
Change Asset
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
AS03
Display Asset
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool

Accounting > Controlling (CO)

Cost Center Accounting (CO-OM)

T-Code
T-Code Name
​DVW ACS Tools
KS01
Create Cost Center 
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
KS02
Change Cost Center
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
KSB1
Cost Centers: Actual Line Items
  • SAP Report Tool
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool
  • SAP RPA Tool

Internal Orders (CO-OM-PA)

T-Code
T-Code Name
​DVW ACS Tools
KO01
Create Internal Order
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
KO02
Change Internal Order
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
KO03
Display Internal Order
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool
 

Human Resources

Human Resources > Personnel Management (PA-PA)

T-Code
T-Code Name
​DVW ACS Tools
PA20
Display Personnel Master Data
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool
PA30
Maintain Personnel Master Data
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
PA40
Personnel Actions 
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
  • SAP RPA Tool
GET A FREE TRIAL TODAY

Comments are closed.

    RSS Feed

    Categories

    All
    AI & Machine Learning
    Alteryx Connector
    Audit
    Dataiku Connector
    Data Migration
    Flow Tool
    KNIME Connector
    Process Automation
    Product Updates
    Reporting & Analytics
    RPA Tools For SAP
    SAP Data Extraction
    SAP S/4HANA
    SAP Tables
    Use Cases
    Webinar

    Archives

    April 2026
    March 2026
    February 2026
    December 2025
    November 2025
    October 2025
    August 2025
    July 2025
    October 2024
    September 2024
    July 2024
    June 2024
    February 2024
    October 2023
    June 2023
    May 2023
    March 2023
    February 2023
    January 2023
    June 2022
    March 2022
    February 2022
    December 2021
    November 2021
    October 2021
    May 2021
    April 2021
    December 2020
    October 2020
    June 2020
    February 2020
    September 2019
    June 2019
    August 2018
    June 2018

Products​
​SAP Connectors
DVW Alteryx Connector for SAP
DVW KNIME Connector for SAP
​DVW Dataiku Connector for SAP

DVW Flow Tool
DVW Flow Tool

RPA Tools for SAP
DVW Alteryx RPA Tools for SAP
DVW KNIME RPA Tools for SAP
DVW Flow Tool RPA Tools for SAP
Resources & Insights
Blog
Webinars
Watch Demos
Events
Solutions
SAP Analytics
SAP Data Migration
SAP Process Automation
SAP Data for AI and ML
Company
About Us
Contact Us
Pricing
Free Trial

[email protected]
Get started
​Start Free Trial
View Pricing
Book a Demo
DVW Analytics gives business users and technical teams direct read and write access to SAP data from Alteryx, KNIME, Dataiku, Power BI, Databricks, Snowflake, and more. Trusted by 500+ organisations worldwide.
© COPYRIGHT 2003 - 2026 DE VILLIERS WALTON LIMITED. ALL RIGHTS RESERVED.
Privacy Policy
Cookie Policy
De Villiers Walton Limited. Registered in England and Wales. Company No. 04638006. VAT No. GB 807714429. Registered Office:  Ground Floor Marlborough House, 298 Regents Park Road, London, N3 2SZ, United Kingdom

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.
  • Products
    • DVW Connectors for SAP >
      • DVW Alteryx Connector for SAP
      • DVW KNIME Connector for SAP
      • DVW Dataiku Connector for SAP
    • DVW Flow Tool >
      • DVW Flow Tool
      • DVW Employee Master Data Migration for SAP Solutions
    • DVW RPA Tools for SAP >
      • DVW Alteryx RPA Tools for SAP
      • DVW KNIME RPA Tools for SAP
      • DVW Flow Tool RPA Tools for SAP
  • Solutions
    • SAP Analytics
    • SAP Data Migration
    • SAP Process Automation
    • SAP Data for AI and Machine Learning
  • Pricing
    • DVW Connectors for SAP >
      • DVW Alteryx Connector for SAP Pricing
      • DVW KNIME Connector for SAP Pricing
      • DVW Dataiku Connector for SAP Pricing
    • DVW Flow Tool >
      • DVW Flow Tool Pricing
    • DVW RPA Tools for SAP >
      • DVW RPA Tools Pricing
  • Free Trial
  • Resources
    • About Us
    • Customers
    • Partners
    • Resellers
    • Services
    • Help Centre
    • Sample Workflows
    • License
  • Insights
    • Blog
    • SAP Data Models >
      • SAP FI/CO Table Relationships - Interactive Data Model Diagram
      • SAP SD Table Relationships - Interactive Data Model Diagram
      • SAP Inventory Management Table Relationships - Interactive Data Model Diagram
      • SAP Purchasing Table Relationships - Interactive Data Model Diagram
      • SAP PP Table Relationships - Interactive Data Model Diagram
      • SAP QM Table Relationships - Interactive Data Model Diagram
      • SAP PM Table Relationships - Interactive Data Model Diagram
      • SAP WM Table Relationships - Interactive Data Model Diagram
      • SAP HCM Table Relationships - Interactive Data Model Diagram
      • SAP PS Table Relationships - Interactive Data Model Diagram
    • Demos & Recordings >
      • DVW Connectors for SAP >
        • DVW Alteryx Connector for SAP Demos
        • DVW KNIME Connector for SAP Demos
        • DVW Dataiku Connector for SAP Demos
      • DVW Flow Tool >
        • DVW Flow Tool Demos
      • DVW RPA Tools for SAP >
        • DVW RPA Tools for SAP Demos
    • Webinars
    • Events
  • Contact Us