I just launched "SAP GUI Scripting: Understanding the Basics" ebook! If you are interested to learn more, check it out in the link below: joelting.com/sap-ebook/
I'm so happy to see your videos, this type of video is very rare nowadays. You help me a lot, you make my daily tasks quick and easy. Many thanks Joel! A hug straight from Brazil!
Hey Stefan, for some reason I don't see the scripting API option when I download it. I see Analyzer, recorder, composer and so but no scripting API, do you know what could be the reason?
Dear Joel, I am glad you are back! I really appreciate your past videos, and now we can automate simple data extractions. However, since we have to run various SAP reports, such as KSB1 or 2KEE, with variants already defined in SAP. Is there anyway to run those reports with variant specified in the script? I try to use search function but it is not solving the issue.
Hi there! Are you able to specify the Variant right at the beginning? (under "Layout" field for KSB1 and "Display Variant" field for 2KEE. I think that is the most efficient and error-free way to execute with Variant. Otherwise, selecting it using the search box may expose the script to more potential errors.
Hi Joel, tks for the tip. I downloaded scripting tracker, but when I use the tracker and go down the tree, it is not going all the way to the elements, it goes only at a level call "shell" and does not go any further, can you help me? Any ideas why this is happening?
Are you looking at a PDF HTML viewer or something? You can try and check the type of the shell to identify what is it and identify what is the method to interact with it.
Hi there, as SAP Fiori is web-based, I'm not aware of script that works directly from SAP. You may want to explore web browser automation using Selenium if you would like to create automation for SAP Fiori. There's recorder available for that but I have not tested that myself.
Hi Joel, Thanks for educating. Am looking for a case where it has to get data of BOM documents and it has to open all the documents. Could you please make a video on the above requirement? It would be helpful Thanks
Hi there. I have not covered this before. You need to be clear on what happens on each session and the sequence of each of the steps. You can set up the session by assigning them to 2 different variables. Set session1 = connection.Children(0) and Set session2 = connection.Children(1). Then you should be able to assign each session to perform certain steps (session1.findById("wnd[0]").sendVKey 0 or session2.findById("wnd[0]").sendVKey 0).
Hi Joe, Do you have a video on the step by step tutorial like creation from SAP then I will use Macros to run, also how to set up macros template.I'm using SAP ECC , sample transaction code is ME11. Thanks for sharing the link if you have
Hi there. You can refer to the video below: ruclips.net/video/ISDX5LwcVPQ/видео.html It shows you generally how a script can be recorded and modified so that it can be executed in using Excel macro.
Hi Joel, scripting is disabled in my organisation. I was wondering if there is another way to incorporate GUI scripts? Maybe using GuiXt which is avaliable? Thanks
Hi there. From my understanding, there is nothing that we can do if it is being disabled. If it is disabled, we will not be able to establish a connection with SAP GUI. I have not used GuiXt before. But based on my short study on it, GuiXt seems to be a program to design the front end of SAP, and not for running scripts or allowing connections to established with programs.
Hi Joe, I want to update SAP data from excel file for tcode MSC2N where I want to update the data for certain material/batches. I created file to Update MSC2N, but this is for one defined value only and not from excel Can you please to create excel which can pick data and update MSC2N like Date of Manufacturing, shelf life, vendor batch, country of origin
Hi, let me see what I can do. But for you to get started, you probably just need to record 1 entry to get the base code, then modify the script to use loop to go through every iteration to perform the update.
Hi there, are you facing issue with recording service for object menu clicks? I read somewhere that one of the SAP logon has that issue, but the user reported that the issue went away after updating his SAP logon version
Hi Joel, I am new to your channel. I am simply a person with accounting knowledge and work on SAP manually. Can you give some guidance how I can learn these scripting skills. Would appreciate if you can guide me through your journey and what helped you..
Hi there. My journey began with a strong foundation in accounting, much like yours. To dive into scripting, I started with the basics of programming by learning VBA. You don't need to be an expert, but understanding concepts like variables, loops, and conditional statements is crucial to design and customize your script. Once I understand the basics, I use the script recorder to get all the IDs I need to interact with SAP user interface. With both knowledge, you will be able think of different ways to design and implement scripts to automate some simple daily task. As you get more comfortable, you can start to work on more complex projects which involves a lot of steps. My journey was marked by a lot of trial and error, but the key is to stay curious and keep learning. Best of luck in your learning journey!
Hi Hugo, can you check your preference under "Customizing" > "Edit Preference File" in the scripting tracker? Mine has a line sapfewse = %PROGRAMFILES(x86)%\SAP\FrontEnd\SAPgui Make sure that sapfewse.ocx is located in that folder.
Hi, I believe you are referring to the native script recorder that comes together with SAP. The tool mentioned in the video, the Scripting Tracker requires a download and installation.
Hi there! Yes, you are right. But usually if there's a business case, the IT department will happily help to install the programs required. But of course, that varies between companies.
If the recorder button is not recording, it is very likely that your organization have disabled scripting for end user. Unfortunately if that's the case, there's nothing much that we can do.
Hi Joel, this is Wendy and i must say your SAP/VBA videos are really helpful and i am able to do SAP automatically!! Just a quick question , when i tried to extract the data of one specific cell of SAP APO module to excel, it could not be completed with number i wanted. It shows "SAPGUI.GridViewCtrl.1" even i tried several times with different ways...the code i use is below: session.findById("wnd[0]/usr/subREQMTS:/SAPAPO/SAPLRRP_REQMTS:3000/cntlALV_GRID_REQMTS/shellcont/shell").currentCellColumn = "EXTRA" session.findById("wnd[0]/usr/subREQMTS:/SAPAPO/SAPLRRP_REQMTS:3000/cntlALV_GRID_REQMTS/shellcont/shell").PressEnter Cells(currentline, 6).Value = session.findById("wnd[0]/usr/subREQMTS:/SAPAPO/SAPLRRP_REQMTS:3000/cntlALV_GRID_REQMTS/shellcont/shell").Text Not sure whether you have experience at this problem, many thanks in advance. BR Wendy
Hi Wendy, sry for the late reply on this. I believe I have replied you via email. But just for everyone's information, you can capture the data in GridView object by using the following syntax: session.FindById("wnd[0]/usr/cntlGRID1/shellcont/shell/shellcont[1]/shell").GetCellValue(rownum, "column name here")
![Automate Data Extraction with SAP GUI Scripting & Excel Macro VBA [english]](/img/1.gif)
I just launched "SAP GUI Scripting: Understanding the Basics" ebook! If you are interested to learn more, check it out in the link below:
joelting.com/sap-ebook/
I'm so happy to see your videos, this type of video is very rare nowadays. You help me a lot, you make my daily tasks quick and easy. Many thanks Joel!
A hug straight from Brazil!
As you mentioned this is by far the best tool to develop gui scripting. Thanks for sharing this!
Thank you very much for this excellent video Joel 😀
Hey Stefan, thank you for commenting! Thanks for developing and sharing such a useful tool with us! 😊
The father of the tool is here!
Hey Stefan, for some reason I don't see the scripting API option when I download it. I see Analyzer, recorder, composer and so but no scripting API, do you know what could be the reason?
Joel, you are the MAN! Big thanks for sharing this with us and giving us a tutorial too!
Hope that it helps! :)
Thank you very much! I did not know this fantastic tool.
Crazy good job!❤
Dear Joel, I am glad you are back! I really appreciate your past videos, and now we can automate simple data extractions.
However, since we have to run various SAP reports, such as KSB1 or 2KEE, with variants already defined in SAP. Is there anyway to run those reports with variant specified in the script? I try to use search function but it is not solving the issue.
Hi there! Are you able to specify the Variant right at the beginning? (under "Layout" field for KSB1 and "Display Variant" field for 2KEE. I think that is the most efficient and error-free way to execute with Variant. Otherwise, selecting it using the search box may expose the script to more potential errors.
Thx alot for sharing & explaining this powerful tool !
Extraordinary video thanks for educating
Amazing ! Thank you so much ❤😳
This is helpful! I am planning to organize my codes for 15 SAP instances. LOL
Wow. That's a lot! Hopefully recording the additional information can help you in managing those instances.
Hi Joel, tks for the tip. I downloaded scripting tracker, but when I use the tracker and go down the tree, it is not going all the way to the elements, it goes only at a level call "shell" and does not go any further, can you help me? Any ideas why this is happening?
Are you looking at a PDF HTML viewer or something? You can try and check the type of the shell to identify what is it and identify what is the method to interact with it.
Hi, Joel. Have you also tried SAP Friori? If yes, is there a counterpart of the pre-installed recorder in SAP GUI for SAP Friori?
Hi there, as SAP Fiori is web-based, I'm not aware of script that works directly from SAP. You may want to explore web browser automation using Selenium if you would like to create automation for SAP Fiori. There's recorder available for that but I have not tested that myself.
Hi Joel,
Thanks for educating.
Am looking for a case where it has to get data of BOM documents and it has to open all the documents.
Could you please make a video on the above requirement?
It would be helpful
Thanks
Hi there, what is the T code do you usually use for that? and the documents are in PDF? Why do we open the documents in the first place?
Thanks a lot for this !, i wonder how to properly automate 2 session ?, is this something you covered before ?
Hi there. I have not covered this before. You need to be clear on what happens on each session and the sequence of each of the steps. You can set up the session by assigning them to 2 different variables. Set session1 = connection.Children(0) and Set session2 = connection.Children(1). Then you should be able to assign each session to perform certain steps (session1.findById("wnd[0]").sendVKey 0 or session2.findById("wnd[0]").sendVKey 0).
Hi Joe, Do you have a video on the step by step tutorial like creation from SAP then I will use Macros to run, also how to set up macros template.I'm using SAP ECC , sample transaction code is ME11. Thanks for sharing the link if you have
Hi there. You can refer to the video below:
ruclips.net/video/ISDX5LwcVPQ/видео.html
It shows you generally how a script can be recorded and modified so that it can be executed in using Excel macro.
Thanks, bro your video is good, I want to ask what's the version of your SAP logon in your video bro?
Hi there. I'm using SAP logon 770 in the video
Hi Joel, scripting is disabled in my organisation. I was wondering if there is another way to incorporate GUI scripts? Maybe using GuiXt which is avaliable? Thanks
Hi there. From my understanding, there is nothing that we can do if it is being disabled. If it is disabled, we will not be able to establish a connection with SAP GUI. I have not used GuiXt before. But based on my short study on it, GuiXt seems to be a program to design the front end of SAP, and not for running scripts or allowing connections to established with programs.
Excelente aporte muchas gracias!!!
Hi Joe,
I want to update SAP data from excel file for tcode MSC2N where I want to update the data for certain material/batches.
I created file to Update MSC2N, but this is for one defined value only and not from excel
Can you please to create excel which can pick data and update MSC2N like Date of Manufacturing, shelf life, vendor batch, country of origin
Hi, let me see what I can do. But for you to get started, you probably just need to record 1 entry to get the base code, then modify the script to use loop to go through every iteration to perform the update.
Hi, can u please advise on How can we record for service for object menu
Hi there, are you facing issue with recording service for object menu clicks? I read somewhere that one of the SAP logon has that issue, but the user reported that the issue went away after updating his SAP logon version
amazing!
Thanks, glad you liked it!
Hi Joel, I am new to your channel. I am simply a person with accounting knowledge and work on SAP manually. Can you give some guidance how I can learn these scripting skills. Would appreciate if you can guide me through your journey and what helped you..
Hi there. My journey began with a strong foundation in accounting, much like yours. To dive into scripting, I started with the basics of programming by learning VBA. You don't need to be an expert, but understanding concepts like variables, loops, and conditional statements is crucial to design and customize your script. Once I understand the basics, I use the script recorder to get all the IDs I need to interact with SAP user interface. With both knowledge, you will be able think of different ways to design and implement scripts to automate some simple daily task. As you get more comfortable, you can start to work on more complex projects which involves a lot of steps. My journey was marked by a lot of trial and error, but the key is to stay curious and keep learning. Best of luck in your learning journey!
I use VBScript also but doesn’t look like the one you’re showing. I’m still on ECC6.0. Are you showing S4 HANA?
Hi Lawrence, yes, this is S4 HANA in the video. But I have used ECC in my previous company, they seems to be working with similar concept.
my scripting tracker is not showing the "Scripting API" part. Can someone help me?
Hi Hugo, can you check your preference under "Customizing" > "Edit Preference File" in the scripting tracker?
Mine has a line
sapfewse = %PROGRAMFILES(x86)%\SAP\FrontEnd\SAPgui
Make sure that sapfewse.ocx is located in that folder.
When i click the button, it shows me only script recorder with 3 buttons
Hi, I believe you are referring to the native script recorder that comes together with SAP. The tool mentioned in the video, the Scripting Tracker requires a download and installation.
Installing programs are mainly not allowed in companies.
Hi there! Yes, you are right. But usually if there's a business case, the IT department will happily help to install the programs required. But of course, that varies between companies.
Should I download the 64-bit or 32-bit version?
Hi there, depending on your operating system. Usually company nowadays comes together with 64-bit.
Hi Joel can you help me, mine isn't working
Hi there. What is not working for you?
In sap S4 hanna cloud how to use record
Hi, are you referring to SAP Web UI?
Tôi có nhiều thông báo nợ cần in trên SAP, có thể in tự động được không ạ?
Are all of them in PDFs? May I know what T code are you using?
unfortunatelly the record button is not recording :(
If the recorder button is not recording, it is very likely that your organization have disabled scripting for end user. Unfortunately if that's the case, there's nothing much that we can do.
@@JoelTing right. I am allowed to run macros. But not to record them. Thanks.
It’s similar nwbc property collector, but in the last upgrade they removed it!! 😂I’ll try this. Hopefully they let me install it
I see. I have not heard of that before. I'll also have a look at this software as well. Thanks!
Hi Joel, this is Wendy and i must say your SAP/VBA videos are really helpful and i am able to do SAP automatically!!
Just a quick question , when i tried to extract the data of one specific cell of SAP APO module to excel, it could not be completed with number i wanted. It shows "SAPGUI.GridViewCtrl.1" even i tried several times with different ways...the code i use is below: session.findById("wnd[0]/usr/subREQMTS:/SAPAPO/SAPLRRP_REQMTS:3000/cntlALV_GRID_REQMTS/shellcont/shell").currentCellColumn = "EXTRA"
session.findById("wnd[0]/usr/subREQMTS:/SAPAPO/SAPLRRP_REQMTS:3000/cntlALV_GRID_REQMTS/shellcont/shell").PressEnter
Cells(currentline, 6).Value = session.findById("wnd[0]/usr/subREQMTS:/SAPAPO/SAPLRRP_REQMTS:3000/cntlALV_GRID_REQMTS/shellcont/shell").Text
Not sure whether you have experience at this problem, many thanks in advance.
BR
Wendy
Hi Wendy, sry for the late reply on this. I believe I have replied you via email. But just for everyone's information, you can capture the data in GridView object by using the following syntax:
session.FindById("wnd[0]/usr/cntlGRID1/shellcont/shell/shellcont[1]/shell").GetCellValue(rownum, "column name here")