I am creating a bot to automate the process below at requested time everyday:
- Login SAP
- run T-CODE
- get the data of certain countries
- export the data in .xlsx
- open the excel
- delete unnecessary columns
- save the excel
- send the excel via email to PIC
Currently I stuck at step 4 where I want to go List > Export > Spreadsheet > save the file name with timestamp
I tried to use the script recorder in SAP as well as the Scripting Tracker that I installed additionally. Both basically recorded the same field path as below:
session.findById("wndI0]/mbar/menua0]/menu03]/menu31]").select
session.findById("wndI1]/tbar10]/btn[0]").press
I have tried to input the field path for SAP: Export table one by one as in:
wnd<0]
wnd<0]/mbar
wnd<0]/mbar/menu/0]
wnd<0]/mbar/menu/0]/menun3]
wnd<0]/mbar/menu/0]/menun3]/menun1]
But it just prompted error ‘the session is not found’ or ‘the object is not found’.
Then I referred to How can export a report in SAP in a360 | Community (automationanywhere.com) to use the SAP: Click menu action.
I tried to use this path I got by using recorder, but no luck, showing the number 3 is not found.
Then I tried the path below but error persists.
3|1
3|1|1
3|1|1|4
3|1|1|4|1
3|1|1|4|1|1
I tried to use other actions like SAP: Click and SAP: Double click but unable to export as well.
Then I thought to use virtual key action Ctrl+Shift+F9 to save the local file. But then will stuck at the file name session as I’m not able to set the file name to timestamp_country.xlsx (last time they created the RPA bot with Brity and created the filename by using java script).
So in short, I reckon that the easiest way to export the table from SAP is by using the SAP: Export table but I couldn’t get the correct field path.
It will be much appreciated if anyone can assist on this.
Thanks!