Hi everyone, If your encountered syntax error, be sure to check if your recorded vbscript contains % symbol. Make sure you substitute % with %% for it to work.
Hello again....our SAP is set to automatically stay open when we export Z tables. If you have access to z tables I would love to see a demo how to get the excel file to close to create a flow using the sap VBA script. I can only run the script right now I'm having an issue incorperating with excel it saves as an HTML file. Appreciate any feedback. I export many inventory variant/ layouts daily ...then run the export export through a power query connecton to generate final reports
Hello Lisa. Do you mean after the export, it gets stuck because your excel file stays opened? Since you would know what name will be the Excel file when you are exporting, you can try using "Attach to running Excel" action to create an Excel Instance. After that step, use the "Close Excel" action to close the instance that was created in the previous step. If you are running the export through Power Query, you can have Power Automate to open the workbook and run a Macro which will automatically refresh the data sources.
hi joel! thank you so much for doing this tutorial. i did the same thing. when i try executing the attach the running file, it doesn't recognize the title "worksheet basis (1)" and i get an error.
This is sick bro. Didnt even realise there was a macro recorder in SAP and the fact you can link it to Power Automate is very clever. I can think of so many ways where this could be used. Brillinat stuff!
Hello Joe, First of all thank you for your videos i had learned a lot! is there any way to run a script that add data to a transaction? not only extract information?
Hi Sebastian Vaazquez, yes, you can definitely run script to add data, and using loops, you can do it in bulk. it should be of similar procedures, identifying the SAP element in SAP GUI and changing those with your variable so that you can do bulk inputs. I have been wanting to work on a video on this. Problem is, I do not have access to those T-codes which allow for data input. So I'm unable to test it out. I'm trying to work on having a subscription for the full system for SAP.
Hi Bruna, thanks for your comment. As of now, there's no trigger for Power Automate Desktop. After you have created and tested a desktop flow, you can add it to an automated flow in Power Automate (cloud) and setup your trigger there.
Hi Joel, Are you planning on doing more Power Automate Videos? This one is amazing and it helped me to bring Power Automate to my workplace. So your video is responsible that I am now the key User for Power Automate in a Company with more than 4000 employees. We already automated tasks which would need hundreds of hours manuel work every day. So you had a huge impact with this video and I hope to see more of you :)
Hi Dennis. Thanks for your kind words. I'm really happy that this video helped you in some ways. Apologies for not uploading any videos for the past few months as I had been quite busy with my current role in my company. I'll try to upload more videos consistently. I have just posted a video about automating the SAP logon process prior to running the scripts and how to handle your username and password securely. Feel free to check it out. Hopefully it will compliment the process that was explained in this video. Thank you once again for your support.
This is amazing. Thank you, Joel, for your kindness in sharing this with us! I'm new to Power Automate and am looking forward to automate my SAP data extraction like the one you did.
Great training. I liked it very much. I put it into practice. I had sytnatx error in the code, I found the solution on the Internet. Just double the "%" sign.
Hi there. I have a video talking about this, but not sure if it fits what you are looking for. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-C_7UD_l-zwA.html
Hi Joel. You did a good job here! Could you help me? I am having scripterror: C:\...\AppData\Local\Temp\Robin\Hgd237as.tmp (2, 4) Null. The script doesn't actually start to run.
If Not IsObject(application) Then Set SapGuiAuto = GetObject("SAPGUI") Set application = SapGuiAuto.GetScriptingEngine End If If Not IsObject(connection) Then Set connection = application.Children(0) End If If Not IsObject(session) Then Set session = connection.Children(0) End If If IsObject(WScript) Then WScript.ConnectObject session, "on" WScript.ConnectObject application, "on" End If session.findById("wnd[0]").maximize session.findById("wnd[0]/tbar[0]/okcd").text = "zbpr_d035" session.findById("wnd[0]").sendVKey 0 session.findById("wnd[0]/usr/btn%%_SP$00004_%%_APP_%%-VALU_PUSH").press session.findById("wnd[0]/usr/ctxtSP$00001-LOW").text = "%Selectedday%.%Selectedmonth%.%Selectedyear%" session.findById("wnd[0]/usr/ctxtSP$00001-HIGH").text = "%Selectedday2%.%Selectedmonth2%.%Selectedyear2%" session.findById("wnd[0]/usr/ctxtSP$00004-LOW").text = "BRC0" session.findById("wnd[0]/usr/ctxtSP$00004-LOW").setFocus session.findById("wnd[0]/usr/ctxtSP$00004-LOW").caretPosition = 4 session.findById("wnd[0]").sendVKey 0 session.findById("wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,1]").text = "BRP0" session.findById("wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/btnRSCSEL-SOP_I[0,2]").setFocus session.findById("wnd[1]").sendVKey 8 session.findById("wnd[0]/usr/btn%%_SP$00012_%%_APP_%%-VALU_PUSH").press session.findById("wnd[0]/usr/ctxtSP$00011-LOW").setFocus session.findById("wnd[0]/usr/ctxtSP$00011-LOW").caretPosition = 0 session.findById("wnd[0]").sendVKey 0 session.findById("wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,0]").text = "ZUVI" session.findById("wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,1]").text = "ZURG" session.findById("wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,2]").text = "ZRB1" session.findById("wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,3]").text = "ZNOR" session.findById("wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,3]").setFocus session.findById("wnd[1]/usr/tabsTAB_STRIP/tabpSIVA/ssubSCREEN_HEADER:SAPLALDB:3010/tblSAPLALDBSINGLE/ctxtRSCSEL-SLOW_I[1,3]").caretPosition = 4 session.findById("wnd[1]").sendVKey 8 session.findById("wnd[0]").sendVKey 8 session.findById("wnd[0]/tbar[1]/btn[7]").press session.findById("wnd[1]/usr/subSUBSCREEN_STEPLOOP:SAPLSPO5:0150/sub:SAPLSPO5:0150/radSPOPLI-SELFLAG[1,0]").select session.findById("wnd[1]").sendVKey 0 session.findById("wnd[1]").sendVKey 0
@@piracheco I have tried running this script in my system and it seems to be engaging with SAP appropriately and it is able to enter "zbpr_d035" into the taskbar. So the script looks to be working fine. May I check with you: 1) Are you connecting to SAP using Citrix? 2) Is your SAP GUI already open prior to running the flow?
Hi. Good. I have used background with schedule and running with selected variant and layout. And every morning goto SMX and download. Finally I found way to automate download by LSMW and create TCode for that and scheduled. I have tried in my QAS server. It's works. Only condition if XLS it has limited row and colours only downloaded. To avoid that i have downloaded in the .TXT file. I have done those process to avoid SAP connector to my Qlik BI. In Qlik i have created cleansing APP to remove noise of the data like page breaks, header and fooders. Now cleansed data ready to my Qlik sense BI.
Hi Jayasri, thanks for watching. I'm not very familiar with LSMW and Qlik BI. I do not have access to LSMW. The access I had is only the T codes that I used for generating reports. After the extraction, usually the data will be fed to my Power BI workflow for data cleansing. I believe LSMW may lead to a more efficient data extraction process. Thanks for your insights. 🙂
@@JoelTing thankyou friend. Actually LSMW is the Tcode upload the data to SAP may be called as data migration from legacy to SAP. But i was found that and created LSMW for TCode SMX. This will do my manual download work as per scheduled timing. Aby way thankyou for your KT.
i am grateful. I created this one button in my excel which extract from SAP and copy&paste to excel...when i looked at my colleague's template, it seemed like very complicated coding skill hahahaha in the end, that was not the case
Hi Degi Gerel, hahaha yes! I'm not seasoned coder as well. I just make the script simple to fulfill my own personal use to save time and I had a lot of fun trying to play around with it.
Wow amigo this is really awesome!!! i got some ideas for my daily work to test it and implement it. Thanks for this Great tips if you happen to share some other scenario we would really appreciate it!!!!
Can Power Automate online perform same thing? I cannot find the action section listed in your left screen as selection when using online version and our company doesn't have desktop version. Thanks!
Hi Angela. Thanks for watching. No, Power Automate Online is not able to perform the same thing. The cloud version uses API to interact with different applications. Power Automate Desktop interacts with the SAP user interface directly without going through API. Power Automate Desktop and the cloud version serves different purposes in the automation process.
Subscribed bro. I am also in MNC and doing monthly reports and my boss give me via email the SAP extracted excel file as "Databases". I need to do alot of manipulation of these extracted "Databases" to fill in various other files. Seems like this RPA gives me an idea on how to start simplying my tasks.
Hello. You can schedule with the cloud version of Power Automate, start off with a scheduled cloud flow and use the action "Run a flow built with Power Automate Desktop". However, do note that this requires you to purchase a license to use as this is a premium feature. Detailed documentation can be found in the link here docs.microsoft.com/en-us/power-automate/desktop-flows/link-pad-flow-portal
Hi Joel! Thanks for the video and the knowledge. For auditing purposes, is it possible to include in the automation process, the recording of the extraction? Or maybe extract printscreens of the parameters that were chosen to generate the report? Thanks again!
Hi there, is a log of what is being passed into the script sufficient for the audit purpose? If that's the case, you can create a text file containing the time of running, the different parameters passed in for the script and the outcome of the script (could be the final file path of the export).
Hi Joel, Thanks for your valuable tutorial. I have one question for you. From your video, it means that i have to open SAP before i start the PowerAutomate script. Can we create a PowerAutomate script to open SAP if SAP is not open ? Thanks
Hi poor mong. Thanks for watching! From my understanding, that's possible. You can simply use the run application block to start the SAP front end application and run the script accordingly. The main concern for me is that if you are storing your login details (username & password) in the script in plain text, it would raise some security concerns. I hope that answer your question.
Will this work with sap s4 hana? Secondly, for this to work do you need a gui session already running? Can we configure this to open a sap session as well so the extraction runs even on weekend.
If SAP S4 HANA is running via SAP GUI rather than a browser, it should function similarly. Regarding your second question, in this example, the GUI session is already active. However, you can launch a SAP session using the command line (credentials required), wait for the window to load, and then execute the script.
What about access automation? does SAP let you automate that step? Not on my experience, then you need to use blueprism and provide credentials or to use SIMPLEMENT, Right ?
Hi Daniel, access automation may be done via sapshut.exe. In my experience, this way will not work if the organisation is using Single Sign On (SSO). And yes, credentials will need to be provided which can be dangerous to store in text format. Not sure if the following will help, I had a video showing to do it in a more secure way using Power Automate and Azure Key Vault just for your reference. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-C_7UD_l-zwA.html
Dear Joel, when i try to automate project actuals (CJI3) - Sap is giving a save as pop up when extracting to excel. This reports doen not auto open in excel. Doe you have a work around for reports that does not auto open in excel?
Hi there, usually when it is a save as pop up, then most likely you are saving it in a different format (XLSX format). To change the format, you can right click on the table you are exporting, then click on spreadsheet. It should give you a variety of file type to choose from. The file type used in the video is in XXL format. If you are saving in XLSX format, you should be able to record the action of saving the file at a specified path. Then, you can just change the specified path accordingly based on the date and time.
This is what i was exactly looking for. Thanks for sharing great idea. Is it possible to add daily time set up? I want to automate this flow works every day at specified time.
Hi there. In the case that you are using Power Automate, you can schedule it using the cloud Power Automate. Then from there, run the Power Automate Desktop via on premise gateway.
Hi I am looking to download report from SAP . I have the script recording option available. But the next step to creat flow in power automate there are different options. I am confused. Can you please help me?
Hi Vaibhav, I believe once you have recorded the script, you can simply copy and paste into Power Automate to run it with the run vbscript block. If you need more advanced functionality like changing the dates for each run, you just need to incorporate variables into your flow.
Hi there. I think it would be still applicable. Each loop will input the same parameters assuming you are running the same script except for the country code field.
And here is that other video I promised ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uEgJLLHBlZU.html This one automatically organizes music album files into their respective and automatically created folder. And it does this for all the alubms. So amazing to see it execute and do it all automatically. Hopefully I have this walk through video for other users and anyone who is interested in Windows Automation. Let me know if you get any questinos that I can help with.
Hi there, yes, it's possible to work with data between both Excel and SAP GUI. You can get data from SAP GUI, and update an existing Excel file, you can also get data from Excel and perform steps using them in SAP GUI.
Hi YugoRr, unfortunately, SAP GUI Script and Power Automate Desktop are automations based on graphical user interface. So they need to rely on the screen that it is working with. As a result, it will at some point of time interfere with your work if you are working on other things while running your scripts/flow on parallel.
Hello Really good.... but what if I get a file where there are many ID from a input file for example 50 different ID and based on those ID I need to extract data, and every day the IDs would be changed, based on the input file we received? Can make a video on such scenarios?
Hello Adarsh, noted on that. That is possible to be done. I will try to make a video on this soon. Just a brief overview of what can be done, in the flow you can use copy cells from Excel worksheet action to copy it into the clipboard (assuming the IDs are in 1 Excel column), and paste it over using "Shift + F12" (Upload from clipboard) in SAP. You should be able to record what is the script for that specific action.
@Ajay Kumar One example I have is below, session.findById("wnd[0]/usr/tabsTABSTRIP_SELBLOCK/tabpSEL_00/ssub%_SUBSCREEN_SELBLOCK:PPIO_ENTRY:1200/ctxtP_SYST1").text = "xxx" The script above is generated by SAP with their recording function. However, to utilise it in Power Automate, you need to switch it to the following. session.findById("wnd[0]/usr/tabsTABSTRIP_SELBLOCK/tabpSEL_00/ssub%%_SUBSCREEN_SELBLOCK:PPIO_ENTRY:1200/ctxtP_SYST1").text = "xxx" Hope this clarifies.
Hi Joel, After Run VBScript, attached to running excel (Document name: EXPORT.XLSX) I got an error saying Excel document 'EXPORT.XLSX' not found. Do you know why? If I remove attached to running excel step then just run the SAP script, I will get the excel spreadsheet open without problem.
Hi there, it happens to me usually when the export is larger takes slightly longer to load in Excel. One workaround is to put in a wait block to wait for the Excel to open and focus 1st before running the attach block.
Hello Joel, we are not allowed to use SAP script function. So i try use Power Automate to run report but Power Automate unable to detect many fields in SAP GUI 🤔 any idea?
Hi Lilian, unfortunately, based on my understanding, Power Automate UI element don't work with SAP GUI. I can record the desktop flows, but if I run it again, it will not recognize all the elements that was previously recorded.
I have recently got a requirement where we have to create a PAD Bot which can interact with SAP Application. But, I have few doubts in it as I am very new to PAD. 1) My Bot will run on Windows Server 2019 and trigger action will be : When an email is received in Email Box. So, Let's say one of flow instance is already running and it has Open the SAP App and started to mimic the manual process. At the same time another mail comes up so my flow will trigger again. But the first instance is still not finished How we will overcome from this ? 2) Is there anything like Multi Bot Architecture in PAD ? 3) There is one condition where we have to for 24 hours and then check Email is responded or not . How can we do this And 24 hours wait time is suggestable or not ? Thanks in advance !
Hi there. 1) From my understanding, only one flow will be running when using attended desktop flows. So the flow should be executed in queues. Your trigger should be coming from the cloud version of Power Automate I assume? 2) I'm not too familiar with the implementation of Power Automate Desktop. I'm usually more on the user side, trying to create automation to save some time in my processes. I believe I'm not the right person to answer your question in this case. 3) I have not done something like this before. Just my thoughts, you can try in Power Automate cloud, using the delay block and set it up for 24 hours, then subsequently use the get email block for outlook to check if there's any email incoming from specific address or which subject that you are looking at. I have not tried this personally. It needs to be tested to see if it will work.
Hi TinsterPSU, no SAP ERP Connector is required. This is using visual basic, which essentially involve controlling the UI (just like how users type and click). Usually if connector is involved, data can be extracted even more easily with parameters
Hi there. I think for a quick and easy solution, you can try to have a folder sync with the sharepoint site folder. Then just save it in that synced folder and it should automatically be uploaded.
Hi Luis Harms, Thanks for watching. I'll try to work on SQL DB automation with Power Automate soon. Sorry for the late reply. Had been busy with some other projects.
Hi Javier. Yes you can. Just start with reading the information/values in Excel, then pass it into the script as a variable, like how we did with the date in the video.
Hi there. Is it possible that the Excel took quite some time to load? There are other alternatives that can be considered to make it work if this specific use case is not working for you.
Hi Nestor, that's not possible if you are looking for automated interaction within SAP GUI. It needs an operating system installed with SAP GUI to act as the intermediaries, that's why PAD is required. Usually, tasks that can be performed on the cloud Power Automate involve setting up triggers and delivering data to the app you desire. Imitating actions on the user interface needs Power Automate Desktop to work.
hi great video! I have managed to download an excel file using your steps. But now I would like to filter the data from that excel file and then copy and paste it into another excel file. Would u have any clue on how to do this? I previously tried to record the filtering process on SAP on VBscript but it would show a syntax error Thanks in advance!
Using the filter in SAP is possible but may be complicated as it involves new window pop ups. What syntax error do you encounter? If you are familiar with VBA, you can try to do the extraction first, then use Excel VBA to filter the data, then copy and paste the data. You can use Power Automate to run the subprocedure after the extraction process is done.
@@JoelTing hi thanks for the reply! The syntax error is as you described in your pin comment. However, after substituting to %%, the flow runs normally until the filtering stage where it stops without filtering any data. No error pops up tho
Hi Joel, this is the first video where I was able to follow the steps!! Can you please say what should be the action button in Power Automate when the original SAP report is SAVED in a folder and not just OPENED directly?
Hi there, if you are able to save it in a folder using just by using SAP script, then you don't really need it to be opened and save like in the video. Or do you want to amend something on the report before closing?
Hi there, my understanding is that SAP GUI scripts serve a very different purpose. SAP GUI scripting is mainly for end users to automate some steps that they are already performing in SAP GUI. The end users usually do not have the access to create custom reports themselves in SAP.
Similar to another person below, I have a syntax error with the application object that gets auto generated from the SAP script. The script works perfectly if kicked off directly from SAP, but fails from VBScript function (syntax error points at row 2 below). The other person said their issue was that SAP was in Citrix which is not the case with me. I've read other places that maybe it's because I have a 64 bit system but SAP is 32 bit. Do you know anything about that? Do you run windows/office 64 bit too? Thank you If Not IsObject(application) Then Set SapGuiAuto = GetObject("SAPGUI") Set application = SapGuiAuto.GetScriptingEngine
Hi Radu. Apologies for the late reply. I'm not very sure about that. To clarify on the environment that I'm running on, I'm running Windows 10 64 bit and Office 64 bit.
Hello Joel, I found your video really interensting, while trying to open my report in excel, i got an error message from SAP "The following template is missing: sap_sm.xls". Is it possible to extract using "List/export/spreadsheet" ? I will appreciate your support.
Hi Jose Fernandez, not too sure about the error. If you are able to extract using "List/export/spreadsheet", try and record it then paste it into Power Automate to check if it is working.
Hi, great video, how can I capture the message fron the SAP notificación bar to a variable un power automate? I tried this without success: "%variable%" = sesión. Findbyid("wnd[0]/sbar").Text.
Hi Joselo, to retrieve the text, you need to output it as a variable before the end of the script. variable = session.Findbyid("end[0]/sbar").Text Wscript.echo variable Then your variable will be stored as the output of the "Run VBScript" block (default variable name is VBScriptOutput).
Hi Joel, am not sure if my comments will be read and replied, but I have seen almost all your videos on SAP automation. And was thriller to use these amazing tricks in my daily report extraction task...unfortunately am stuck at one SAP automation task wherein I have to extract the report by going to application server. Each time the data is stored in the server with different name. is there a solution for such cases. even though SAP display the Application Server Path, but it is in graphical format and am unable to export that using scripting. SAP has option to save the displayed Application Server Path in *Unconverted * rich text, *HTML formats😒
Hi there. I'm not too sure how application server works. May I know how the Application Server Path is being displayed? Is it as a text in the status bar?
Hi joel, thanks for posting great video. I have one question when we are using playback option and recording date from calendar the recorded script got change in the date selection. If i want to make it dynamic i am using the variables declares like%selectedyear%....!! And date selection in the recoded script is yy.mm.dd format and its default we can't change from user profile. So how to make it dynamic in power automte please suggest something..!!
Hi, you can try getting the subtext of your selected year or month based on what you need. Then, concatenate them together to achieve the end result you are looking for.
Hi Joel, I am reaching to you via this platform. If you kindly make a video and show us how to automate SAP for GL postings when the excel sheet has more than 500 lines. I have checked your previous videos where you mentioned locating SAPscript but due to shared network at work, it was not possible, any suggestions will be highly appreciated!
Hi Ahmad. Unfortunately, I do not have access to T code for posting GL and thus unable to make similar video. What I can do is to make a video that will post multiple lines from Excel into SAP (data entry) and hopefully you can find something useful. When you were saying you are not able to locate SAP Script, do you mean it's not saved in your local disk? Because that is usually the case
Hi Joel, thanks for sharing with us. I have a Question, is there a way to record script on SAP for multi windows activity in same tcode? i had a case when i recorded the script activity, the recording didn't record and it stopped when i move to other window of SAP, can you give me tips about that ? thanks in Advance !
Hi. Yes, you actually can connect to multiple windows or in SAP terms, I believe you are referring to different session. In that case, you need to assign the different sessions to different variables, then depending on which session that you want to connect to, execute the script accordingly. Below is a quick example: Set session1 = connection.Children(0) Set session2 = connection.Children(1) session1.findById("wnd[0]"/tbar[0]/okcd"_.text = "SE16" session2.findBYId("wnd[0]"/tbar[0]/okcd"_.text = "KO01" So in this case, 1 window will enter SE16 in the navigation bar and the other window will enter KO01 in the navigation bar.
Hi. How to run the script in background. Since i want update Business partner in mass. There is no standard FM or BAPI available for my requirement. So i want to use this step but i want to run in background. How it is possible?.
Hi Vijay Kumar, I believe it can be ran in the background with VBScript. From what I have tested, the SAP window do not need to be in focus when the script is being ran.
Hi Joel, hope you're well. Your video was very insightful, and has helped me a great deal. Everything has worked! I am however facing one snag. I have to rename/delete the file that I selected as the "attaching to running Excel", which I could be saving extra time on. Do you perhaps have any tips for this?
Hey, sorry for the late reply. Perhaps you can try to add a Save Excel action and use the Save document as mode to save it in the folder that you desire?
Hi, I would like to know whether SAP auto logon process (the video you posted after this) can be related to SAP data extraction process. I would like to make a flow which start with auto logon and extract data from SAP. Thank you!
Hi Hisyamuddin Basir, you can enable it by going into Options -> Accessibility & Scripting -> Scripting. However, if your company's IT policy does not provide SAPgui scripting authorizations to end-users, then there's nothing that can be done.
Joel, thanks for the great video One question, how do I use clipboard to copy paste entries in 2 different fields like Company code (100,102)and Period(1,2,3)? I was able to use clipboard for one field, but how do I store period in clipboard at the se time?
Hi MG, you can try to use copy cells from Excel worksheet to copy your first field, then run vbscript to paste from clipboard in SAP.. After that, repeat with the same action again, copy cells from Excel (this will overwrite your clipboard) for the 2nd field and run vbscript to paste from clipboard again in SAP.
Hi Khaled. It's unlikely you will be able to set it up to run in the background entirely. The process can be scheduled using Power Automate Cloud, running the process at a specific timing. The process of logging into SAP can be automated, but it would interrupt the users if they are currently using the system.
Hi Mark, you can get the message box to obtain input from users for the start and end of the period then. Everything that has been selected/input is just passed into the script. In this specific example, what is in this video can actually be changed into just 1 line in the msg box, getting the month and the period in the same step, capturing the input of the user in the "/ format directly.
3 года назад
One question. I'm trying to record how I print some orders. But the UI-button for printing has a different name, because in the window there is the ordernumber mentioned in the window-title. How to solve that? Or how can I handle with different titles in the window?
Hi Rene. Sorry for the late reply. I am not very sure about the printing process from SAP. So far I have not work with Windows UI Automation with Power Automate yet.
Hi Chaitanya. Thanks! I am not very familiar with SAP BAPI/RFC though. I have not work on it before, so I might not be the best person to advise you on this. For Power Apps, I am not sure how that would work to download data from SAP. But personally, I think setting up the data with Power App itself may not be efficient as there's some limitation on how it handles data. That being said, I may be wrong as I have only explored basic functionalities of Power Apps.
Hello Thank you very much for the great tutorial. I have one question, would it be posible with power automate to pull the data extracted and run a excel macro? Thanks.
Hi Carlos. Yes you can, right after the running the script, you can use the run excel macro action to target the extracted xlsx and work on the data. Or better still, you can run the SAP script with VBA/Macro with better control over the sub-process. New video coming up on that very soon.
when i try to save & close the excel , the error message always Argument 'Instance' must be 'Excel instance'.. I follow the same steps per the youtube.
Hi there, can you check if the Excel Instance parameter under close Excel is mapped to the output of Attach to running excel. The output should be the one that you reference to it.
Hi Vinay Kumar, I think you can. Theoretically, you just need to have the script to extract different reports one after another, then combine them either by working on it via actions in Power Automate, or triggering a macro that was previously prewritten to combine the reports that you have mentioned.
Hi Leafy, sorry for the late reply. I think the extraction process is similar as long as it is using SAP UI. Just got to be clear with the steps and design the process with either Power Automate or with VBA.
Hello. You can schedule with the cloud version of Power Automate, start off with a scheduled cloud flow and use the action "Run a flow built with Power Automate Desktop". However, do note that this requires you to purchase a license to use as this is a premium feature. Detailed documentation can be found in the link here docs.microsoft.com/en-us/power-automate/desktop-flows/link-pad-flow-portal
Hi there. SAP GUI Script is based on SAP GUI and require a user interface to run (can be virtual machines). This is useful for end users who need to automate certain processes without IT intervention. Power Automate web may be used to execute the Power Automate Desktop flow, but it cannot run GUI script on its own. If you have credentials and access to SAP database/API, you may try that, but I'm not too familiar with that.
@@JoelTingHi, I do have credentials and access to SAP database, and I would like to prepare dashboards based on SAP reports through excel or Power BI. Could you please help to prepare an automated process to run reports to be able to visualize them.
Hi Denny, would you be able to apply similar concepts on ME5A? I'm not very familiar with ME5A. So, I'm not in a position to advise. However, usually for SAP scripting, as long as human can click and do it, it can be done.
Hi, it really depends on how you structure your script. Variables can be passed in based on what you want (Maybe you can set it up from period 1 to 12 for example), it will be different depending on your requirement.
Hi Joel, thanks for this awesome tutorial. Just wanted to ask, can this work for someone else's SAP software, which is running on a different laptop? It will be great to have a response from you regarding this. Thank you!
hi pukhraj suthar, I have not done that personally before. From my understanding, that's workable as long as you can share the flow with the other person. Usually not much is change is needed.
If you are using Excel, you can try checking my other videos when automating is VBA. It will be of similar concept, just replace the values in the scripts with values read from an Excel cell (by storing them as a variable).
Hi Mandy, you can use the "Display input dialog" action to capture user's input as a text. But one thing to note is that user can input any value in this case. So, if they just input an invalid string and that get passed into the script, it would result in error when the script is being ran.
Hi Joel, Love your videos regarding SAP and POWER AUTOMATE. But I have a question: I m trying to create an automatization for some tasks of mine, I use T-CODE: IW32 and there I should insert the materials, is it possible to add more than one material, to create a FOR loop inside the SCRIPT from SAP? or how do I copy some cells from excel and paste it in SAP ( without the COPY FROM CLIPBOARD button ) Thank you
Hi Madalin, Yes, that's possible. But instead, the for loop in Power Automate should be wrapping the VBScript block. Just read the Excel for the list of materials with "Read from Excel Worksheet", then it would store it in a data table. Use the for loop to go through each value and replace it in the script while executing the script. Hope this helps.
Hi Joel, Yea, that’s actually a great idea. Can you please create an example video for this? If you don’t want to post it for yt( even though i think it will be a hit) you can send it to me via email, of course i will pay you for this, only if you want. I will also try it and i will let you know how it went Greetings
People, trying to discover why my script doesn't work, I run the SAP script without my Power Apps, and it appears a popup saying "an script is trying to access SAP GUI." I tried to put a command in the scrit like "session.findById("wnd[0]").sendVKey 0" for confirming the popup but it doesn't work as well. Can someone help me?
Hi Marcelo, can you try opening SAP GUI Options, then under Accessibility & Scripting > Scripting, untick the 2 options under Enable scripting (1. Notify when a script attaches to SAP GUI and 2. Notify when a script opens a connection) Hope this helps.
Thank you for your very GREAT informative video. However, I am unable to play back the script successfully. 1st. I always get a message dialog box that says "A Script is attempting to access SAP GUI." I would like to have the script automatically select "OK" without intervention. 2nd After I hit OK. I get a message "The control could not be found by id. -". And the script fails. What am I doing wrong? Any help is greatly appreciated.
Hi Steve Johnson, 1) You can click on the last icon of the SAP Menu Bar and click on "Options". Under "Accessibility & Scripting" -> "Scripting", untick "Notify when a script attaches to SAP GUI" and "Notify when a script opens a connection". The message dialog box will be disabled. 2) It seems like it may be that when the script is running, at some point, it is unable to read the field that you have previously recorded. The field that you have identified previously was not there after a series of steps. Do you mind sharing your script so that I can take a look?
@@JoelTing Hi Joel, Thanks for getting back to me. I was to uncheck the boxes and the message went away. As for the script error. I now try to tab to the various fields during the recording and the error has went away. THANK YOU FOR YOUR HELP. Keep up the great work. I look forward to watching more of your very informative videos.
Hi Joel, thank you for the video!! It is very helpful . Have a question, after the loop, when we get the SAP output, is there any other alternative to "Attach to running excel" step ? Iam attempting to work on other excel files, while running the flow and iam hoping to avoid an error, while saving the Worksheet in Basis (1) file.
Hi there. Another workaround may be to change the SAP output into a spreadsheet that you can save the output on a specific path. That way, you can avoid having to deal with Worksheet in Basis (1) file.
@@JoelTing Hi Joel, thank you for the reply. Do you mean recording the output path in Sap script itself, if possible could you please make another video with the above step?
HI Joel thanks to share this with us, a lil bit question. i've recorded from zero inside SAP, when is time to run the script a new windows appear warning me that the script is trying to access to SAP GUI, how could I solve this? again, thanks for sharing your knowledge (and sorry for my bad english xD)
Hi there. You can try to untick the option "Notify when a script attaches to SAP GUI" & "Notify when a script opens a connection" under the SAP GUI options -> Accessibility & Scripting -> Scripting. You can find detailed instruction in the website here. support.winshuttle.com/hc/en-us/articles/360023686491-How-to-Avoid-the-A-Script-is-Attempting-to-Access-SAP-GUI-Message
This is amazing i will give a try today! One question i'm using a TCODE that doesnt have the option to downlad as Excel , i'm trying to automate a simple task which is just search an order# in SAP, go to text box, copy the text box and Paste it on Excel (Column B). I already recorded my script and playback and it Runs as expected but the issue is that it is not Pasting the text box comments in Excel. It seems like the connection gets lost when i do that last step to copy/paste like if the Scrip doesnt identify the Copy/Paste funcion. Could this be because i cannot switch to Excel and paste Data when i'm recording a Script? Do i need to add a declaration in the script code to let it access to Excel and paste the data?
Hi Omar. Yes you are right. The script recording function only works within SAP GUI. Anytime you leave SAP GUI, the action would not be recorded. For your specific step, you may want to confirm if there's an action that is copying the data into clipboard within the script. If there is, right after the script, you can trying using "Paste cells to Excel worksheet" action to paste it over.
@@JoelTing Thank you so much Joel ! i will try to do that, i havent built the project in MPA but i already have the Script in one notepad and it works perfectly with the exception of the Data Paste action at the end. Once i build the project in MPA i will look for the "Paste cells to Excel worksheet" action and hopefully it works ! :) thanks again
Hi Joel, great video and great explanation. Thank you so much. Yet, Even if I can create a new excel file, it comes empty every single time. I tried different script, the result did not change. I assume there can be multiple reason about that but what do you suggest mostly?
Hi Engino, are you exporting with XXL format? or are you exporting into other spreadsheet format? It really depends how you have set up your configuration during your export. If you are exporting in XLSX format, you may even just incorporate the export steps into the vbscript directly without going through the open Excel, save Excel steps.
