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.
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, transaction FB01 lets 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_DISP displays 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.
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:
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.
Before I downloaded the table I guessed that there must be 10s of 1000s of codes…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!
PS: I just added a list of all the new SAP 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 of online SAP training. He lives in New York City, had 2 Guinness on St. Patrick's Day, and is obsessed with making corporate training fun and effective again.
That’s right, folks, this month we’re celebrating our 20th year in business – woohoo! While we look back at all the things we’ve achieved and lean forward to see all the things ...
A few months ago, I wrote a blog about how to download all SAP transaction codes. We received a chat on our website from a student asking if we had a list of all SAP tcodes…and frankly, ...
Each year we write and publish dozens of blog articles in categories like SAP, Job Tips, Learning & Development, Instructors or even our own internal MMC News. In 2019 we started to publish a lot ...