Skip to Content
Author's profile photo Rahul Mahajan

Where does tcodes on command line gets stored?

Introduction:

I was working on one issue in one SAP landscape on my PC and later opened another landscape and observed that the transaction codes (tcodes) which are there in command line (history) were same. 

Then I started searching for the table or a location where the transaction codes (tcodes) are getting stored which we entered on command line in SAP R3 system. Finally, after lot of search and some reading I found out the location.

This is very simple but interesting thing to know how Operating system stores the SAP commands.

Details:

Let’s first see the list of transactions which are entered on command line. Later we will be getting the same list from OS level.

Logon to your SAP R3 system and see the history of tcodes on command line.

/wp-content/uploads/2013/10/1_293144.png

Now find out the location where this tcodes are getting stored at OS level.

Go to Start -> Run -> regedit and click ok. It will open the following screen.

/wp-content/uploads/2013/10/2_293145.png

Expand the node HKEY_USERS.

/wp-content/uploads/2013/10/3_293147.png

After that expand the selected node and again expand it.

Click on Software -> SAP -> SAPGUIFront.

/wp-content/uploads/2013/10/4_293149.png

Finally, expand the SAPGUIFront and click on Code. It will open the desired list of all tcodes which user has entered on the command line on a SAP system in that particular Computer.

/wp-content/uploads/2013/10/5_293150.png

Please note the path and you can directly open it and then compare it with your systems command line list.

However, I did not want to find only this location. My next question was what about the all other transactions which are not in this list which user entered on the command line.

For that we need to go to my computer and click on Search and search the following path.

SAPHistory<User Name>.mdb

Once you click on Search it will give you the access file.

/wp-content/uploads/2013/10/6_293151.png

Remember this file is Password protected and you must have the database access password in order to open it.

/wp-content/uploads/2013/10/7_293152.png

Enter the Password and it will give you more details.

Happy Learning!

Additional Information (based on questions/suggestions):

Below settings on SAP GUI ->Options -> Local Data can be checked upon.

tcode - local data setttings.png

