Step by Step SAP RPA BOT
Development
Avik Mazumder & Nilanjan Das
1
Step by step BOT Development - WEB Application
Pre-requisites:
1) Need to make the following important browser settings
2
3
2) Need to include the excel library and SAP UI5 options in the Desktop Studio (Right click on the
script Choose Include Library Script)
And check the Excel Integration and the SAP UI5 (For SAP Applications)
4
SAP (Client & Server-side scripting on)
Click on SAP GUI log on pad and go to option -
Turn on the “Enable Scripting “Check box
Then Log on to SAP and go to the Transaction RZ11 and set the scripting parameter as True.
5
Building the SAP RPA BOT
Open the Desktop studio
Now click on New Project from the menu
6
Provide all the information and hit SAVE to Create a New Project.
Now create a new application
7
After this, create a new application (choose Technology – WEB, Application – Your web application and
finally hit SAVE and capture
Next, double-click on the application / right click on the application and choose the option “Capture new
Page”
8
Now capture the screen.
Add the recognition criterion (Title and URL)
9
After that, select the application and capture the next screen
Hit the Scan and Save to capture the page in the application
10
Add recognition criterion to the page
In each page, we must include all the fields / elements which have definite action (input value / action)
on it. This is done by “associate item” property.
11
Go to the DOM Structure select the node right click on it Hit “Associate to New Item”
12
This way we can complete the screen capturing and setting the corresponding recognition criterion and
associating the elements which have definite role to play during the processing.
Now, we move towards the next step – Building the workflow. For building the workflow, we first need
to create the workflow
Then we provide the name of the workflow along with its meaningful description.
13
In order to read the data records from input excel , first we need to search the step “Initialize excel”
from the property section ( right corner of the bottom panel ) and drag it to the workflow panel just
under the “Start” activity and connect with an arrow.
Then subsequently, we need to add the step “Opening Existing Excel file” and need to mention the
correct file path of the input spreadsheet file.
14
After this we must read the values from the input excel sheet in the following manner.
15
Input data spreadsheet.
In the workflow, after the node /activity “Open Existing excel” – we add one “Get One value” activity (
Search for “Get one value” in the properties , drag to the workflow panel and mention the cell from
where we will read the value and where we will keep it )
16
From, we read the value
17
Now we create containers to keep the values (go to context menu right click click on create folder
then create items under the folder structure)
18
Now, we need to assign containers to the right place which will essentially store the value of each cell of
the input spreadsheet.
In similar fashion we use the “Get One value” activity to read the values from input spreadsheet cells
and assign to the correct containers. Finally, once all the cells are read, we use the activity” End Excel” to
complete the input data reading.
19
Next, we add the “Start” activity and assign application to it and add it to the workflow.
After this, we add the pages from the application (Right corner properties Pages)
20
Thus, we complete the workflow
21
The background code gets autogenerated
Special Note:
For Just running the application in debugging mode, we just need to click debugging and then running it
through the “Desktop Agent”.
22
But in order to run the application, in regular “Run Mode”, we need to make sure the following changes
are done in the code (GLOBAL.EVENT START ON Method). The following two lines need to be
commented.
Then we can run the application in normal run mode through the desktop agent.
23
