Where does tcodes on command line gets stored?

Follow RSS feed Like

41 Likes 6,026 Views 104 Comments

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.

Alert Moderator

104 Comments

You must be Logged on to comment or reply to a post.

Former Member

October 7, 2013 at 3:26 pm

Liked it……
- Like(0)
- Rahul Mahajan Post author
  
  October 8, 2013 at 3:48 am
  
  Good to know that you liked it! thanks for comment! 🙂
  - Like(0)
Former Member

October 7, 2013 at 5:33 pm

Nice to know. Thanks for sharing the info.
- Like(0)
- Rahul Mahajan Post author
  
  October 8, 2013 at 3:49 am
  
  Thanks Raja! Happy Learning! 🙂
  - Like(0)
Former Member

October 7, 2013 at 7:08 pm

Thanks for the quick info!!
- Like(0)
- Rahul Mahajan Post author
  
  October 8, 2013 at 3:50 am
  
  Thanks Ansumesh! Keep learning and sharing! 🙂
  - Like(0)
Ramesh .

October 8, 2013 at 4:03 am

Nice document Rahul Mahajan… 🙂
- Like(0)
- Rahul Mahajan Post author
  
  October 8, 2013 at 6:26 am
  
  Thanks for comment Ramesh T! 🙂
  - Like(0)
Former Member

October 8, 2013 at 4:55 am

Thanks for sharing 🙂
- Like(0)
- Rahul Mahajan Post author
  
  October 8, 2013 at 6:27 am
  
  Thanks Akberhusain ! 🙂
  - Like(0)
Satish Chandra

October 8, 2013 at 5:14 am

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
- Like(0)
- Rahul Mahajan Post author
  
  October 8, 2013 at 6:31 am
  
  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
  - Like(0)
  - Satish Chandra
    
    October 8, 2013 at 6:40 am
    
    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.
    Like(0)
Former Member

October 8, 2013 at 5:19 am

cool, and worthy discovery. 😎
- Like(0)
- Rahul Mahajan Post author
  
  October 8, 2013 at 6:32 am
  
  Thanks Mahendra varman and Good to know that you like it. 🙂
  - Like(0)
Former Member

October 8, 2013 at 6:36 am

Hi,

interesting to know.

Thanks for sharing.

Cheers

Ivan
- Like(0)
- Rahul Mahajan Post author
  
  October 8, 2013 at 7:40 am
  
  Thanks for comment Ivan! 🙂
  - Like(0)
Anjan Paul

October 8, 2013 at 6:36 am

Like. Thanks
- Like(0)
- Rahul Mahajan Post author
  
  October 8, 2013 at 7:41 am
  
  Thanks Anjan Paul ! 🙂
  - Like(0)
Former Member

October 8, 2013 at 6:47 am

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
- Like(0)
- Raymond Giuseppi
  
  October 8, 2013 at 6:51 am
  
  May depend on your SAP Logon “Options” -> “Local Data” -> “Directory for Local Data”
  
  Regards,
  
  Raymond
  - Like(0)
  - Former Member
    
    October 8, 2013 at 7:21 am
    
    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….
    Like(0)
    - Rahul Mahajan Post author
      
      October 8, 2013 at 7:46 am
      
      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
      
      Like(0)
      - Former Member
        
        October 8, 2013 at 7:53 am
        
        Please ask it and let me know, thanks!
        
        Like(0)
    - Former Member
      
      October 8, 2013 at 8:04 am
      
      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.
      
      Like(0)
      - Rahul Mahajan Post author
        
        October 8, 2013 at 8:15 am
        
        Thats right Manish Kumar!
        
        Like(0)
    - Jürgen L
      
      October 8, 2013 at 8:10 am
      
      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.
      
      Like(0)
      - Rahul Mahajan Post author
        
        October 8, 2013 at 8:14 am
        
        You got it right, Thanks a lot Jürgen L! I just didn think in that way..
        
        Like(0)
Raymond Giuseppi

October 8, 2013 at 6:50 am

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
- Like(0)
- Rahul Mahajan Post author
  
  October 8, 2013 at 7:34 am
  
  Thanks Raymond Giuseppi! 🙂
  - Like(0)
Former Member

October 8, 2013 at 7:21 am

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

Rahul..

Many Thanks,

Karthick
- Like(0)
- Rahul Mahajan Post author
  
  October 8, 2013 at 7:36 am
  
  Thanks Karthick! Keep learning and sharing.
  - Like(0)
Former Member

October 8, 2013 at 7:25 am

Different one .Good to knew
- Like(0)
- Rahul Mahajan Post author
  
  October 8, 2013 at 7:36 am
  
  Thanks for comment Karthick! 🙂
  - Like(0)
Krishna Chaitanya

October 8, 2013 at 7:33 am

Good one…. 🙂
- Like(0)
- Rahul Mahajan Post author
  
  October 8, 2013 at 7:36 am
  
  Thanks Krishna! 🙂
  - Like(0)
Former Member

October 8, 2013 at 8:44 am