Assigned Tags

      104 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Liked it......

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Good to know that you liked it! thanks for comment! πŸ™‚

      Author's profile photo Former Member
      Former Member

      Nice to know. Thanks for sharing the info.

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks Raja! Happy Learning! πŸ™‚

      Author's profile photo Former Member
      Former Member

      Thanks for the quick info!!

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks Ansumesh! Keep learning and sharing! πŸ™‚

      Author's profile photo Ramesh .
      Ramesh .

      Nice document Rahul Mahajan... πŸ™‚

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for comment Ramesh T! πŸ™‚

      Author's profile photo Former Member
      Former Member

      Thanks for sharing πŸ™‚

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks Akberhusain ! πŸ™‚

      Author's profile photo Satish Chandra
      Satish Chandra

      HI, its good document to learn new things, however i did not get that second one via my computer and db password thing, but over all its good. Happy learning.

      Regards

      Satish chandra

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Hi Satish,

      Thanks for comment!

      The second file (.mdb) is stored in your computer's drive which will give you all the tcodes which you can not view in first location. We can call it as historical data.

      When we try to open it , it asks for password as its protected file. I think BASIS team has access to it.

      Please let me know for more questions.

      Thanks,

      Rahul

      Author's profile photo Satish Chandra
      Satish Chandra

      Then Rahul,

      i tried it form my system and i did not get any box asking for password.

      that is it or should i get that box asking for password but password would be with basis.

      guide me on this.

      thanks.

      Author's profile photo Former Member
      Former Member

      cool, and worthy discovery.  😎

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks Mahendra varman and Good to know that you like it. πŸ™‚

      Author's profile photo Former Member
      Former Member

      Hi,

      interesting to know.

      Thanks for sharing.

      Cheers

      Ivan

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for comment Ivan! πŸ™‚

      Author's profile photo Anjan Paul
      Anjan Paul

      Like. Thanks

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks Anjan Paul ! πŸ™‚

      Author's profile photo Former Member
      Former Member

      Hi,

      SAPHistory<User Name>.mdb

      For me I am not able to find the location in search items please help me?

      Regards,

      Ravi Shankar L

      Author's profile photo Raymond Giuseppi
      Raymond Giuseppi

      May depend on your SAP Logon "Options" -> "Local Data" -> "Directory  for Local Data"

      Regards,

      Raymond

      Author's profile photo Former Member
      Former Member

      Now I find the *.*Mdb location you have mentioned.If I double click means it is not asking for password and also it asks the format that we like to open in excel,notepad or word etc...

      If I choose excel it is not working fine for me displaying junk characters....

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Good to know that you got the file Ravi Shankar!

      In our organization, the file was made as password protected. After reading your comments, we can say that it's not password protected by default.

      I am sorry as i never saw this file as don't have authorization. But, I will work with BASIS team and then try to answer why it's not readable in excel for you.

      Thanks to Raymond Giuseppi for mentioning the local data path. I missed tht information. I will add it later in this article.

      Cheers!!!

      Rahul

      Author's profile photo Former Member
      Former Member

      Please ask it and let me know, thanks!

      Author's profile photo Former Member
      Former Member

      If you open a video file in Notepad, values shown will appear junk.

      Same is the case when you open mdb file in excel.

      You got an option to choose a suitable application because your operating system does not have a compatible software for mdb format i.e. Microsoft Access.

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thats right Manish Kumar!

      Author's profile photo JΓΌrgen L
      JΓΌrgen L

      if you double click the *.mdb file and it asks you if you would like to open in excel,notepad or word  then this just means you have no Microsoft Access installed on your computer.

      Hence it is logical that you dont get the password prompt either.

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      You got it right, Thanks a lot Jürgen L! I just didn think in that way..

      Author's profile photo Raymond Giuseppi
      Raymond Giuseppi

      You could also provide links to Note 1121688 - SAP History: explaining database files, etc. (for the mdb history log) and Note 182592 - Delete/change transaction codes in command field (for the regedit code stack)

      Regards,

      Raymond

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks Raymond Giuseppi! πŸ™‚

      Author's profile photo Former Member
      Former Member

      Nice work....! and Thanks for sharing us...!

      Rahul..

      Many Thanks,

      Karthick

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks Karthick! Keep learning and sharing.

      Author's profile photo Former Member
      Former Member

      Different one .Good to knew

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for comment Karthick! πŸ™‚

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Good one.... πŸ™‚

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks Krishna! πŸ™‚

      Author's profile photo Former Member
      Former Member

      Really good rahul. You captured the history of history (t-code) here πŸ™‚

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks Kumar Sunny ! Yes, I was curious to know more on this.

      Keep learning and sharing!

      Thanks,

      Rahul

      Author's profile photo Former Member
      Former Member

      useful document, thanks for sharing with screen shots.

      Regards,
      Giri

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks Giri ! Yes, screenshot really helps writer and reader to understand the concept. πŸ™‚

      Author's profile photo Piyush Kumar
      Piyush Kumar

      awesome πŸ™‚

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for nice word PIYUSH KUMAR ! πŸ™‚  

      Author's profile photo Former Member
      Former Member

      I was curious all the time for this thing, thanks for leading us to the exact path. Simple indeed nice document.

      Many Thanks,

      Pratik

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Good to hear that Pratik PatilKeep learning and sharing ! Thanks for your comment. πŸ™‚

      Author's profile photo jeetendra singh
      jeetendra singh

      Loved this information .

      Thanks for sharing.

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks jeetendra singh ! Keep learning and sharing! πŸ™‚

      Author's profile photo Former Member
      Former Member

      Nice one.. πŸ™‚

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks sudheer maddela! Keep learning and sharing! πŸ™‚

      Author's profile photo Former Member
      Former Member

      Nice one Rahul.. πŸ™‚

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks Purushottam Sonawane ! Learn and Share! πŸ™‚

      Author's profile photo Former Member
      Former Member

      Good job ... πŸ™‚

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks Juneed! πŸ™‚

      Author's profile photo Former Member
      Former Member

      Hello Rahul

      Gr8 reserach work n excellent document.thnx 4 ur sharing.

      Best regards,

      Satendra

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks a lot Satendra Singh Sikarwar! πŸ™‚

      Good to hear that you like the work! Keep learning and sharing.

      Author's profile photo Former Member
      Former Member

      Interesting!

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for comment Michael Hase! πŸ™‚

      Author's profile photo Modadugu Hemanth Kumar
      Modadugu Hemanth Kumar

      Good work...

      As per my knowledge comand line can store only 15 tcodes only.

      Do u have any idea to increase the same.

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for comment Modadugu Hemanth Kumar

      Yes, you are correct, we can store only 15 tcodes on command line.

      Sorry, I don't have answer on "How to increase it?" as of now. I will get back to you on this.

      Thanks,

      Rahul

      Author's profile photo Former Member
      Former Member

      Adding Code15 string does not have any effect.

      Adjacent settings in registry do have have anything that has 15 (hex value F).

      So I think it is not possible to change that limit.

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Okay. Yes, Even I did not find any way to increase that limit.

      Thanks for reply.

      Cheers!!!

      Author's profile photo rajesh bethamcharla
      rajesh bethamcharla

      Good article.... πŸ™‚

      Author's profile photo Former Member
      Former Member

      IN ABAP- Netweaver

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks Rajesh! πŸ™‚

      Author's profile photo Modadugu Hemanth Kumar
      Modadugu Hemanth Kumar

      Good work...

      As per my knowledge comand line can store only 15 tcodes only.

      Do u have any idea to increase the same.

      Author's profile photo Former Member
      Former Member

      Very nice.. I like these kind intresting work.. thanks for info..

      Regards,

      Aditya.

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks Aditya Tanguturi . Good to hear that you found this article an interesting one.!

      Keep learning and Sharing! πŸ™‚

      Author's profile photo Former Member
      Former Member

      "Database Access Password" I dont know I am having it or not can you please explain this... who will have the access for this(BASIS Or Team Lead Like that)....

      Author's profile photo Srinu S
      Srinu S

      Nice work Rahul, l liked it much. Thanks for sharing.Keep sharing πŸ™‚

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for comment Srinu!

      Keep learning, Sharing and inspiring. πŸ™‚

      Author's profile photo Chandra Shekhar Agarwal
      Chandra Shekhar Agarwal

      Its New thing for me. πŸ™‚

      Thanks for sharing πŸ™‚

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks Chandra Shekhar Agarwal. Good to know that you learn something new.

      Keep learning, sharing and inspiring.

      Author's profile photo Chandra Shekhar Agarwal
      Chandra Shekhar Agarwal

      I will πŸ™‚ Thanks..

      Good day πŸ™‚

      Author's profile photo Former Member
      Former Member

      Hi,

      Good job.

      Thanks for sharing the information.

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for comment Riju Thomas.

      Keep learning, sharing and inspiring. πŸ™‚

      Author's profile photo Ranu Eugene
      Ranu Eugene

      Hi Rahul,

      Very good document with good knowledge.

      It is indeed new thing for me and thanks a lot for sharing.

      Keep up the good work. πŸ™‚

      Best of Luck. πŸ™‚

      Regards

      Eugene

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for inspiring words Ranu Eugene.

      Keep learning, sharing and inspiring. πŸ™‚

      Author's profile photo Former Member
      Former Member

      Good to see such inovative thought and its solution....keep it up

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for comments Kuldeep Chowdhary.

      Well, it was new for me when i discovered it and then thought of sharing it with others.

      Keep learning, sharing and inspiring. πŸ™‚

      Author's profile photo CH Raman
      CH Raman

      Nice idea and useful information. Thanks for sharing rahul.

      Raman

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for comments Ramanjaneyulu Korrapati.

      Keep learning, Sharing and Inspiring. πŸ™‚

      Author's profile photo Jesse Owens
      Jesse Owens

      Hi,

      Nice article.

      Thanks for sharing.

      Keep going.

      Regards

      Jesse.

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for the comment Jesse Owens.

      Keep learning, Sharing and Inspiring. πŸ™‚

      Author's profile photo Fahad Javed
      Fahad Javed

      Thanks Rahul for sharing this insightful document,i was always curious about it and now i know how it works. Keep it up.

      Regards,

      Fahad

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for comment Fahad Javed.

      I am glad that you got the answer for this.

      Keep learning, Sharing and Inspiring. πŸ™‚

      Author's profile photo Former Member
      Former Member

      Explained nicely.. πŸ™‚

      gud work Rahul

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for comment Farid Hasan.

      Keep learning, Sharing and Inspiring.

      Author's profile photo Ramon MagalhΓ£es Ribeiro
      Ramon MagalhΓ£es Ribeiro

      Great Post.

      You can also add in your post that there is a table that store tha name and description of the transactions.

      The table name is TSTC.

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for suggestion Ramon Magalhães Ribeiro. πŸ™‚

      This is well known table and won't be providing information related to last used tcodes so not adding this information in this article.

      But thanks again for thinking in this direction. I will surely keep updating this article.

      - Rahul

      Author's profile photo Satish Kumar Balasubramanian
      Satish Kumar Balasubramanian

      So nice of you that you shared  Rahul πŸ™‚

      But i could not understand this,

      SAPHistory<User Name>.mdb

      can you pls navigate on this.

      Thanks πŸ™‚

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for comment Satish Kumar Balasubramanian.

      Kindly read article again and then comments. We already discussed on this and i am sure you will get answer in it.

      Keep Learning, Sharing and Inspiring. πŸ™‚

      Author's profile photo Satish Kumar Balasubramanian
      Satish Kumar Balasubramanian

      Hi Rahul,

      Thanks for your kind reply.

      I have gone through the comments but still i could not find neither any mdb file in system nor the "the directory for local data" as mentioned by raymond.

      What me be the reason for this? May be the mdb file is not maintained or what?

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Hi Satish Kumar Balasubramanian.,

      I have updated this article with additional information section.

      Could you please those settings on your computer and see if its anything to do with it.

      Let me know on this.

      Thanks,

      Rahul

      Author's profile photo Satish Kumar Balasubramanian
      Satish Kumar Balasubramanian

      Hi Rahul,

      Great Work, Now i got know where it is stored, and of course it asks for the database password. Whom should i contact for that?.

      Nice information, thanks for your effort to ensure the clear understanding for people like me.

      Expecting more information like this from you in future, All the best πŸ™‚ .

      Learning is Good, But sharing is Great πŸ™‚

      Thanks,

      Satish

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Hi Satish Kumar Balasubramanian.,

      Happy to see that you got the answer for your question.

      As i mentioned in the article, you may want to talk to your BASIS admin once.

      Yes, Sharing is equally important to learning. and that's why i always ask people to "Keep Learning, Sharing and Inspiring". πŸ™‚

      Cheers!!!

      Rahul

      Author's profile photo Former Member
      Former Member

      Interesting research ! Thanks for sharing it.

      Regards,

      Fasi

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for comment Fasiullah S.

      Keep Learning, Sharing and Inspiring. πŸ™‚

      Author's profile photo Former Member
      Former Member

      hi rahul,

      its really good job .

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for comment amar anadkat.

      Keep learning, sharing and inspiring. πŸ™‚

      Author's profile photo shravan kumar
      shravan kumar

      Thanks for sharing Rahul ...

      innovative thinking ...nice job..

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for comment shravan kumar.

      Keep learning, sharing and inspiring. πŸ™‚

      Author's profile photo Rainer HΓΌbenthal
      Rainer HΓΌbenthal

      Thx, but i'm still looking for the place where the last directory is stored when i download something from SAP Gui. I cant find this in the registry nor in the GUI settings. The GUI ist still blocking a folder preventing me from deleting the complete folder structure cause i do not need it anymore. If i close all GUIs, delete the folder structure its regenrated when i open the SAP Gui again πŸ™

      //Rainer

      Author's profile photo Former Member
      Former Member

      Hi Rainer

      You can create parameter GR8 in user profile with value as desired download path. It works for me on SAP GUI 720.

      GR9 for upload path.

      To further discuss this, you can open a new discussion(not a question), or follow me temporarily for Direct Message.

      Author's profile photo Rahul Mahajan
      Rahul Mahajan
      Blog Post Author

      Thanks for the answer Manish Kumar.

      I was not aware about this. I will try it.

      Rainer Hübenthal : I hope Manish answered your query. As mentioned by him, kindly open a new discussion for it. Even i would be happy to learn more on it. πŸ™‚

      Thanks to both of you for your comments.

      Regards,

      Rahul

      Author's profile photo Rainer HΓΌbenthal
      Rainer HΓΌbenthal

      Sorry for beeing a little bit off topic but i'm looking so long for this, running the registry up and down and deep inspecting any ini file i could fine. Its really hard to believe that this loittle thing is hidden in such a way.