[SAP S/4HANA CLOUD] – EXTENSIONS WITH PROCESS AUTOMATION

Hi guys, today I want to share article How to develop extensions with SAP Process Automation. This one similar with article which I posted before. Reference here

Scenarios

Customers input data of Purchase Order Requisition in excel file. They want to build tool which read excel file to get data automatically and after that send to S/4HANA to create Purchase Order Requisition.

As a Citizen Developers on SAP BTP, I will use SAP Process Automation to adopt this requirement of customer.

What will we learn ?

How to expose API in S/4HANA public edition
How to subscript SAP Process Automation and Cloud Identity Services
How to build action project connect API of S/4HANA
How to use Excel SDK in Process Automation

Prerequistes

SAP BTP Trial account Or Free Tier

S/4HANA public edition

Desktop agent installed on local machine

Diagram

How to …?

Configuration S/4HANA Cloud expose API Purchase Order Requisition

Explore API S/4HANA

Configuration Communication Arrangement with scenario SAP_COM_0102

Subscript SAP BPA and SAP CIS

Create destination for SAP BPA

sap.applicationdevelopment.actions.enabled	true
sap.processautomation.enabled	true

Add destination into SAP BPA

Create action project in SAP BPA

Because of Method POST need CSRF Token, so we need configure this action enable CSRF Token

Release

Publish to library.

Create Process Automation consume action

Template Excel

Excel Cloud Link read headers sheet mapping to datatype and return list. Ex: POHeadersRequest

Excel Cloud Link read items sheet mapping to datatype and return list. Ex:POItems

Create list item variable have structure the same structure with data type Item action

Every loop items, add item to list

After every loop headers, call action to post data. Call API can raise exception, so we will wrap it into try..catch block

Run test

Check data on S/4HANA Purchae Order Requisition

Configuration background job for automation

Add Agent to Agent Management

NOTE

If not Agent Management configured, we will receive issue

Create trigger (Background Job)

Deploy project automation

Conclusion

This article will be useful for Citizen Developer, who not know code but expert in business process. With SAP BPA, we can do many things with visualization drag and drop. If you interested in Citizen developer you can try this services on BTP. Thanks for your reading and any advise, kindly leave your comment on this.

Thanks.

Joseph.