Three bots you’ll find on the SAP Intelligent RPA Store
Dear community members,
After our RPA Experts’ blog posts “Reducing Dev Time with the Intelligent RPA Store” and “SAP ECC Bot Store Content for Intelligent RPA” (missed it? Go ahead and read them ?) I thought I’d give you a sneak peek into the SAP Intelligent RPA Store with three of its most popular bots. Here we go:
This bot reads the question sent by a user via email and fetches the answer from an FAQ document maintained in MS-Word or MS-Excel format. This answer will be sent as a response to that email. Technologies used: MS-Excel/Outlook/Word 2016 and 365.
How will the bot do for you?
The bot reads the emails with the specified subject and extracts the body from each email. Then extracting the questions contained in the text using the delimiter (“?” or “.”).
The “FAQ document” is read and stored in a variable. For each question sent via email, Nouns are extracted and matched against the questions available in the FAQ file to calculate the confidence percentage. From there, two things can happen:
- A) The confidence percentage is above the threshold,so question and answer from the FAQ file are pushed into an array.
- B) Confidence percentage for all the questions in FAQ file is below threshold, then a failure email is sent with the attachment.
? To read the detailed process flow, go to this section on the RPA Store.
Creation of Business Partner BAPI
SAP BAPI (Business Application Programming Interface) is a standard interface to the business object models in SAP products. BAPIs are the primary method through which customer code and third-party applications interact with SAP products. BAPIs are implemented as functions that call SAP internal code. Automate the creation of a Business Partner using BAPI: BAPI_BUPA_CREATE_FROM_DATA – Create Business Partner. In this scenario, each BAPI call (and the subsequent commit work) happens in a separate session. Ideal for executing the bot on a multiple agent setup. Technologies used: SAPGUI 7.60 for the BAPI ActiveX call, MS-Excel 2016 and 365.
What will the bot do for you?
A connection to the specified SAP system is established using an ActiveX Object. The excel template is copied as the output file into the specified output path. The various importing parameters are filled for the first Sequence number according to the values specified in the excel sheet of the same name. Parameters with type as IN in BAPIInfo sheet are considered here.
Once the value is filled, the BAPI is executed, and the values obtained from it (i.e. the parameters with type as OUT in the BAPIInfo sheet) are populated back into the corresponding sheets.
A commit is issued to commit the execution of the BAPI. Subsequently, steps are repeated for the next Sequence number. The Sequences can be executed in parallel if multiple agents are available.
? This is just an overview. The detailed steps can be found here.
Creation of Purchase Orders – ECC (ME21N)
With this one, the creation of a Purchase Order can be automated using header and item details as input which is read from a template MS-Excel file. The report supports F4 based lookup of descriptions and can create multiple orders in one go. Technologies used: SAPGUI 7.60, MS-Excel 2016 and 365.
What will the bot do for you?
First, the input criteria and system information are contained in a configuration excel. This excel file contains the system details like the System ID, Client, Username, Password and whether Single Sign-On is enabled. It also contains the header and item details necessary to create Purchase Order(s).
The bot reads input criteria from the excel file and automate the creation of Purchase Orders using the input criteria. It then writes the created order number back into the excel file.
? More details and all documents here.
The bots described above can be used in various Lines of business e.g. Sourcing and Procurement, Asset Management, Commerce, Finance, Human Resources, IT, Manufacturing, Marketing, R&D Engineering, Sales, Services, Sourcing and procurement, Supply Chain, or Sustainability. As well as in diverse industries, for instance Aerospace and Defense, Automotive, Banking, Chemicals, Defense and Security, Engineering construction and operations, Healthcare, High tech, Higher Education and Research, Industrial Machinery and Components, Insurance, Life Sciences, Media, Mill Products, Mining, Oil and Gas, Professional services, Public Sector, Retail, Sports and Entertainment, Telecommunications, Travel and transportation, Utilities, or Wholesale Distribution.
Allowing the bots to get the job done for you not only reduces manual effort allowing you to concentrate on more important tasks, but also ensures faster replies to user queries or creation of documents and eliminates human error ?
You can access the numerous available bots in the store from your SAP Intelligent RPA tenant. To get even more insights, I suggest you watch this SAP Community Call, which discusses available content and includes a demo for deploying bots, or this short video about downloading content from the store.
For more SAP Intelligent RPA content:
- Visit our web page,
- Explore successful use cases,
- Follow us on Twitter, LinkedIn, YouTube.
All the best,