Mass upload utility via API to SAP S/4HANA Cloud Public Edition with SAP Build Process Automation

[Sahil_Grover]

Collaborative effort of Bhavneet Kaur and Pavalavel Kanagavel

This blog post will provide detailed information on how to build a utility to mass upload via API to SAP S/4HANA Cloud Public Edition using SAP Build Process Automation.

Introduction

Let’s take a scenario for Service contracts where we need to mass upload the contracts in SAP S/4HANA Cloud Public Edition. SAP Build Process Automation enables the business users to automate the mass upload via excel with low-code no-code. SAP Build Process Automation is available as a service on SAP Business Technology Platform (BTP).

Process steps

Following are the steps elaborated to setup the SAP Build Process Automation for the mass upload of service contracts via an excel:

1. Subscribe and configure to SAP Build Process Automation in the BTP Account: Help Link

     2. Access SAP Build Process Automation application. Install and configure the latest version of Desktop Agent: The Desktop agent is responsible for running automations. Make sure to Connect/register your agent to SAP Build Process Automation. Help Link

     3. Configure the destination in BTP account to connect to SAP S/4HANA Cloud Public Edition system. The destination is used by the build project to make a call to SAP S/4HANA Cloud Public Edition.

Make sure you have set up  Communication arrangement for Service Contract in SAP S/4HANA Cloud Public Edition .    

      4. Import Destination from BTP cockpit to SAP Build Process Automation.

      5. Create an Action using Service contract API:

Help Link

     6. Set up Process Automation and call the action created in step 4:

Help Link

This is sample that’s created to show we can use Build application with no code to post documents to SAP S/4HANA Public Cloud Edition.

Sample excels.

Header tab

Item tab

Automation

Green (Step 2 and step 3) -> We are reading data from each excel tab and storing into data type.

Red (Step 4 and Step 7)   ->Looping first at header and then for each header looping at item to add all the line items to a list.

Blue (Step 5 and Step 9)  -> Condition -2 we are checking if the header row is not empty, in case not then.  Condition -3 we are checking if the line-item row is not empty.

Now in excel only rows filled with data will be considered.

Now we are in nested loop.

Yellow (Step 11 & 12)    -> we are checking if header dummy contract number matches with Item dummy header contract.

Purple (Step 13)            -> we are adding it to a list.

List type

Black (Step 15)             -> we are calling the action project. Here you can see the destination. 

Step 16 and step 17 we are clearing the list. So that the iteration starts for next contract.

We are closing and releasing the excel. Further to it logging can be added. As mentioned, it samples to show product capabilities.

     7. Create an unattended trigger for your process automation and run now.

Once the automation is  deployed, we create an unattended trigger. For complex types we cannot schedule attended trigger.

     8. View the Automation executed under the Monitoring> Automation Jobs tab

     9. Result in SAP S/4HANA Cloud Public Edition cloud public edition

Conclusion

This blog post should help you to understand in detail how to use SAP Build Process Automation to mass upload documents in SAP S/4HANA Cloud Public Edition with low code no code.

Thanks for reading this blog post, hopefully the blog post was informative.