First look at the SAP GUI
Welcome back to the next tutorial for SAP BW on HANA. Today, we learn about SAP GUI (Graphical User Interface) using which you log into SAP BW and most of the other SAP ECC systems as well.
Where can I find it?
Let’s have a look at the tool. The SAP GUI can usually be found in the Start menu –> Program files –> SAP Front End –> SAP Logon. That icon hasn’t really changed in a while so it shouldn’t be that difficult to find.
Once you open it, you should see a small window like the one below pop up. I have marked the important buttons here. Here you add the system and host details to the server you wish to connect to or modify or delete the system from your list.
- Button 1 that looks like a blank page is the Create new system
- button. It is used to add new connections
- Button 2 that looks like a pencil/pen is the Edit system button. It is used to modify the system details of an existing connection.
- Button 3 that looks like a trash can is the Delete system button. It is used to delete systems from this list that you have previously added
How do I add a system?
For now, let’s see how we can create a new system. Click on the create button the SAP GUI logon pad marked 1
Click the button marked Next
Fill in the details provided by your system administrator for this system and press finish.
How do I log into my newly added system?
Using this method, I have added a BW system and then an ECC system by repeating the same process and different system details to our SAP GUI Logon pad. In this architecture, ECC acts as a source system to the BW feeding all its transactional data for analytics in the data warehouse.
Once this is done, we can now open our systems by double clicking on the system name. Let’s try opening the BW on HANA system. We reach the below screen asking for the login details.
As you see there are 4 primary entry fields here. Let’s look at them one by one –
- Client-The client is a logical partition ID of the database. Just like your laptop hard disk can be partitioned into multiple drive IDs like C:, D:and so on, there can be multiple SAP applications installed on different partitions of the same database. Thus, it’s important to tell the system, which partition the BW application you are trying to connect to exists upon.
- User & 3. Password – Provided to you by the system administrator
- Logon Language – The language in which you want to work inside the tool. In this case, it is English by default but some clients have different defaults. You should type in the language code you wish to work on.
Provide the details and press enter.
You should then reach the first entry screen as shown below
The input field I marked in red above is where you tell SAP what you want to do in terms of codes called Transaction codes or T-CODES in SAP consultant lingo.
Let’s play around.. Shall we?
Let’s start off by something simple. If I need to view a table in SAP BW, I type in SE11 here and press enter.
You can see that now we reached a screen where can do many things including creating a table
Depending on what you want to do, there are many TCODES available and don’t waste your time memorizing each and every one of them that you find online. You will organically start remembering them as you keep reading these tutorials and when you practice of course.
Now let’s try opening another TCODE RSA1 – This is the most important TCODE in BW and it will be where you spend most of your time developing and maintaining objects. The important thing to know here is that once you open a TCODE, to switch to another one, you have 2 options:
- Keep the existing TCODE screen open and open the new TCODE in a new window.
- Open the new TCODE in the same window that’s open while removing the old screen elements.
Either way, this time just typing RSA1 won’t work because if you are not on the entry screen and on a TCODE already you either need to type /oRSA1 for case 1 or /nRSA1 for case 2 as mentioned above.
Let’s open it in the same screen by typing /nRSA1
What you see below is the RSA1 screen otherwise known as the Data Warehousing Workbench. This is where you can create most BW objects for your development.
This concludes our introduction to SAP GUI. I hope this was easy to comprehend.
Stay tuned for the next BW on HANA tutorial and make sure to share this document across social media by clicking the share buttons below. Also, subscribe to the TeachMeHANA newsletter when you get the pop-up to receive updates on our new posts.
Thank you for your support in growing this website.
<<Previous Tutorial Next Tutorial>>
i am eagerly waiting for the rest of topics.
Plz publish an article on performance & optimization techniques in HANA.
please publish next topic
Hi Krishna,
Unfortunately, all non-HANA topics will not be covered any more since I could not find time to devote to all of them. I will be focusing on writing more on HANA since the website is built around that name.
Hope you can understand.
Thanks for reading,
Shyam