Challenge Submission – SAP Intelligent RPA: Master Data Creation using SAP MDG

[former_member395561]

This is a submission for the SAP Intelligent RPA Tutorial Challenge.

Use Case Selection:

Master data stewards / owners to create/change several master data entries and attributes, often use MDG screens. This is a very tedious, repetitive manual task, which takes lot of time for a user to create this data in the system. SAP Intelligent RPA is a useful tool to automate the tasks where BOT can take care of repetitive actions like open, enter and submit, just to fill the master data.

The purpose of this blog post is to show you how to create Master Data in SAP MDG (Master Data Governance) with SAP IRPA.

 

IRPA Solution

In this tutorial, we will use SAP IRPA to extract the required data, input at SAP MDG screen and create a master data.

Some prerequisites in order to be able to follow this blog post are the following:

1. Desktop studio and desktop agent installed and configured Link


2. SAP MDG screen and its corresponding URL to connect to record.

1. Base knowledge of SAP iRPA (creating a project/workflow, adding applications/pages,…) - Link

IRPA Flow

1. Start the MDG Application.


2. Open MDG Master Data Create Screen


3. Extract data, Check and Submit the Change Request.

 

Scenario Explanation



 

1. ‘DISTKEY’ starts the UI5 MDG screen.


2. pHttpsRb3dt2a0Serv- click on new to create the new object.


3. pHttpsRb3dt2a0Serv1- extract the data and submit

 

Step - By - Step Details :

Create a new project and workflow and follow the steps below.



The below code is automatically generated.



2 . Open MDG screen to create Master Data

Page ‘pHttpsRb3dt2a0Serv’ triggers the UI5 MDG screen. This screen will be identified using URL and title. This page has an item to click on New button to navigate to the next page to Master Data Create screen.



Here BOT will wait until page loads and then it will perform the action ‘Click on New Button’.



Generated code for Page 1 ( Create Master Data Application )



3. Extract data and Check

Page ‘pHttpsRb3dt2a0Serv1’ has below items(Distribution key, Description, responsible)



To make the fields as input fields select custom type SAPUI5.input



Workflow of page 2:



BOT waits to fill the data in the fileds and then click on submit. As soon as submit is clicked Change request will be created to create Master Data in the MDG system.





Below code is automatically generated:



 

A Small video of the BOT Execution below:



 

Please Note : The example shown in this BOT is for a Custom Object MDG Application. But this can be done on any MDG application.

[mageshwaran_subramanian]

Good blog, Shruti. I have a couple of questions

1. How the data is being inputted (extract) to the MDG screen?


2. For the use case you mentioned, I think MDG mass processing can be used. Is there anything special (which is not already available in MDG) that can be achieved with RPA?

[former_member242910]

Good blog. Helpful.

[philip_jackson]

Thanks for sharing.  Question: what is the process to have iRPA BOT run in the back end system vs. via the user interface?  example:  Request comes in, BOT kicks off a new MDG Create Material, Supplier, etc?  Or perhaps, the MDG workflow has a step to run a BOT?

[former_member106]

Hi magesh,

 

Thanks for your questions. Shruti is working in my team, so take the privilege of answering your questions. 1) for this poc we defaulted the value in the bot, but it can be done using Excel as well. 2) mass process for many reason cannot be used, i can tell few, one: mass process for custom object is not out of th box, so we have to go with MDC or custom solution or file upload. Here bot can be built easily and given to end users directly. Two: follow up updates can be easily integrated using bot API mechanism.

[former_member106]

Dear Philip,

Thanks, iRPA can be instantiated using API calls, so this is very much possible. I am sure about workflow bot integration, let me explore a bit.

[vijai_mohan2]

Hello Senthil and Sruthi...good blog...nice intro to the automation stuff's...do you have any statistical view into the effort saved as a result of automation?

[former_member663584]

Hi Shruti, Nice blog. Very informative and helpful.

[former_member106]

Thanks Vijay. Sure we can see the statistical view in the Cloud Agent, where it shows the monitoring details. Being this a PoC, we really cannot show the effort detais, but it can be done when we do the real time implementation. I urge you go through the openSAP course called 'Business Process Automation using SAP IRPA', which give you detailed view of an E2E business automation and benifits.

[Peranandam]

semkum shruti.shrivastava

Thanks for your blog. Good initiative towards to master data management..

During creation/change of master data of like big business objects BP and Product Master data is process steering data based on collaborative decision of multiple user groups. Here i would see less scope on automation on creation & change process.

I would see below use cases are valid in the area of master data management.

• There are few approval steps just designed to review CR data and approve. Here i would see scope to automate approval process by validating business rules and notifying users in case of data in consistency for manual action


• Trigger of Data remediation process to address data quality by validating data mining/Data quality business rules

 

[sandeep_1385]

Very helpful and well drafted information. Thanks for sharing this.

[former_member663647]

The product looks very promising.

[mageshwaran_subramanian]

Thanks for clarifying!

[mageshwaran_subramanian]

Those are some good points.

[former_member663674]

The product looks nice ,but I have few doubts as I am trying to implement the same , let me know the other ways to connect .

[former_member395561]

Sure we can ?

[former_member106]

Sure Vaishali. You can inbox me with your queries.

[former_member106]

Thanks Chinmaya.

[former_member106]

Thanks so much.

[former_member106]

Well said Pera. We have already started with the points mentioned. I will write further blogs on those topics as well.

[former_member663679]

Great work.

[former_member395561]

Thanks Dewang

 

[former_member619680]

Very Useful article. Looking forward  for more use-cases on the same.

[former_member183249]

Hey Shruti,

 

Very informative blog on SAP IRPA and its use in MDM.

Rahul

 

[former_member667481]

Hi Shruti ,

How have you handled the logon crederntials in the automation as when i am trying automating it is asking me username and password and it stops the processing .Also , how have you handled the URL for the recording , used the absolute URL or relative one ?

Regards ,

Ashwani K Rohilla

[Private_Member_405501]

Hi Shruti,

Great effort.

Could you please share if you have any experience in working with iRPA on a mainframe application, like application with terminal emulators - 3270 or similar ones?

Regards,

Rinzy