Really good rahul. You captured the history of history (t-code) here 🙂
- Like(0)
- Rahul Mahajan Post author
  
  October 8, 2013 at 9:20 am
  
  Thanks Kumar Sunny ! Yes, I was curious to know more on this.
  
  Keep learning and sharing!
  
  Thanks,
  
  Rahul
  - Like(0)
Former Member

October 8, 2013 at 9:25 am

useful document, thanks for sharing with screen shots.

Regards,
Giri
- Like(0)
- Rahul Mahajan Post author
  
  October 8, 2013 at 10:08 am
  
  Thanks Giri ! Yes, screenshot really helps writer and reader to understand the concept. 🙂
  - Like(0)
Piyush Kumar

October 8, 2013 at 10:38 am

awesome 🙂
- Like(0)
- Rahul Mahajan Post author
  
  October 8, 2013 at 11:34 am
  
  Thanks for nice word PIYUSH KUMAR ! 🙂
  - Like(0)
Former Member

October 8, 2013 at 10:46 am

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

Many Thanks,

Pratik
- Like(0)
- Rahul Mahajan Post author
  
  October 8, 2013 at 11:35 am
  
  Good to hear that Pratik Patil ! Keep learning and sharing ! Thanks for your comment. 🙂
  - Like(0)
Former Member

October 8, 2013 at 10:58 am

Loved this information .

Thanks for sharing.
- Like(0)
- Rahul Mahajan Post author
  
  October 8, 2013 at 11:35 am
  
  Thanks jeetendra singh ! Keep learning and sharing! 🙂
  - Like(0)
Former Member

October 8, 2013 at 11:47 am

Nice one.. 🙂
- Like(0)
- Rahul Mahajan Post author
  
  October 8, 2013 at 12:03 pm
  
  Thanks sudheer maddela! Keep learning and sharing! 🙂
  - Like(0)
Former Member

October 8, 2013 at 12:17 pm

Nice one Rahul.. 🙂
- Like(0)
- Rahul Mahajan Post author
  
  October 9, 2013 at 6:56 am
  
  Thanks Purushottam Sonawane ! Learn and Share! 🙂
  - Like(0)
Former Member

October 8, 2013 at 12:19 pm

Good job … 🙂
- Like(0)
- Rahul Mahajan Post author
  
  October 9, 2013 at 7:03 am
  
  Thanks Juneed! 🙂
  - Like(0)
Former Member

October 8, 2013 at 12:28 pm

Hello Rahul

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

Best regards,

Satendra
- Like(0)
- Rahul Mahajan Post author
  
  October 9, 2013 at 7:03 am
  
  Thanks a lot Satendra Singh Sikarwar! 🙂
  
  Good to hear that you like the work! Keep learning and sharing.
  - Like(0)
Former Member

October 8, 2013 at 3:20 pm

Interesting!
- Like(0)
- Rahul Mahajan Post author
  
  October 9, 2013 at 7:04 am
  
  Thanks for comment Michael Hase! 🙂
  - Like(0)
Modadugu Hemanth Kumar

October 9, 2013 at 7:02 am

Good work…

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

Do u have any idea to increase the same.
- Like(0)
- Rahul Mahajan Post author
  
  October 9, 2013 at 11:06 am
  
  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
  - Like(0)
  - Former Member
    
    October 9, 2013 at 11:36 am
    
    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.
    Like(0)
    - Rahul Mahajan Post author
      
      October 11, 2013 at 5:51 am
      
      Okay. Yes, Even I did not find any way to increase that limit.
      
      Thanks for reply.
      
      Cheers!!!
      
      Like(0)
rajesh bethamcharla

October 9, 2013 at 7:21 am

Good article…. 🙂
- Like(0)
- Former Member
  
  October 9, 2013 at 10:14 am
  
  IN ABAP- Netweaver
  - Like(0)
- Rahul Mahajan Post author
  
  October 9, 2013 at 11:05 am
  
  Thanks Rajesh! 🙂
  - Like(0)
Modadugu Hemanth Kumar

October 9, 2013 at 11:07 am

Good work…

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

Do u have any idea to increase the same.
- Like(0)
Former Member

October 10, 2013 at 5:48 am

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

Regards,

Aditya.
- Like(0)
- Rahul Mahajan Post author
  
  October 11, 2013 at 5:53 am
  
  Thanks Aditya Tanguturi . Good to hear that you found this article an interesting one.!
  
  Keep learning and Sharing! 🙂
  - Like(0)
Former Member

October 22, 2013 at 4:08 am

“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)….
- Like(0)
Srinu S

October 28, 2013 at 10:26 am

Nice work Rahul, l liked it much. Thanks for sharing.Keep sharing 🙂
- Like(0)
- Rahul Mahajan Post author
  
  October 29, 2013 at 6:34 am
  
  Thanks for comment Srinu!
  
  Keep learning, Sharing and inspiring. 🙂
  - Like(0)
Chandra Shekhar Agarwal

October 28, 2013 at 10:54 am

Its New thing for me. 🙂

