We demonstrate how to extend S/4HANA Cloud using the powerful Mendix SAP OData connector.
We have developed a procurement planning solution that needed to extract purchasing data from an S/4HANA Cloud 2408 system. Here we show how to get the basic plumbing working using the tooling provided by Mendix.
Conceptually the OData protocol is powerful - SAP uses it across their application portfolio. The challenge for rapid application developers, with limited SAP knowledge, is the complexity of the entity sets the API provides can be overwhelming. It is really simple to discover which APIs are available using the SAP Business Acceleration Hub.
The purchase order API for S/4HANA Cloud Public Edition can be viewed here
As a developer you will need to complete the following:
This guide assumes that you have some Mendix experience and Studio Pro installed and that you have the relevant roles in the S/4HANA Cloud system for configuration (BR_ADMINISTRATOR & BR_PURCHASER).
Now that we have identified the purchase order API from the Business Accelerator Hub, we need to configure our SAP system to expose the data, this will require us to:
1. Create a new communication user & associated system.
2. Create a communication arrangement for scenario SAP_COM_0053_020
These are performed using the Communication Management page in your launchpad:
The end result should be a user that has the following assigned to it:
If you would like to test this service, you can do it directly from the Business Acceleration Hub, by configuring the system with the relevant details that you created above.
OData services are self-describing you can access the endpoint url and add the $metadata suffix to your URL. The url for viewing the metadata can be accessed using the following URL:
https://XXXXX/sap/opu/odata4/sap/api_purchaseorder_2/srvd_a2x/sap/purchaseorder/0001/$metadata
Download this file and save it with an .edmx or .xml extension - you will need it in the next step.
Now we need to import this into a service provided by Mendix which will convert the metadata description into a domain model that can be used within your Mendix application. Open the following URL: https://sap-model-creator.home.mendix.com/
In the next step, upload the metadata file that you created in the previous step, select the schema and after model has been generated.
Download the Mendix MPK file for you to import into your Mendix application in the next step.
Now we finally get to building our Mendix application, follow these steps:
Now is you look at your domain model you should see the domain model for purchase order, look at how many entity sets etc there are, the model generation tool saves application developers a huge amount of time.
Now we have the domain model in place, the next step is to configure a microflow to fetch details.
Now that we have the domain model the next steps are:
The marketplace module that we installed provides additional capabilities within the Microflow editor. Add the following steps into the microflow (using the toolbox with new functionality):
In the basic authentication step, include the username and password for the communication user. In the Get list microflow add the OData query string based on your specific needs and return a list based on the entity you require. In our case we wanted a list of purchase orders.
Final step is to create a page with a datagrid where the attributes you would like to see can be displayed. Below is an example of the results.
Of course this is just a basic extraction scenario, improved token management and caching would likely be the next steps you would want to build. Let us know if we can help accelerate your projects with our fast start service.