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

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