Thanks for sharing 🙂
- Like(0)
- Rahul Mahajan Post author
  
  October 29, 2013 at 6:35 am
  
  Thanks Chandra Shekhar Agarwal. Good to know that you learn something new.
  
  Keep learning, sharing and inspiring.
  - Like(0)
  - Chandra Shekhar Agarwal
    
    October 29, 2013 at 6:43 am
    
    I will 🙂 Thanks..
    
    Good day 🙂
    Like(0)
Former Member

October 28, 2013 at 11:42 am

Hi,

Good job.

Thanks for sharing the information.
- Like(0)
- Rahul Mahajan Post author
  
  October 29, 2013 at 6:36 am
  
  Thanks for comment Riju Thomas.
  
  Keep learning, sharing and inspiring. 🙂
  - Like(0)
Ranu Eugene

October 28, 2013 at 12:00 pm

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
- Like(0)
- Rahul Mahajan Post author
  
  October 29, 2013 at 6:36 am
  
  Thanks for inspiring words Ranu Eugene.
  
  Keep learning, sharing and inspiring. 🙂
  - Like(0)
Former Member

October 28, 2013 at 12:04 pm

Good to see such inovative thought and its solution….keep it up
- Like(0)
- Rahul Mahajan Post author
  
  October 29, 2013 at 6:37 am
  
  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. 🙂
  - Like(0)
CH Raman

October 29, 2013 at 6:47 am

Nice idea and useful information. Thanks for sharing rahul.

Raman
- Like(0)
- Rahul Mahajan Post author
  
  October 29, 2013 at 6:50 am
  
  Thanks for comments Ramanjaneyulu Korrapati.
  
  Keep learning, Sharing and Inspiring. 🙂
  - Like(0)
Jesse Owens

October 29, 2013 at 8:42 am

Hi,

Nice article.

Thanks for sharing.

Keep going.

Regards

Jesse.
- Like(0)
- Rahul Mahajan Post author
  
  October 29, 2013 at 9:20 am
  
  Thanks for the comment Jesse Owens.
  
  Keep learning, Sharing and Inspiring. 🙂
  - Like(0)
Fahad Javed

October 29, 2013 at 8:54 am

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
- Like(0)
- Rahul Mahajan Post author
  
  October 29, 2013 at 9:26 am
  
  Thanks for comment Fahad Javed.
  
  I am glad that you got the answer for this.
  
  Keep learning, Sharing and Inspiring. 🙂
  - Like(0)
Former Member

November 5, 2013 at 4:44 am

Explained nicely.. 🙂

gud work Rahul
- Like(0)
- Rahul Mahajan Post author
  
  November 14, 2013 at 1:36 pm
  
  Thanks for comment Farid Hasan.
  
  Keep learning, Sharing and Inspiring.
  - Like(0)
Ramon Magalhães Ribeiro

November 7, 2013 at 5:48 pm

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.
- Like(0)
- Rahul Mahajan Post author
  
  November 14, 2013 at 1:42 pm
  
  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
  - Like(0)
Satish Kumar Balasubramanian

November 14, 2013 at 1:56 pm

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 🙂
- Like(0)
- Rahul Mahajan Post author
  
  November 22, 2013 at 6:30 am
  
  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. 🙂
  - Like(0)
  - Satish Kumar Balasubramanian
    
    November 22, 2013 at 7:05 am
    
    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?
    Like(0)
    - Rahul Mahajan Post author
      
      November 25, 2013 at 1:25 pm
      
      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
      
      Like(0)
      - Satish Kumar Balasubramanian
        
        November 26, 2013 at 4:53 am
        
        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
        
        Like(0)
      - Rahul Mahajan Post author
        
        November 26, 2013 at 6:01 am
        
        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
        
        Like(0)
Former Member

November 21, 2013 at 12:19 pm

Interesting research ! Thanks for sharing it.

Regards,

Fasi
- Like(0)
- Rahul Mahajan Post author
  
  November 22, 2013 at 6:30 am
  
  Thanks for comment Fasiullah S.
  
  Keep Learning, Sharing and Inspiring. 🙂
  - Like(0)
Former Member

November 22, 2013 at 9:12 am

hi rahul,

its really good job .
- Like(0)
- Rahul Mahajan Post author
  
  November 25, 2013 at 1:26 pm
  
  Thanks for comment amar anadkat.
  
  Keep learning, sharing and inspiring. 🙂
  - Like(0)
shravan kumar

November 25, 2013 at 11:25 am

Thanks for sharing Rahul …

innovative thinking …nice job..
- Like(0)
- Rahul Mahajan Post author
  
  November 25, 2013 at 1:26 pm
  
  Thanks for comment shravan kumar.
  
  Keep learning, sharing and inspiring. 🙂
  - Like(0)
Rainer Hübenthal

November 26, 2013 at 9:19 am

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
- Like(0)
- Former Member
  
  November 26, 2013 at 4:40 pm
  
  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.
  - Like(0)
  - Rahul Mahajan Post author
    
    November 27, 2013 at 6:17 am
    
    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
    Like(0)
    - Rainer Hübenthal
      
      November 27, 2013 at 12:45 pm
      
      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.
      
      Like(0)