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

BLOG

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

16/7/2020

 
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
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
MM02
Change Material
  • SAP BAPI Write Tool
  • SAP IDoc Write 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
XD02
Change Customer
  • SAP BAPI Write Tool
  • SAP IDoc Write 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
XK02
Change Vendor
  • SAP IDoc Write 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
CS02
Change Bill of Material
  • SAP BAPI Write Tool
  • SAP IDoc Write 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
ME21N
Create Purchase Order
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
ME22N
Change  Purchase Order
  • SAP BAPI Write Tool
  • SAP IDoc Write 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
MD04
Stock/Requirements List
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read Tool​l
MIGO
Goods Movement
  • SAP BAPI Write Tool
  • SAP IDoc Write 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

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
VA02
Change Sales Order
  • SAP BAPI Write Tool
  • SAP IDoc Write 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
VF02
Change Billing Document 
  • SAP BAPI Write Tool
  • SAP IDoc Write 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
VK12
Change Condition Records
  • SAP BAPI Write Tool
  • SAP IDoc Write 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
CA02
Change Routing 
  • SAP BAPI Write Tool
  • SAP IDoc Write 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
IE02
Change Equipment
  • SAP BAPI Write Tool
  • SAP IDoc Write 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
IL02
Change Functional Location
  • SAP BAPI Write Tool
  • SAP IDoc Write 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
IW32
Change Order
  • SAP BAPI Write Tool
  • SAP IDoc Write 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
IP02
Change Maintenance Plan
  • SAP BAPI Write Tool
  • SAP IDoc Write 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
F-03
Clear G/L Account
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
FB01
Post Document
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
FB02
Change Document
  • SAP BAPI Write Tool
  • SAP IDoc Write 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
FB50
Enter G/L Account Document
  • SAP BAPI Write Tool
  • SAP IDoc Write 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
FBL3N
​G/L Account Line Items
  • SAP Report Tool 
  • ​SAP Table Data Tool 
  • SAP Query Tool
FBL5N
Customer Line Items
  • SAP Report Tool 
  • ​SAP Table Data Tool 
  • SAP Query Tool

Accounts Receivable (FI)

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

Accounts Payable (FI)

T-Code
T-Code Name
​DVW ACS Tools
F-44
Clear Vendor
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
FB60
Enter Vendor Invoice
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
FD32
Customer Credit Management Change
  • SAP BAPI Write Tool
  • SAP IDoc Write 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
AS02
Change Asset
  • SAP BAPI Write Tool
  • SAP IDoc Write 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
KS02
Change Cost Center
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
KSB1
Cost Centers: Actual Line Items
  • SAP Report Tool
  • SAP Table Data Tool
  • SAP Query Tool 
  • SAP BAPI Read 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
KO02
Change Internal Order
  • SAP BAPI Write Tool
  • SAP IDoc Write 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
PA40
Personnel Actions 
  • SAP BAPI Write Tool
  • SAP IDoc Write Tool
GET A FREE TRIAL TODAY

Comments are closed.

    RSS Feed

    Categories

    All
    ACS
    ACS BusinessObjects
    ACS BW Write
    ACS Cloud
    ACS Metadata
    Alteryx
    Alteryx Gallery
    Alteryx Server
    Analytic Process Automation
    APA
    Audit
    BusinessObjects
    Consulting
    DVW Integration Platform
    DVW IP
    Inspire
    Jobs
    KCS
    KNIME
    Microsoft Azure
    Microsoft Power BI
    Office Of Finance
    Predictive Analytics
    Qlik
    Salesforce
    Salesforce Wave Analytics
    SAP BAPI Read Tool
    SAP BAPI Write Tool
    SAP BusinessObjects
    SAP Business Suite
    SAP BW
    SAP Data Migration
    SAP Document Tool
    SAP ECC
    SAP ERP
    SAP HANA
    SAP IDoc Tool
    SAP Query Tool
    SAP Read Tools
    SAP Report Tool
    SAP S/4HANA
    SAP Table Data Tool
    SAP Tables
    SAP Transaction Codes
    SAP Write Tools
    Services
    Tableau
    Tax
    TCS
    ThoughtSpot
    Top 10 Blog
    Training
    Webinar

    Archives

    December 2020
    November 2020
    October 2020
    July 2020
    June 2020
    May 2020
    February 2020
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    September 2018
    August 2018
    June 2018
    May 2018
    April 2018
    February 2018
    July 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    November 2015

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