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
0
votes
1 answer

VBScript, click save to continue Script

I have a problem with a VBScript when I try to automate a procedure with VBA/VBS macro and SAP GUI Scripting. It enters a contract number in VBS and does some standardized changes in SAP ERP transaction code VA03, but for some there are some…
M_Delineshev
  • 115
  • 1
  • 3
  • 11
0
votes
1 answer

Compare 2 cells in excel using VBA for SAP GUI scripting

Currently I have a script to copy data from an excel sheet and paste it in SAP in the transaction code scal. What my code does, is filter the calendar selection by each ID (e.g. AA/AB) and then copy the data for Start Date and End Date into the…
0
votes
1 answer

Input data from excel to SAP GUI then output specific row and column back to excel

Initial question is at the bottom UPDATE: Here is what I'm working with so far, but it gives me error 619 because SAP isn't returning data when the notification number isn't found. Sub QM03() Set SapGuiAuto = GetObject("SAPGUI") 'Get the SAP GUI…
0
votes
1 answer

SAP GUI capture text from read only fields does not show in script

With SAP GUI scripting, how do you get the value of a non editable field that doesn't show up in the script? The code from the script I can extract is as follows! session.findById("wnd[0]").resizeWorkingPane…
Peter
  • 148
  • 1
  • 2
  • 18
0
votes
1 answer

How to set connection language with SAP GUI Scripting

SAP GUI scripting is a powerful tool for automating any SAP GUI actions / workflows, but it is hard to find complete documentation (some on the SAP wiki, SAP blog, and YouTube). I want to set the connection language to English to avoid…
AlexM
  • 1,020
  • 2
  • 17
  • 35
0
votes
1 answer

Store the row number in a VBS script as variable and refer to it

I am writing a script from VBA and using a recorded action in SAP GUI screen. I want the script to enter a certain transaction paste a certain value (contract number) and then go to a certain row in a table double click it and do a certain action…
M_Delineshev
  • 115
  • 1
  • 3
  • 11
0
votes
1 answer

SAP GUI VBScript to cut & paste in chunks with data alteration

To get around a runtime error I need to read from an SAP table AGR_1251 in chunks using VBScript when I run a (SE16 | AGR_1251) query. I get this error TSV_TNEW_PAGE_ALLOC_FAILED - No more storage space available for extending an internal table. As…
Harvey
  • 329
  • 2
  • 15
0
votes
0 answers

Set Connection = Application.OpenConnection crashes Excel for other users

I have double checked all references match (they do) and Excel is listed under Applications in SAP; however, when others use the following code, Excel completely crashes. If I run the code (pressing the created button), Excel just closes itself. …
0
votes
1 answer

How to set current cell on SAP GUIContainerShell in C#?

I am automating my work with SAP GUI script at the moment and whilst trying to recreate the recorded macro I am having an issue at one particular point which I don't know how to…
Logan9Fingers
  • 37
  • 1
  • 3
  • 9
0
votes
1 answer

Find field name references in SAP scripting vba

I need to find the field name references to textboxes in SAP using scripting under VBA! Gridview doesn't show the names! Dim GridView As Object If Not IsObject(SapAPP) Then Set SapGuiAuto = GetObject("SAPGUI") Set SapAPP =…
Peter
  • 148
  • 1
  • 2
  • 18
0
votes
1 answer

server busy popup in SAP GUI using Blue Prism

I have automated one SAP GUI application, facing an unexpecting pop-up(server busy popup) issue. It is not occurring at a particular stage and whenever this popup occurs Blue Prism is stop working until someone click on (Switch to, Retry) that…
0
votes
0 answers

SAP Logon connection with VBA automation error

I have the following code for connecting SAP logon with VBA Private Sub CommandButton1_Click() Dim SAPapplication, Connection, session As Object Set SAPGUIAuto = GetObject("SAPGUI") Set SAPapplication = SAPGUIAuto.GetScriptingEngine Set Connection…
urvashi
  • 17
  • 7
0
votes
1 answer

Set VBA code in SAP excel script value based on Excel field (Column)

My script is working however there is one field I can't figure out how to change in the VBA script. I need to change it based on an entry in Excel. Here is the script where I am experiencing the issue, the value I have bolded (4). I've tested…
Skavis
  • 3
  • 2
0
votes
1 answer

How to read SAP HTMLViewer Control data with VBA or C#

I'm trying to automate a SAP task in which a HTMLViewercontrol is used to disply some data and update if required. The HTMLViewercontrol looks like below after loading. I tried to record the loading of the page but sadly, don't get any event in…
Ashok
  • 1,868
  • 6
  • 36
  • 70
0
votes
1 answer

Report sometimes returns 0 records in SAP GUI script

So I've recorded a script using the SAP GUI recorder. I'm basically just running 7 reports and saving the contents to an excel file. The code is uninspiring, just some variation of. session.findById("wnd[1]/usr/ctxtDY_FILENAME").text =…
Harvey
  • 329
  • 2
  • 15