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 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.
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!
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.
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.
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.
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.
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!!!!
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 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).
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. 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.
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 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.
Excellent tutorial, very straightforward. I was able to automate the Spreadsheet I needed and then link it to PowerBI. My only issue is that I can't seem to update the file. Everytime I ran the program I always get the same information (from the day I first created it). Even when I use the date selector I get the same result. I have edited the scrip to follow the date DD.MM.YYYY that I input when I run it, but still it always pulls the information of the same date 03.10.2023, which is the day I created the script. Any advice?
So it's like the .export file is always the same, and the file I create it's always only a copy of that export file, the data does not update with the date
Hi Eric, you can try going through step by step to debug what went wrong. Ie. is the date being input correctly captured and passed into the script? Is there something overriding the variable before it is being passed into the script?
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 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.
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.
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.
Hi Joel - your videos are truly amazing and has great content for learning. I did a flow in SAP GUI 750 to modify data in fields using populate text function. But sometimes due to the speed of net the flow continues without the action being actually performed in SAP and this gives error. Which option do i need to choose to ensure the previous steps are completed before the flow can move to the next one. Many thanks and do keep uploading your valuable videos. Cheers!!!
Hi Freeshavacadoo. May I understand from you if the text are populated within the script or you are using the action in Power Automate to "type in" the text? If it is being populated using the script, it should eliminate the error that is caused by timing issues.
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.
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, 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, 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?
And here is that other video I promised th-cam.com/video/uEgJLLHBlZU/w-d-xo.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.
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.
Hello Renzo! Yes, It's possible to include login in SAP but it really depends on how the login is configured. Some company uses the default SAP login, which is much simpler to automate. If it's involves Single Sign On, then things gets a little more complicated. It's doable, but it might break.
Thanks Joel for sharing this useful information. Does it mean the SAP has to be log on before the script can execute? What if SAP is not log on, can we automate the SAP logon? Thanks
Hi Kia Ming, in the video, it has already been logged on. Based on my understanding, It is possible to automate the logon by starting to record the script before you login, and run the script as a vbscript block. However, you may want to be aware that the username and password are passed in as a string, which may pose a risk of exposing your credentials. I personally have not done it before but I found 1 potential way to mitigate the risk is using Azure Key Vault. You can check out the video in the link below for using sensitive text in Power Automate: th-cam.com/video/gpgcH0hxIAc/w-d-xo.html
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.
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 XSessive, thanks for your suggestion! However, I have no access to the SA38 T-code currently in my company and therefore unable to work on the demo.
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.
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 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.
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 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 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, 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!
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 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.
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.
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. th-cam.com/video/C_7UD_l-zwA/w-d-xo.html
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.
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.
hey i am encounter a problem in attach to running excel step. (i saved by document with export12345), copy paste the same in the Attach excel step. But getting this error (Make sure that no Excel file is currently being edited or blocked by a pop-up dialog. Also, make sure that the target Excel file has not been opened in Protected View.)- i dont have any other file opened, File alsways get open in editing mode(i dont have to press editing to make chnages) Please guide . Thanks in advance
Hello! Is it possible to output your table as a txt file instead? I found that using txt file would eliminate the complications of working with Excel file output.
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 Sunil, I believe there is no SAP licensing implications because it is using the same logon as what the user is using. Essentially, the script is just imitating what you are doing and you are using the same SAP session or instance.
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.
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 Joel, thanks for very good tutorial, it helped me alot. Just one question, my SAP script stops at save file as excel window and i have to manually choose to save file. Can it be done in a similar way as you did when I click on spreadsheet button in SAP.
Hi Vasil Baig, if you would like the spreadsheet button to open up Excel, you would need to change the default format it is exported to. For the example in this video, it is exported as ".XXL", while yours should be another format. To change it, you can right click anywhere in SAP table, then click on spreadsheet. SAP should give you a choice to choose the format option to be exported.
Joel, I am facing one issue, report is extracting with file name worksheet in basis (1), but the layout and data which is extracted is not the same which I have chosen in SAP.
@@m_vab The format .XXL will change the layout of the data. If there's filter for your SAP table, it would be ignored as well. If having the layout and filters exported to Excel to be exactly the same as SAP is important for you, I think you should go ahead with .XLSX, saving the file in one location and open it manually. In my latest video, I recorded a script, exporting it with XLSX format. Feel free to check it out and I hope that can solve some of the problem that you are facing. th-cam.com/video/ISDX5LwcVPQ/w-d-xo.html
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 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
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
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 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.
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 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 Joel, Firstly, thank you for your great video! Though I have a question about VBA. I copied exact same way as you shown in your video, but my SAP didn't even react a little. Power Automate flow cannot trigger to my SAP at all. Do you have any idea for this problem?
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
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 Joel thank you so much. It worked. I'm so very greatful for your help!!!
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.
That`s insane man! Thank you very much, I was almost about to give up
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 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.
Amazing. I'm new on Power Automate too. This is an amazing vídeo
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!
Me too so many possibilities...less monkey job more clever work
But it seems like the Script Recorder is deactivated for me 😥
@@patriks.7815 Same with me, does anyone know how to activate it?
Admin role can open
Wow, just wow. The possiblities ... I am blown away.
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.
I really like your video regarding power automate desktop, and I think other people too.
I hope you can keep creating it if you have time !
Amazing delivery - simple, concise and well executed! Thank you Joel
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.
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.
just what i was looking for, you should make also a video on how to auomate the logon experience on sap with PA
Hi there. I have a video talking about this, but not sure if it fits what you are looking for.
th-cam.com/video/C_7UD_l-zwA/w-d-xo.html
Wow this is awesome, but so above my non-tech brains. I'll need to watch it perhaps at least a hundred times before I'll get it all :)
Was looking for a second bell icon to double subscribe. Fantastic use case; great Job!
Joel, thank you so much for sharing your knowledge with us. The universe will see the good you are doing!!!
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.
You can record your manipulation actions on Excel. Read about "Excel Macros and VBA" it will solve your problem.
Thanks for this video and detail narration on SAP and power Automate features. Its Brillant
Love this video, greetings from Spain! Keep working on this channel, your content is gold!
Muchas Gracias!
This is a very good summary! Much appreciated
Great Work. Can you show how to get data from SAP to Power BI
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!!!!
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?
Good work!! Thanks, you resolved my problem!
This is awesome. Thank you so much for taking the time to share your knowledge
It is my pleasure. Thanks for your kind words.
You are an excellent tutor, sir. Thank you for the video!
Glad it was helpful!
Muchas gracias 🥹🥹🥹 lo pude hacer y ahora me encanta power automate
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).
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.
Thanks for the nice tutorial! It is easy to follow and helped me a lot.
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.
Hi Joel,
Thanks for the usefull tips.
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?
amazing video. I am wondering if there is anyway to run the script in background without need to log in SAP ( background job ) in daily timing
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.
Excellent tutorial, very straightforward. I was able to automate the Spreadsheet I needed and then link it to PowerBI.
My only issue is that I can't seem to update the file. Everytime I ran the program I always get the same information (from the day I first created it). Even when I use the date selector I get the same result. I have edited the scrip to follow the date DD.MM.YYYY that I input when I run it, but still it always pulls the information of the same date 03.10.2023, which is the day I created the script.
Any advice?
Also, I don't see SAP running automatically when I execute my flow. It's like nothing is happening.
So it's like the .export file is always the same, and the file I create it's always only a copy of that export file, the data does not update with the date
Hi Eric, you can try going through step by step to debug what went wrong. Ie. is the date being input correctly captured and passed into the script? Is there something overriding the variable before it is being passed into the script?
You are the greatest! Thank you very much. Really useful.
Gracias, muy buen video. Se abren grandes expectativas para automatizar algunos procesos.
You are great! Great solution 👍.
Excellent video. Thank You!
Glad you liked it!
Thanks for the video. Could be done in the opposite direction? I mean, read values from Excel and send to SAP througt script
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.
@@JoelTing ok, thanks. I will try
Thank you for sharing this.
Hola es posible hacer otro ejemplo con SAP , pero que inserte información ,gracias compañero por el vídeo.
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.
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.
@@JoelTing Thanks a lot for your clarification👍👍
Thanks for the nice tutorial!
great job....im doing it with vbs directly and task scheduler, but this looks much profesional...i bookmarked this!
Hey Javier Perez. Thank you very much and nice to meet you! 😀 Warmest regards, Joel Ting
very informative, thank you
Excellent. Thank you for the vídeo.
I love you Joel!!!
Great Video Joel Ting :) Do we have any option integrating SAP BAPI/ RFC to upload or download data from SAP via Power apps ?
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.
Hi Joel - your videos are truly amazing and has great content for learning. I did a flow in SAP GUI 750 to modify data in fields using populate text function. But sometimes due to the speed of net the flow continues without the action being actually performed in SAP and this gives error. Which option do i need to choose to ensure the previous steps are completed before the flow can move to the next one. Many thanks and do keep uploading your valuable videos. Cheers!!!
Hi Freeshavacadoo.
May I understand from you if the text are populated within the script or you are using the action in Power Automate to "type in" the text? If it is being populated using the script, it should eliminate the error that is caused by timing issues.
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.
@@JoelTing That was my problem! I did not notice that the format you used in the video. Now, it's working. Thank you so much!
exactly what i want! thank you so much
This is nice! Thanks and subscribed!
Thanks for the sub!
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 Joel Great video! question: is there a way to add the option to download all months and all years to downlaod a full report formthe same flow?
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.
I'm looking forward to trying this
OMG... SO SO SO SO Thank you.... It really helped a lot.
Hey Lee Jason. Glad that I'm able to help 🙂
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?
And here is that other video I promised th-cam.com/video/uEgJLLHBlZU/w-d-xo.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.
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.
Hello!
This is amazing. I have a question: There is a way for including the login in SAP in the flow?
Hello Renzo!
Yes, It's possible to include login in SAP but it really depends on how the login is configured. Some company uses the default SAP login, which is much simpler to automate. If it's involves Single Sign On, then things gets a little more complicated. It's doable, but it might break.
@@JoelTing Possible to show us how to use default login in flow?
Great video
Thanks Joel for sharing this useful information. Does it mean the SAP has to be log on before the script can execute? What if SAP is not log on, can we automate the SAP logon? Thanks
Hi Kia Ming, in the video, it has already been logged on.
Based on my understanding, It is possible to automate the logon by starting to record the script before you login, and run the script as a vbscript block.
However, you may want to be aware that the username and password are passed in as a string, which may pose a risk of exposing your credentials.
I personally have not done it before but I found 1 potential way to mitigate the risk is using Azure Key Vault.
You can check out the video in the link below for using sensitive text in Power Automate:
th-cam.com/video/gpgcH0hxIAc/w-d-xo.html
@@JoelTing got it, thanks Joel!!
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.
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.
awesome, need more videos like these, like for example mas uploads on SA38 t code
Hi XSessive, thanks for your suggestion! However, I have no access to the SA38 T-code currently in my company and therefore unable to work on the demo.
bro I am using oracle instead of SAP. can you think of some ways to do it on oracle. that would help me a lot!!
Hi Joel, as i have various country codes to use but keeping the other parameters the same. Is the loop function applicable in this case?
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.
What!!!! SAP can do this?! What!!! We can link it to Power Automate?!
Loved it..!
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.
@@JoelTing 20 seconds wait block works for me, thank you for helping :)
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.
Fantastic!
Hi Joel, thank you for the video. I have a simple question. Is there daily auto flow play in Power automate desktop? I couldn't find how to do that..
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
Can you add a video with SQL DB automation?
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 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.
can you suggest how to auto export SAP dump at excel, click on refresh button
Hello! You can use VBA to achieve that. Have some SAP script written to export the data, then use the RefreshAll method to refresh your pivot tables.
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!
Yes. What you need to do is login to SAP using the steps in the SAP logon process, then start the extraction flow with vbscript.
excelente video, podrías hacer un ejemplo pero para insertar información a SAP
Thanks for your suggestions, I'll try to work on it :)
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.
@@JoelTing Hi Joel thanks for your responce, so the variables should be on Power automate or in the Script?
Very Nice !!
Hi Joel, if I want to get the period range such as from Jan 2020 to Mar 2021 what command do I need to change in Message box?
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.
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.
@@JoelTing thx for ur response, exactly what I am facing now 🤔 but IT deems SAP script as a risk hence do not allow it. Sigh.
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. th-cam.com/video/C_7UD_l-zwA/w-d-xo.html
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.
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.
hey i am encounter a problem in attach to running excel step. (i saved by document with export12345), copy paste the same in the Attach excel step. But getting this error (Make sure that no Excel file is currently being edited or blocked by a pop-up dialog. Also, make sure that the target Excel file has not been opened in Protected View.)- i dont have any other file opened, File alsways get open in editing mode(i dont have to press editing to make chnages) Please guide . Thanks in advance
Hello! Is it possible to output your table as a txt file instead? I found that using txt file would eliminate the complications of working with Excel file output.
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, does it have any SAP licensing implications if we use Power Automate Desktop with VB Script as shown in your video? SAP license Audit?
Hi Sunil, I believe there is no SAP licensing implications because it is using the same logon as what the user is using. Essentially, the script is just imitating what you are doing and you are using the same SAP session or instance.
@@JoelTing thanks Joel for a very quick response.
Hi Joe, how to revise the script to let the user input the period freely instead of selected from the message box?
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.
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 Joel, thanks for very good tutorial, it helped me alot. Just one question, my SAP script stops at save file as excel window and i have to manually choose to save file. Can it be done in a similar way as you did when I click on spreadsheet button in SAP.
Hi Vasil Baig, if you would like the spreadsheet button to open up Excel, you would need to change the default format it is exported to. For the example in this video, it is exported as ".XXL", while yours should be another format.
To change it, you can right click anywhere in SAP table, then click on spreadsheet. SAP should give you a choice to choose the format option to be exported.
@@JoelTing Thanks Joel, you helped me resolving this issue. 👍
Joel, I am facing one issue, report is extracting with file name worksheet in basis (1), but the layout and data which is extracted is not the same which I have chosen in SAP.
@@m_vab The format .XXL will change the layout of the data. If there's filter for your SAP table, it would be ignored as well.
If having the layout and filters exported to Excel to be exactly the same as SAP is important for you, I think you should go ahead with .XLSX, saving the file in one location and open it manually.
In my latest video, I recorded a script, exporting it with XLSX format. Feel free to check it out and I hope that can solve some of the problem that you are facing.
th-cam.com/video/ISDX5LwcVPQ/w-d-xo.html
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 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
@@JoelTing thanks again for the hint, i couldn´t see this notification before. but your'e right, thats the solution I've been lookin' for. :)
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
@@blau98798 Where does your filter stage happen? Do you record the filter that you perform in SAP? Or are you performing the filter with VBA?
Good content
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 , thanks for the amazing tips. Would like to know for the SAP extraction is it possible to automate extraction from Tcode SM37 as well?
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.
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
Is it possible to run it as a background automation so I can work on something else in different programs
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 Joel, Firstly, thank you for your great video! Though I have a question about VBA. I copied exact same way as you shown in your video, but my SAP didn't even react a little. Power Automate flow cannot trigger to my SAP at all. Do you have any idea for this problem?
Hi JoonSun, I'm not sure what would be happening there though. Is there any error being triggered when the flow is ran?
Hi, I have the exact same problem, i think it could be due to the licence with rpa functions that are not enabled. But i dont know
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