Our customer service team was just asked if we had an SAP transaction codes reference list…hmmm, that made me think a little. I have been in the SAP world for over 20 years now and I admit, I didn’t really know how many SAP tcodes there are – but I knew there are A LOT of them. So I wanted to find out and share a list of SAP transaction codes in Excel with you.
What is an SAP Transaction Code?
To be clear: a transaction code in SAP is a shortcut to an activity (or transaction) that you can enter in the SAP command field. For example, transactionFB01lets you enter a financial posting in the SAP system. It used to be that they were a 4-digit alphanumerical code but not anymore. They can now have any length and include special characters, too (for example, transaction code/AFI/DIC_AP_DISPdisplays invoice statistics).
New SAP users typically use the menu path to navigate through the SAP system. However, the more experience people get, the more they start using transaction shortcuts instead. It is a much faster way to work with your most commonly used transactions.
Where do you find SAP Tcodes in the system?
By the way, you can actually buy books of all SAP transaction codes. It seems strange to me since you can generate a list of transaction codes yourself very easily. So safe yourself some money and follow my steps below.
All SAP t-codes are stored in 2 SAP database tables:
- Table TSTC (this table stores the transaction codes and other technical information such as program name, screen number, etc.)
- Table TSTCT (this table includes the transactioncodes and their description in all languages)
The second table, TSTCT, is most useful as it includes all SAP code and the description of what they actually do (and it includes all installed languages, too). So I downloaded the entire table to an Excel spreadsheet (only in English though). If you want to download this table for yourself in a different language you can easily do so by using transaction code SE16 and then entering table TSTCT.
Download all SAP Transactions
Before I downloaded the table I guessed that there must be 10s of 1000s ofcodes…maybe 50,000? Maybe 70,000? Well, it turns out I was way off – there are 100,000 t-codes in the SAP ECC 6 system! You can download the entire list here:SAP transaction codes
Now, granted, I don’t know how useful such a list really is – after all, it contains 100,000 records. I added filter criteria to each column – this lets you search the descriptions for a particular word, for example, I searched for the word ‘asset’ to find all (well, not all, but almost 500) codes related to Asset Accounting.
Anyway, go ahead and download the list of all SAP transaction codes and play around with it. And please let me know in the comments if you have any tips & tricks related to transaction codes.
And, as always, thank you for sharing this post!
Cheers,
Thomas Michael
PS: I just added a list of all the newSAP S/4 HANA transaction codes - can you guess how many new transactions are part of S/4HANA now?
PPS: I just wrote another blog to show you how to download all SAP tables to a spreadsheet.
Thomas Michael is the CEO of the Michael Management Corporation - one of the leading providers ofonline SAP training. He lives in New York City, had 2 Guinness on St. Patrick's Day, and is obsessed with makingcorporate training fun and effective again.
FAQs
How do I get a list of transaction codes in SAP? ›
Go to SE16 and enter table name as TSTCT give the number of hits as blank and execute. You will get the list of TCODES.
How do I Download transaction codes in SAP? ›SAP Transaction Codes for Download File — the most relevant and popular TCodes are listed at the top. You can click on TCodes to view more information like related TCodes, SAP Help/reference pages, etc. You can also click on the Functional Area to view all the TCodes for that module/sub-module.
Which table contains the list of all transactions? ›- TSTC (this table stores the transaction codes and other technical information such as program name, screen number, etc.)
- TSTCT (this table includes the transaction codes and their description in all languages)
Where you can find the complete list of Tcodes in SAP? The above-mentioned are the most frequently used Tcodes in sap fico. However, there are approximately 1000 Tcodes in the whole Financial Accounting. Likewise, the list of all Tcodes in SAP is extensive and huge.
How do I display all TCodes in SAP menu? ›Choose Extras → Settings → Show technical name. After refreshing the menu, the system displays the transaction codes of all items from the menu.
What is CV04N TCode SAP? ›CV04N is great for searching for documents in SAP DMS. The problem is when you want to search for a specific version of a document using a long list of document numbers and versions.
How do I download se16 data? ›just press CTRL + SHIFT + F9 .
How do I export a SAP menu to excel? ›In full-screen mode, choose List → Export → Spreadsheet. If you have a choice of more than one format, the Select Spreadsheet dialog box opens. 2. In the Select Spreadsheet dialog box, select the format in which you want to save the exported data.
How do I use CG3Y in SAP? ›- log into SAP and execute SAP transaction CG3Y.
- You will get following prompt screen , Enter the required file path and then select the target destination on your PC(front end).
- <SID>ADM user should have authorization to read the folder at OS level.
- SELECT table_name FROM INFORMATION_SCHEMA. TABLES WHERE table_type = 'BASE TABLE' SELECT name FROM sys. ...
- -- This returns all the tables in the database system. ...
- -- Lists all the tables in all databases SELECT table_name FROM information_schema.
How do I get a list of tables in SAP? ›
- BC — Basis Components Tables - (14478)
- CRM — Customer Relationship Management Tables - (8216)
- FI — Financial Accounting Tables - (7168)
- GRC — Governance Tables - (6877)
- CA — Cross-Application Components Tables - (5842)
- PA — Personnel Management Tables - (5033)
Code SE16N: The transaction code SE16N (general table display) is an improved version of the old data browser (SE16). It looks a bit different from the old “data browser” functionality (SE16). SE16N is an Enjoy Transaction.
What is MB51 TCode in SAP? ›MB51 is used to display a list of material documents to view information about related transactions, such as goods movements. Use this transaction to display transaction history for a variety of criteria. For example, materials, storage locations (SLocs), cost centers, etc.
What is SAP code list? ›Code list is a user defined list of values, for a list element on a screen. For example, for the UI element, Occupation, here are the possible values maintained in different systems. Code list for Occupation. in SAP Cloud for Customer. Code list for Occupation.
Is SAP full of coding? ›In simple words, SAP ABAP does require Coding knowledge for creating SAP applications. However, SAP ABAP basics don't require Coding expertise at a basic level. If you are striving to become an ABAP developer, you would most likely learn how SAP platform works, when it comes to using the ABAP programming.
What is SU01D TCode in SAP? ›SU01D is a transaction code in SAP Basis application with the description — User Display. On this page, you will find similar/related TCodes to SU01D, Tables feeding data for this TCode, links to SAP documentation, Wiki and Help pages, discussion threads, and other resources.
How do I search for transactions in SAP? ›- The transaction code is : KTRAN ( find transaction )
- Process :
- Step 1 : Type Transaction code KTRAN in the search bar.
- Step 2 : Press enter and you will be guided to a new screen and as marked in blue pen, press EXECUTE as shown below :
- hii, t. code is stad and give the user name and it will give the user specific t. ...
- For this you need reports. ...
- Use Tcode:suim Click transaction/ Executable for User, you can check check tcode.
- Type to SUIM Click on Transaction Click on User Select the user and hit Enter.
As mentioned by other responders, MB1B is an Transaction Code for Transfer Posting. Transfer Posting refers to movement of material from one location to another. In SAP it is captured through Transfer Posting.
What is VF01 TCode SAP? ›SAP t-code VF01 is used to create the Billing document in the SAP system, a SAP user can generate the Billing document using a Delivery or Sales order.
What is Fb02 used for in SAP? ›
Fb02- Document change
Business process-Fb02 is used to change a document. Please note that only certain fields like text etc. can be changed after a document is posted. If you need to change the cost center, amount, etc., then you need to reverse this document using Fb08 and then re-post the correct document.
- Log into your account on accounts.snapchat.com.
- Click 'My Data'
- Click 'Submit Request' at the bottom of the page.
- Enter a valid email address and we'll send you an email with a link once your data is ready to download. ...
- Follow the link in your email to download your data.
a. From the blue menu bar, select “LIST” → “EXPORT” → “Local File”. b. From the blue menu bar, select “SYSTEM” → “LIST” → “SAVE” → “LOCAL FILE”.
How do I download all fields from a table in SAP? ›Go to SAP SuccessFactors HCM and select Onboarding Settings Data Dictionary. Select All Fields. Click Export All. Select the file format that you want to export all the fields in.
How to extract data from sm37? ›- myFileName = session.findById("wnd[0]/usr/lbl[14,3]").text.
- session.findById("wnd[1]/usr/ctxtDY_FILENAME").text = myFileName & ".xls"
- 'please deactivate.
- 'session.findById("wnd[1]/usr/ctxtDY_FILENAME").caretPosition = 18.
Extractors are part of the data retrieval mechanisms in the SAP source system. An extractor can fill the extraction structure of a DataSource with the data from SAP source system datasets. Replication makes the DataSource and its relevant properties known in BW.
Can Excel pull data from SAP? ›You can then work with live SAP data in Excel. In Excel, open the Data tab and choose From Other Sources -> From Microsoft Query. Choose the SAPERP DSN. Select the option to use Query Wizard to create/edit queries.
What is VL10D TCode in SAP? ›VL10D is a transaction code in SAP LE application with the description — Purch. Order Items due for Delivery.
What is AL11 TCode? ›1. Transaction code AL11 is used to display all the SAP Directories. We can access the different file systems that have been defined and attached to a Parameter. In this transaction we can view a file, find files under a directory.
What is the use of CS15 in SAP? ›SAP Transaction CS15 can be used to find on which BOMs a specific component is used. This transaction is frequently used, especially in manufacturing environments, where we have complex BOMs, with many levels and components.
How do I generate a list of tables automatically? ›
Automatic Lists of Figures, Tables and Equations
Place your cursor where you want your list to be. On the References Ribbon, in the Captions Group, click the Insert Table of Figures icon (even for lists of tables and equations).
The easiest way to find all tables in SQL is to query the INFORMATION_SCHEMA views. You do this by specifying the information schema, then the “tables” view. Here's an example. SELECT table_name, table_schema, table_type FROM information_schema.
How do I get a list of tables in a large query? ›tables = client. list_tables(dataset_id) # Make an API request. Before trying this sample, follow the Ruby setup instructions in the BigQuery quickstart using client libraries. For more information, see the BigQuery Ruby API reference documentation.
How do I download a list in SAP? ›From the top Menu bar of the Transaction Code, CLICK on the List. From the List drop down box click on Export then Local file. In the pop-up box, Select format Text with Tabs.
How do I find all Z tables in SAP? ›In transaction SE11, in database table write Z* and press F4, you can find all the ZTABLES existing.
Can SAP be hacked? ›The consequences of an SAP systems hack are severe, and include financial, operational, legal, and reputational repercussions. Ideally, the strength of your SAP cybersecurity is such that it will prevent a hack from ever taking place. If it DOES happen, however, there are ways to help mitigate the damage.
What is SE16H in SAP? ›The new transaction SE16H comes with new features which enables rapid tables check and small queries. SAP Consultants used to use the transactions code SE16/SE16N/SQVI to check table's value and/or extract data. The transaction code SE16H enables: Tables check (consult and extract) like a classical SE16 or SE16N.
How to extract data from SE16 in SAP? ›Export to desirable format
ALV Grid will allow you to export to Excel and other formats, just press the button Speadsheet… (Ctrl+Shift+F7). Note, the maximum number of hits in the table is 200 as standard for SE16.
MM17 is a single transaction for material master mass maintenance. while. MASS is a transaction from where you can call many different mass maintenance transactions by object.
What is ME23N used for in SAP? ›ME23N is used to display information about an existing purchase order (PO), such as whether the vendor invoice has been received and/or paid. This includes displaying an image of an invoice (if applicable). This document is organized into two sections: • Display a Purchase Order. • Display Image of PO-Based Invoice.
What is TCode MB1A SAP? ›
MB1A is used to Post Goods Issue.... You can select the movement type for which you have to issue the goods. MB1B is used for Transfer posting of material i.e palnt to plant or storage location to storage location etc.. or blocked to unresticted or unresticted to blocked depnding on movement type you select.
How do I download a GL list in SAP? ›G / L Chart of Accounts List. Use the T-code S_ALR_87012326 or in the SAP Easy access menu, go to Accounting → Finance Accounting → General Ledger → Information System → General Ledger Reports → Master Data → Chart of Accounts. A new window will open. Enter the Chart of Accounts key → Execute (F8).
What are the 25 modules in SAP? ›- Human Resource Management (SAP HRM), also known as Human Resource (HR)
- Production Planning (SAP PP)
- Material Management (SAP MM)
- Financial Supply Chain Management (SAP FSCM)
- Sales and Distribution (SAP SD)
- Project System (SAP PS)
- Financial Accounting and Controlling (SAP FICO)
CJ20N is a transaction code in SAP Project Systems application with the description — Project Builder. On this page, you will find similar/related TCodes to CJ20N, Tables feeding data for this TCode, links to SAP documentation, Wiki and Help pages, discussion threads, and other resources.
Is SAP better than SQL? ›SAP HANA vs.
While MS SQL is based on disk storage, SAP HANA uses in-memory technology. This essentially means that SAP HANA can load data into the server memory and process the data much faster than MS SQL. Hence, HANA is more suitable for applications that need higher processing power.
SAP Consultant salary in India ranges between ₹ 3.1 Lakhs to ₹ 14.0 Lakhs with an average annual salary of ₹ 7.2 Lakhs.
Can I learn SAP on my own? ›With openSAP Microlearning, you can watch self-contained videos to complement your knowledge. Whether you're an expert or just getting started, you can choose the videos that appeal most to your individual learning goals. All videos are prepared and brought to you by SAP experts.
How do you access Tcodes? ›- Step 1 - Insert debug division. Within Function module 'AUTH_CHECK_TCODE' insert a break-point the ABAP code line 'if sy-subrc = 0. ...
- Step 2 - Executing your chosen SAP transaction code. ...
- Step 3 – Changing SY-SUBRC Value:
Transaction SU03 To look for system authorization documentation.
What does F12 do in SAP? ›| Keyboard Shortcut | Description |
|---|---|
| Shift + F3 | Exit System Task. |
| F12 | Cancel |
| Ctrl + P | |
| Ctrl + F | Find |
How do you capture transactions? ›
The most basic method used to record a transaction is the journal entry, where the accountant manually enters the account numbers and debits and credits for each individual transaction. This approach is time-consuming and subject to error, and so is usually reserved for adjustments and special entries.
What is tcode SM30 used for? ›1) SM30 T-code is used for displaying and updating table data. In this t-code SM30 the input field on the first screen is long enough to accommodate any table name. 2) While calling t-code SM30 the data browser automatically find and call that generated program.
What is tcode SE16 SAP? ›SAP Consultants used to use the transactions code SE16/SE16N/SQVI to check table's value and/or extract data. The transaction code SE16H enables: Tables check (consult and extract) like a classical SE16 or SE16N. Joint creation for small query.
What are the T codes in SAP? ›A T-code is a transaction code used whenever executing particular task . Each function in SAP ERP has an SAP transaction code associated with it .