Hello everyone, in this blog we are going to discuss how to create customer projects in SAP S/4HANA Cloud using SAP Process Automation Recorder.
The minimum version required to automate S/4 HANA Cloud is mentioned below:
- Agent/MSI version – 22.214.171.124
- Extension version – 126.96.36.199
- SDK version – 1.25.57
To start, we need to have SAP Process Automation Cloud Studio open in one browser window and SAP S/4HANA Cloud application in the other window and then follow the below mentioned steps:
Step – 1: Create a new project in Cloud Studio. Once the project is created, a new tab will be opened. (as shown in fig)
Step – 2: Click on Create to start with a new Application. All the applications running in our system will be listed down and we need to select SAP S/4HANA Cloud Application from the list.
On selecting SAP S/4HANA Cloud Application, both Launch Recorder and Capture Application would be available in Cloud Studio.
Since in this blog we are focusing on Recorder, click on Record button to proceed ahead.
Step – 3: Once we click on Record, the recording widget will be launched on top of the SAP S/4HANA Cloud Application. (shown in fig). Click on the red button of the Recording Widget to start with the recording.
After the recording has started, whatever actions we take on UI will be captured into the recording widget.
Step – 4: Enter Username, Password and click on Log On button to login into the SAP S/4 HANA Cloud Application.
All the actions performed in the SAP S/4HANA Cloud application are recorded and displayed in the recording widget.
Step – 5: Once login is successful, we can see there is a warning message in the recording widget.
This warning message is the Capture Hint which mainly emphasizes that a new capture needs to be done as there is a change in the UI. (since a new page is loaded)
Click on the capture button (camera icon) in the recording widget whenever there is a change in UI or a capture hint appears.
Step – 6: After capturing the page, click on Project Management – Professional Services.
Step – 7: Then click on Create Customer Projects.
Step – 8: Now you will be redirected to new page where we need to fill in Customer Project Details
To fill Customer Id , click on value helper (icon on the right), then search for the customer Id and select it from the popup. (shown in fig)
Step – 9: Enter Project Id, Project Name and Project Description.
Step – 10: Click on Create And Proceed button at the bottom of the page. After clicking Create And Proceed, a new customer project will be created with the details provided in the previous steps.
Step – 11: Since the customer project is created . Now, I am going to create a work package.
Click on Create button, a new popup to Create Work Package would be open to fill in Work Package Details.
Enter Work Package name, description and click on Create button in the pop up (as shown in fig) to complete the work package creation.
Step – 12: Once the work package is created, click on Save button.
Step – 13: Up to now, we have created a customer project and a work package within it.
Now let’s add some resources to the team.
Click on Teams and then click on Add Resources. Resources popup would be shown on the UI with resources description.
Step – 14: Click on the checkbox to select the resources and click Add.
Step – 15: After adding the resources, assign the work package to them, and click on Recalculate and Save.
Step – 16 : So, we are done with creating a customer project in SAP S/4HANA Cloud Application and we can see all the steps are recorded and displayed in the recording widget.
We can now stop the recording and export the artifacts.
Step – 17 : Artifacts are mainly the metadata that was recorded. It consists of various screens that we captured, the elements we interacted and the actions we took while recording.
Once these artifacts are exported, we can see an application and an automation is created in Cloud Studio.
And yes, we can run the generated automation with or without modification to create a new customer project in SAP S/4HANA cloud application.
Now, let us enhance this recorded bot to read dynamic data from Excel.
The excel that I have used in this blog has three worksheets as follows –
Customer Project, Work Packages and Resources.
Step – 18: So far, in the Cloud Studio we have only one application and one automation. Now we will create a new automation to read customer project data from excel.
To create a new automation, click on + icon. (as shown in fig)
Step – 19 : Add following steps into the automation.
- Open Excel Instance.
- Excel Cloud Link – This activity reads data from a specific worksheet and maps into a data type which we will later use in our automation for mapping. Provide the workbook Path and the worksheet Name from the excel and then click on From Excel Data button. This will map the excel data to data types. Since I had three worksheets, so I added this activity thrice. Once for reading data from each excel worksheet.
- Add Close Excel Instance.
- Output of this automation should be the data returned by Step2, Step 3 and Step 4.
Step – 20: Now, we will use this automation into our existing recorded automation i.e. create customer projects in SAP S/4HANA Cloud Application.
Add this automation as the first step of our existing automation.
The output parameters highlighted in the above step can be used as an input parameter for any existing step.
Step – 21: How to use these output parameters in the existing bot?
ProjectData (one of the output parameters of the automation that we created above) is a list of customer projects. Let’s add a For Each loop to the existing bot so that we can create multiple customer projects using the same.
Now update the input parameters of all the steps to read the value from the current For Each loop.
Similarly, we can also add For Each Loops for Work Packages and Teams and update the input parameters of the automation step.
Conclusion : So finally, when we run this automation all the values will be dynamically read from the excel and Customer Projects will be created in SAP S/4HANA Cloud Application.
Do not forget to have a look at the Learning content in our Store, as it contains many useful examples of use cases.