Read SAP status bar MessageType from Power Automate Desktop
When you build RPA to handle processes in SAP, it is a good practice to check what status bar displays every time bot confirms data inserted on a screen or tries to navigate away from it. Just to be sure, there is no warning or error message, that should be handled by a bot.
ABAP status bar messages are usually a plain text supplemented with the icon that shows its type. When you double click it you get its details. Message always has its Class and Number (like in example below: F and 2164). There are hundreds of these messages: https://www.sapdatasheet.org/abap/msag/.
Basically, SAP UI does not deliver any kind of information that could let you precisely tell, that there’s an error or not. In the beginning I was trying to simply check, if status bar contains icon that is either error or warning by using “If image” condition and captured images:
However this approach was somehow not really working. I was trying to set different Tolerances, but if it was too high – rule was always true. For you to know – value can be between 1 and 256. If to low – never true. I was stuck.
Visual Basic Script to the rescue!
I started searching how to read that status message type. This way I acknowledged, that actually this plain text message has its types:
- A : ( Shows the errors without resuming the program execution )
- E : Error Messages ( Shows the errors and current program execution will be terminated )
- I : Informational Messages ( Just displaying the information and can be avoided )
- S : Success Messages ( On next screen for showing successful process completion message )
- W : Warning Messages ( Displaying the errors that can be ignored )
- X : Exit messages ( Immediate termination of the program and shows system dump error messages )
Following ABAP MESSAGE Statement and types – SAP Stack
Once I found it, I started looking at possible ways for retrieving them. The only way I found actually was to use Visual Basic Script. Since I am not a developer, I spent some time on figuring out how to write that script, but I am more than happy to share it with you. Simply copy and paste it into “Run VBScript” action in Power Automate Desktop:
Set SapGuiAuto = GetObject ("SAPGUI") Set application = SapGuiAuto.GetScriptingEngine Set connection = application.Children(0) Set session = connection.Children(0) WScript.Echo session.findById("wnd/sbar").MessageType
You can use “MessageType” to get A, E, I, S, W or X letters. Or you can use “Text” to simply retrieve what is displayed in status bar.
Also, I used then action Trim, because VBS Trim somehow didn’t work for me and returned value was always supplemented with whitespace and empty line. This is how it looks at my side:
Do you find it useful? Leave me a comment! 🙂
Tomasz, is User Scripting needed to be enabled for this VBScript to work?
I haven’t tried it without user scripting, but per my knowledge yes – any way of accessing SAP GUI that reads UI elements requires user scripting enabled.
Binta Deena Chacko
Hi Tomasz, I’m using SAP B! along with SAP HANA. I want to automate the Sales Order form . Is it possible to do ui scripting in SAP business one?
Hi, I think there shouldn’t be a problem. Just be sure that gui scripting is enabled.
Hi, I am developing SAP Business One HANA for chemical Industry. i am getting an exceptional error in closing production order. How can I resolve.
Sorry, I can’t help with that. I am not SAP consultant.