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

To report this post you need to login first.

104 Comments

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

  1. 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

    (0) 
    1. Rahul Mahajan 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

      (0) 
      1. 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.

        (0) 
      1. Ravi Shankar

        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….

        (0) 
        1. Rahul Mahajan 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

          (0) 
        2. Manish Kumar

          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.

          (0) 
        3. 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.

          (0) 
      1. Manish Kumar

        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.

        (0) 
  2. Ravi Shankar

    “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)….

    (0) 
  3. 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

    (0) 
    1. Rahul Mahajan 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

      (0) 
      1. 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?

        (0) 
          1. 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

            (0) 
            1. Rahul Mahajan 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

              (0) 
  4. 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

    (0) 
    1. Manish Kumar

      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.

      (0) 
      1. Rahul Mahajan 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

        (0) 
        1. 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.

          (0) 

Leave a Reply