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.

[satishgunda]

Brilliant blog & Great work Sahil!! , Just a small suggestion, Would be great if we can provide the downloadable project as a git so that the partners/customers can directly consume it and adjust according to their needs. 

[Sahil_Grover]

Dear Satish,

This document serves as both a basic/generic guideline and a demonstration of product capabilities. Partners and customers can utilize it as a framework for creating their own build automates.

Regards

Sahil

[Saumi_IE]

Great one @Sahil_Grover : Keep such valuable blogs coming!

-Saumi

[yashmin99]

Hi @Sahil_Grover 
This is a very informative and insightful blog!!!

I had one blocker while implementing the same, I am trying to post a set of data from excel to SAP S/4 Hana but only one line item gets posted to it while the other line items don't. 
could you suggest me about the same.

Thanks & Regards
Yashmin
SAP Build Process Automation 
RISE with SAP 
SAP Build Apps