SAP GUI Script Development Tool That Will BLOW YOUR MIND

Подписаться 8 тыс.

Просмотров 13 тыс.

50% 1

Get instant access to the eBook "SAP GUI Scripting: Understanding the Basics" and discover how you can transform your SAP work processes, reduce errors, and boost productivity!
joelting.com/sap-ebook/
In this video, I will show you how to use Scripting Tracker to streamline your SAP scripting process. The Scripting Tracker is a powerful tool that helps SAP script developers to easily identify all SAP objects and develop their scripts with ease. With Scripting Tracker, you can extend your existing scripts, record scripts in different programming languages, and enjoy a user-friendly interface that saves you time and effort.
This video guide covers everything you need to know about using Scripting Tracker, from installation and setup to recording and executing your scripts. We also showcase Scripting Tracker's advanced features, such as its powerful recorder, which is more powerful than the pre-installed recorder.
Whether you're an experienced SAP developer or just getting started with scripting, Scripting Tracker is a game-changer that will take your efficiency to the next level.
Download link to the Scripting Tracker:
tracker.stschnell.de/
#SAPScripting #SAPGUIScripting #ScriptingTracker
DISCLAIMER:
SAP® and SAP GUI Scripting are registered trademarks of SAP AG.
I am NOT associated with SAP AG in Germany or any other country. I am NOT SAP Partners. I do NOT offer live SAP Training. I do NOT offer SAP Access. We do not recommend the use of SAP Access from any particular provider.
MY FAVOURITE GEAR
💻 My Personal Laptop, Legion 5 Pro - amzn.to/3nZrn1I
✈️ My Travel Companion, Macbook Air M1 - amzn.to/43jLLuE
📷 My Camera Gear, Sony ZV-E10 - amzn.to/40T7uIj
MY KEY LINKS
🐦 Twitter - / joelting92
🏢 Linkedin - / joel-ting
🙎🏻‍♂️ WHO AM I:
I'm Joel, a Regional Finance Controller working in Singapore. I make videos about technology, automation and productivity.
📧 GET IN TOUCH:
If you'd like to talk, I would love to hear from you. Email me directly at joelting92@gmail.com would be the quickest way to get a response. I will try my best to reply to your email as soon as possible.
P.S. Just a heads up, I receive a kickback from some of the links in this description as they are affiliate links 😜

Наука

Опубликовано:

7 апр 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 60

@JoelTing Месяц назад

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/

@user-tl2tb4yj2c Год назад

As you mentioned this is by far the best tool to develop gui scripting. Thanks for sharing this!

@stschnell Месяц назад

Thank you very much for this excellent video Joel 😀

@JoelTing Месяц назад

Hey Stefan, thank you for commenting! Thanks for developing and sharing such a useful tool with us! 😊

@Obknob Год назад

Joel, you are the MAN! Big thanks for sharing this with us and giving us a tutorial too!

@JoelTing Год назад

Hope that it helps! :)

@luca75tubo Год назад

Thank you very much! I did not know this fantastic tool.

@naiduvikas202 Год назад

Extraordinary video thanks for educating

@chendatenni9316 Год назад

Amazing ! Thank you so much ❤😳

@flaurent1208 9 месяцев назад

Crazy good job!❤

@yekoya Месяц назад

Thx alot for sharing & explaining this powerful tool !

@toshimmm Год назад

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.

@JoelTing Год назад

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.

@gabrielassuncao7588 Год назад

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!

@davidnatera8923 Год назад

Excelente aporte muchas gracias!!!

@carlomamarilagda Год назад

This is helpful! I am planning to organize my codes for 15 SAP instances. LOL

@JoelTing Год назад

Wow. That's a lot! Hopefully recording the additional information can help you in managing those instances.

@Back1Ply Год назад

Thanks a lot for this !, i wonder how to properly automate 2 session ?, is this something you covered before ?

@JoelTing Год назад

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).

@shameerm1232 Год назад

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

@JoelTing Год назад

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?

@lakshyagupta552 9 месяцев назад

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..

@JoelTing 9 месяцев назад

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!

@muhammadjanuar4230 5 месяцев назад

Thanks, bro your video is good, I want to ask what's the version of your SAP logon in your video bro?

@JoelTing 5 месяцев назад

Hi there. I'm using SAP logon 770 in the video

@carlaarenas6537 10 месяцев назад

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

@JoelTing 10 месяцев назад

Hi there. You can refer to the video below: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ISDX5LwcVPQ.html It shows you generally how a script can be recorded and modified so that it can be executed in using Excel macro.

@laradanicalim3954 10 месяцев назад

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?

@JoelTing 9 месяцев назад

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.

@aewcontrol2984 3 месяца назад

It’s similar nwbc property collector, but in the last upgrade they removed it!! 😂I’ll try this. Hopefully they let me install it

@JoelTing 3 месяца назад

I see. I have not heard of that before. I'll also have a look at this software as well. Thanks!

@ninobogaerts5781 Год назад

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

@JoelTing Год назад

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.

@HenriqueGalvao10 3 месяца назад

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?

@JoelTing 3 месяца назад

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.

@lawrencechung6529 Год назад

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?

@JoelTing Год назад

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.

@Kashi_Gujjar_ Год назад

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

@JoelTing Год назад

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.

@gssalian1 Год назад

Hi, can u please advise on How can we record for service for object menu

@JoelTing Год назад

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

@hugomiranda5367 Год назад

my scripting tracker is not showing the "Scripting API" part. Can someone help me?

@JoelTing Год назад

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.

@mathijs9365 Год назад

Installing programs are mainly not allowed in companies.

@JoelTing Год назад

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.

@jahyungchung9732 Год назад

When i click the button, it shows me only script recorder with 3 buttons

@JoelTing Год назад

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.

@CP-zb3ky Год назад

Should I download the 64-bit or 32-bit version?

@JoelTing Год назад

Hi there, depending on your operating system. Usually company nowadays comes together with 64-bit.

@sriram8800 Год назад

In sap S4 hanna cloud how to use record

@JoelTing Год назад

Hi, are you referring to SAP Web UI?

@SportsLuckyLeeAnh Год назад

Tôi có nhiều thông báo nợ cần in trên SAP, có thể in tự động được không ạ?

@JoelTing Год назад

Are all of them in PDFs? May I know what T code are you using?

@johnarkdelossantos9406 3 месяца назад

Hi Joel can you help me, mine isn't working

@JoelTing 3 месяца назад

Hi there. What is not working for you?

@redds7 Год назад

unfortunatelly the record button is not recording :(

@JoelTing Год назад

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.

@redds7 Год назад

@@JoelTing right. I am allowed to run macros. But not to record them. Thanks.

@user-zx7oe5uy8w Год назад

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

@JoelTing Год назад

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")