SAP GUI training - SAP S/4 HANA trainings with free trial
SAP GUI training - SAP S/4 HANA trainings with free trial
 

How to export SAP report to Excel in 3 easy steps?

It is possible to export basically any SAP list to Excel, the process being actually to print it to a file, allowing to choose several solutions, unconverted printing, MS Excel spreadsheet export, rich text format for display in notepad, HTML format for web browser display, and copy in the clipboard to copy manually....
Read more
SAP GUI training - SAP S/4 HANA trainings with free trial
SAP GUI training - SAP S/4 HANA trainings with free trial
 

SAP how to export to Excel spreadsheet?

Exporting data from SAP to Excel is pretty simple. See below how to export a SAP table to Excel, or export a SAP report to Excel with a different procedure. Once the export SAP Excel has been performed, you will be able to play with the extract data from SAP with advanced vlookup in Excel, Excel string compare, count number of occurrences, and other spreadsheet standard functions....
Read more
SAP GUI training - SAP S/4 HANA trainings with free trial
SAP GUI training - SAP S/4 HANA trainings with free trial
 

Where is saplogon.ini file stored in Windows 10?

The easiest way to update your server list, is to request your project or a colleague to provide you with the server list. Once you get the SAP server list, which will be a text file called SAPLogon.ini, all you have to do to add server in SAP 740 or add server in SAP 750 with a full list instead of adding them one by one, is to paste this file in the right SAP HANA configuration file location as shown below....
Read more
SAP GUI training - SAP S/4 HANA trainings with free trial
SAP GUI training - SAP S/4 HANA trainings with free trial
 

How to reset and change SAP password?

Reset the SAP password and change password in SAP are two different operations. Resetting the SAP password must be done by the system administrator, but to change password in SAP can be done by the user himself, both in the SAP 740 installation, in the SAP 750 installation, and the SAP HANA interface....
Read more
SAP GUI training - SAP S/4 HANA trainings with free trial
SAP GUI training - SAP S/4 HANA trainings with free trial
 

SAP change language of the SAP interface after login

In order to change the default language, the one displayed by default in the SAP login screen, you need to change it through the preferences. If you simply select another language while logging in, it will be applied to the current session only, and you'll have to enter it again the next time you log in....
Read more
SAP GUI training - SAP S/4 HANA trainings with free trial
SAP GUI training - SAP S/4 HANA trainings with free trial
 

Remove SAP GUI security notifications

Are you getting annoyed by all these SAP GUI Security notifications (Fig 1), asking you all the time if you want to allow a file access ? Saying each time “Always allow”, or any option that includes the “allow” word, might get you crazy… ...
Read more
SAP GUI training - SAP S/4 HANA trainings with free trial
SAP GUI training - SAP S/4 HANA trainings with free trial
 

How to create customizing request in SAP

When doing important changes in the system, especially in SAP customizing transaction code SPRO customization transaction, it is necessary to enter a customization request in order to proceed with saving the changes, that are most likely necessary to be transported later to other systems....
Read more
SAP GUI training - SAP S/4 HANA trainings with free trial
SAP GUI training - SAP S/4 HANA trainings with free trial
 

How to change color in SAP GUI

Personalizing colors of SAP interface windows is a great way to differentiate the SAP systems being worked one. For example, working at the same time on development system, another one for testing, and another one for production. Or having one window for European system, another one for America, and another one for Asia....
Read more
SAP GUI training - SAP S/4 HANA trainings with free trial
SAP GUI training - SAP S/4 HANA trainings with free trial
 

Display technical names in SAP

In short: in menu Extras and Settings, check the box "Display Technical Names", this will show the transaction codes next to the transaction in SAP Easy Access. Having to look for transactions in the SAP user menu might seems complicated, especially as the search is not always successful – sometimes leading to interface errors....
Read more
SAP GUI training - SAP S/4 HANA trainings with free trial
SAP GUI training - SAP S/4 HANA trainings with free trial
 

SAP display technical names in dropdown

In the SAP graphical user interface, it might happen that the entries are displayed without their keys (the main identifier from the corresponding table), as seen below. In order to do so, in the SAP GUI, open the Options... from the Customize Local Layout menu....
Read more
SAP GUI training - SAP S/4 HANA trainings with free trial
SAP GUI training - SAP S/4 HANA trainings with free trial
 

SAP turn off sound effects

In short : uncheck the activate audio signal box in options > interaction design > sound settings menu. Getting annoyed by the SAP sounds, or missing them ? It is quite simple to deactivate the notification sounds in whole SAP (Logon and sessions), or to activate them....
Read more
SAP GUI training - SAP S/4 HANA trainings with free trial
SAP GUI training - SAP S/4 HANA trainings with free trial
 
SAP GUI training - SAP S/4 HANA trainings with free trial
SAP GUI training - SAP S/4 HANA trainings with free trial