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.
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.
Expand the node HKEY_USERS.
After that expand the selected node and again expand it.
Click on Software -> SAP -> SAPGUIFront.
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.
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.
Remember this file is Password protected and you must have the database access password in order to open it.
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.
Liked it……
Good to know that you liked it! thanks for comment! 🙂
Nice to know. Thanks for sharing the info.
Thanks Raja! Happy Learning! 🙂
Thanks for the quick info!!
Thanks Ansumesh! Keep learning and sharing! 🙂
Nice document Rahul Mahajan… 🙂
Thanks for comment Ramesh T! 🙂
Thanks for sharing 🙂
Thanks Akberhusain ! 🙂
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
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
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.
cool, and worthy discovery. 😎
Thanks Mahendra varman and Good to know that you like it. 🙂
Hi,
interesting to know.
Thanks for sharing.
Cheers
Ivan
Thanks for comment Ivan! 🙂
Like. Thanks
Thanks Anjan Paul ! 🙂
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
May depend on your SAP Logon “Options” -> “Local Data” -> “Directory for Local Data”
Regards,
Raymond
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….
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
Please ask it and let me know, thanks!
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.
Thats right Manish Kumar!
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.
You got it right, Thanks a lot Jürgen L! I just didn think in that way..
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
Thanks Raymond Giuseppi! 🙂
Nice work….! and Thanks for sharing us…!
Rahul..
Many Thanks,
Karthick
Thanks Karthick! Keep learning and sharing.
Different one .Good to knew
Thanks for comment Karthick! 🙂
Good one…. 🙂
Thanks Krishna! 🙂
Really good rahul. You captured the history of history (t-code) here 🙂
Thanks Kumar Sunny ! Yes, I was curious to know more on this.
Keep learning and sharing!
Thanks,
Rahul
useful document, thanks for sharing with screen shots.
Regards,
Giri
Thanks Giri ! Yes, screenshot really helps writer and reader to understand the concept. 🙂
awesome 🙂
Thanks for nice word PIYUSH KUMAR ! 🙂
I was curious all the time for this thing, thanks for leading us to the exact path. Simple indeed nice document.
Many Thanks,
Pratik
Good to hear that Pratik Patil ! Keep learning and sharing ! Thanks for your comment. 🙂
Loved this information .
Thanks for sharing.
Thanks jeetendra singh ! Keep learning and sharing! 🙂
Nice one.. 🙂
Thanks sudheer maddela! Keep learning and sharing! 🙂
Nice one Rahul.. 🙂
Thanks Purushottam Sonawane ! Learn and Share! 🙂
Good job … 🙂
Thanks Juneed! 🙂
Hello Rahul
Gr8 reserach work n excellent document.thnx 4 ur sharing.
Best regards,
Satendra
Thanks a lot Satendra Singh Sikarwar! 🙂
Good to hear that you like the work! Keep learning and sharing.
Interesting!
Thanks for comment Michael Hase! 🙂
Good work…
As per my knowledge comand line can store only 15 tcodes only.
Do u have any idea to increase the same.
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
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.
Okay. Yes, Even I did not find any way to increase that limit.
Thanks for reply.
Cheers!!!
Good article…. 🙂
IN ABAP- Netweaver
Thanks Rajesh! 🙂
Good work…
As per my knowledge comand line can store only 15 tcodes only.
Do u have any idea to increase the same.
Very nice.. I like these kind intresting work.. thanks for info..
Regards,
Aditya.
Thanks Aditya Tanguturi . Good to hear that you found this article an interesting one.!
Keep learning and Sharing! 🙂
“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)….
Nice work Rahul, l liked it much. Thanks for sharing.Keep sharing 🙂
Thanks for comment Srinu!
Keep learning, Sharing and inspiring. 🙂
Its New thing for me. 🙂
Thanks for sharing 🙂
Thanks Chandra Shekhar Agarwal. Good to know that you learn something new.
Keep learning, sharing and inspiring.
I will 🙂 Thanks..
Good day 🙂
Hi,
Good job.
Thanks for sharing the information.
Thanks for comment Riju Thomas.
Keep learning, sharing and inspiring. 🙂
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
Thanks for inspiring words Ranu Eugene.
Keep learning, sharing and inspiring. 🙂
Good to see such inovative thought and its solution….keep it up
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. 🙂
Nice idea and useful information. Thanks for sharing rahul.
Raman
Thanks for comments Ramanjaneyulu Korrapati.
Keep learning, Sharing and Inspiring. 🙂
Hi,
Nice article.
Thanks for sharing.
Keep going.
Regards
Jesse.
Thanks for the comment Jesse Owens.
Keep learning, Sharing and Inspiring. 🙂
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
Thanks for comment Fahad Javed.
I am glad that you got the answer for this.
Keep learning, Sharing and Inspiring. 🙂
Explained nicely.. 🙂
gud work Rahul
Thanks for comment Farid Hasan.
Keep learning, Sharing and Inspiring.
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.
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
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 🙂
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. 🙂
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?
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
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
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
Interesting research ! Thanks for sharing it.
Regards,
Fasi
Thanks for comment Fasiullah S.
Keep Learning, Sharing and Inspiring. 🙂
hi rahul,
its really good job .
Thanks for comment amar anadkat.
Keep learning, sharing and inspiring. 🙂
Thanks for sharing Rahul …
innovative thinking …nice job..
Thanks for comment shravan kumar.
Keep learning, sharing and inspiring. 🙂
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
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.
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
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.