Questions tagged [sap-gui]

Questions about SAP GUI, SAP GUI Scripting, using SAP GUI (Calling transactions, setting up in the environment, customizing, etc.)

"SAP Graphical User Interface" (SAP GUI) is a legacy SAP front end tool available for various desktop environments (Windows, Mac, Java) and as an HTML web application.

It also comes with SAP GUI Scripting, an API that allows users to automate repetitive tasks by recording and running macro-like scripts (VBS and others for Windows, JavaScript for Java).

720 questions
-1
votes
1 answer

Date of first day of current month

I have a script recorded from SAP ERP via SAP GUI, to run transaction code VA05. I need to run this script each day (I am fine achieving this) and I need the start date to always be the first date of the current month. My script is below. What…
UKCLA
  • 1
-1
votes
1 answer

Select and click workplace of SAP to load login interface via Python script

I sometimes have many duplicate documents that need to be downloaded from SAP. Now I found some script that can access the SAP and do the boring staffs. But they focus on how to login, no description about how can select & click the workplace when…
Ringo
  • 1,173
  • 1
  • 12
  • 25
-1
votes
1 answer

VBA opening new session in SAP GUI and execute transaction in it

Good day, What would be the VBA code to open new session in SAP GUI (assuming user is logged into SAP already) and run transaction in that new session. I would appreciate help.
-1
votes
1 answer

Change encoding, downloading file from SAP

I'm trying to download some documents via SAP GUI using Python, but I get them with a wrong encoding. When I tried UTF8 manually - i got the wrong encoding. Changed Codepage settings in connection options to ANSI encoding and was glad to see fine…
Anton Makarov
  • 562
  • 3
  • 12
-1
votes
3 answers

Excel file downloaded from SAP is not getting recognized in my VBA code

I have a macro code which downloads an excel file from SAP, post which it should do some data manipulation on it to arrive at my final output file. The code downloads and has the excel file opened. But still it shows an error every time that object…
stark1208
  • 1
  • 3
-1
votes
1 answer

application.Children is an empty list while using SAP GUI with VBScript:

The enumerator of the collection cannot find en element with the specified index. I get the above error on line number of 3 of the following code: Set SapGuiAuto = GetObject("SAPGUI") Set application = SapGuiAuto.GetScriptingEngine Set connection =…
suyash ghuge
  • 95
  • 2
  • 13
-1
votes
1 answer

Automatically export a worksheet from SAP GUI

I use vbscript to run SAP GUI via Excel VBA, the following is my actions: Login select Tcode give data and execute export as worksheets. My question is that the last action (export as worksheets) will show a file dialog that I need to choose path…
pgrkie
  • 1
  • 1
  • 3
-1
votes
2 answers

Create VBA Script to run GUI script recording from SAP

I have looked at other examples but I am hopelessly lost. I have recorded a script in SAP. Now i just need to run in Excel as is. Script I recorded is below. How do I start and end the code? If Not IsObject(application) Then Set SapGuiAuto =…
kim
  • 1
  • 1
-1
votes
1 answer

What is wrong in the IF condition of the text of message from the status bar

I am trying to create a script to enter transactions in SAP from an Excel document. Occasionally some transactions will need a different action performed, which I delineated in my code below. I have tried else, else if, if, and if not conditions. I…
Dan2019
  • 1
  • 1
  • 1
-1
votes
2 answers

In SAP GUI scripts, is it possible to select a column by name instead of by row position?

I have a script that successfully creates a layout variant. I choose the columns that I would like to be in the report by choosing the row number of where the column name is in the list, like this: …
-1
votes
1 answer

Change language on SAP shortcut

I got a link on my desktop. Selecting this, my computer is opening a connection to an SAP System - SingleSignOn, so no user and password is required. The link looks like this (I changed the parameter like server, client etc.): "C:\Program Files…
Jan021981
  • 521
  • 3
  • 28
-1
votes
1 answer

SAP Table Display Area

I've been having an issue with a table in one of the transactions where the table doesn't fit the maximized window. Is anyone aware of a solution to this problem?
-1
votes
1 answer

How to access a second column of a SAP GuiTree Element?

In our SAP System, we automate the GuiTree control quite often, via SAP GUI Scripting API. In the left column, there is a Description. In the second column, there is an icon containing a tooltip. With this code, I can read the text of each node: …
Jan021981
  • 521
  • 3
  • 28
-1
votes
1 answer

How to upload from clipboard in VBA Excel?

After executing a transaction, I get bunch of user ids, then I copy it and paste it into another part of the transaction. In the below code, I copy user ids in the first part and store it in BNAME. VBA is unable to upload from the clipboard in the…
Anirudh Chauhan
  • 111
  • 2
  • 9
-1
votes
1 answer

How to Configure the SAP Netweaver in Mac OS?

I tried as follows. I gave Host number . But, the problem is with in the format of the connection.
BalajiB
  • 326
  • 6
  • 29