Technical Articles
SAP Build Apps Application to show Data from ODATA S4 System in tubular format
Motivation:-
In this blog you will learn how to display data in SAP Build Apps web application from SAP ODATA Service.
Overview:- The SAP Build apps low code/no code solutions which enable users of all skill levels to easily create the business applications. This approach help users to create applications and automate the processes, Developer can use the drag-and-drop functionality and create the application.
Business Scenario:- Here I am going to show you, How S4 OData consumed to Build apps in tubular format.
Welcome Page
Click on Create button and click on Build an Application
Builds app
Click on Web & Mobile Application
Web and Mobile app
Give the Project Name & Project Description and Click on Create button
Project Name and Description
Design view, As we can see all the tool in the CORE tab but Table we can not find here so we need to go in INSTALLED Tab.
Design view
In Installed tab search for Table as given below.
Installed Tab
Click on Table and you will get option for install the Table in UICANVAS.
Install Table
After Installed Table you will get table in Installed Tab.
Added Table in Installed Tab
Drag Table to Page Layout
Drag Table to Page Layout
Before Mapping data from S4 to Build apps , We need to create Destination in the BTP cockpit under Connectivity and give the required details of S4 system , ODATA URI and Additional Properties as given below.
BTP Destination
Connection Test
Click on Auth Tab in UI Canvas
Auth Tab
Click on Enable Authentication Button
Enable Authentication
Click on Enable BTP authentication.
SAP BTP Authentication
Click on Save button.
BTP authentication Page
Now go to Data Tab and click on Add Integration
Add Integration
Add BTP Destination
You will get your created BTP destination as below.
Get Destination
After select the destination, you will get ODATA Set and click on Install Integration
Installed Integration
Click on Enable Data Entity.
Enable Data Entity
Save the Integration.
Save Integration
Click on UI Canvas and Select the table, in Right side click on Configure button under Table resource.
Go to UI Canvas
Select ODATA Set
Select ODATA Set
Here you can see the fields from ODATA and in Display Name you can give your desire column heading name.After that click on Save and exit and click on Save button on top right.
Showing fields from ODATA
Click on Launch Tab and click on Open Preview portal.
Launch Tab for Preview portal
Click on Open web preview
Open web preview
Select your project which you want to see the output.
Select your Project
Final output as below data is coming from S4 and displaying in Build apps.
Final Output
In conclusion, integrating S/4 HANA using BTP destinations and SAP Build apps can provide businesses with a powerful solution to streamline their processes and improve their customer experience. By using BTP destinations to connect the multiple systems and SAP Build apps to create custom applications, businesses can read real-time data from S/4 HANA and display.
Once you get more familiar with the SAP Build apps then it will be easier to build scenario and play around. Try to different some more integration scenarios.
Hope this blog may help you in your use cases. Please do like follow and comment if you have an any query on this topic.
Hi Dinesh Kumar,
First of all, it's a very brief technical understanding on SAP Build apps and its very useful care you have shown here. it will really be helpful for many SAP consultants. Keep it the good SAP blog post again thanks for sharing knowledge.
Thanks,
Hans Raj
Thanks Hans Raj , Glad to know you liked this blog.
Thanks
Dinesh Kumar
Hi Dinesh,
Its very useful blog on SAP Build apps, Thanks for sharing and keep it the good post.
Thanks
Priti
Thanks Priti
Great tutorial Dinesh, thank you! 👍🏻
Thank you very much Pierre COL. It means a lot for me.
Great article! step-by-step guide is easy to follow for all those who might be new to this ODATA integration. Thanks for troubleshooting tips.
Thanks for sharing!
Thanks Vedika
Hi Dinesh sir,
This will be very helpful for everyone, very well described.
Keep up the good work.
Thanks Sanjay Kushwah
Hi,
Thanks for detailed and informative blog post on SAP Build apps with ODATA integration.
Thanks & Regards
Tushar Rajput
Thanks Tushar Rajput
Hi Dinesh
This is very usefull detailed blog. Thanks.
Rahul Sinha
Thanks Rahul
Hi Dinesh
Thank you for the useful blog. I used it to list sales orders from my S/4 system in the table component. It didn't work initially even though the API returned data in Postman. I then added pagination parameters to restrict the number of records.
Data adapter properties
Pagination setting
Once I restricted the number of records, the app worked properly. Do you know why this is so?
Hi Shantanu Sharma ,
Glad to know you liked my blog.
Coming to your question No, Pagination property is not dependent on API output. Even I did not give any pagination property and it is displaying all the ODATA API data. I think you need to check you binding again.
Pagination Property
Thanks
Dinesh Kumar
Dinesh
I too don't think it should have an impact but I get no data when the parameter isn't set. I am using the API_SALES_ORDER_SRV/A_SalesOrder from the Sales Order (A2X) API package for SAP S/4HANA. You have created an OData service in S/4 that you have used in the blog. What is the volume of data in the table in S/4? I have a large number of records in the sales order header table at my end, so this could be why I need to set the pagination parameter. I am not required to set pagination in Postman so I think Build Apps might be imposing it in order to prevent an inordinately large data fetch.
Why don't you try it with API_SALES_ORDER_SRV/A_SalesOrder? Details in the SAP Business Accelerator can be found here: https://api.sap.com/api/OP_API_SALES_ORDER_SRV_0001/resource/Sales_Order_Header
Hi Shantanu Sharma,
I tried for pagination but it seems property is not working after done the setting in SAP Build apps but I am looking into this and get back to you soon.
Thanks
Dinesh Kumar
Hello Dinesh,
I gone through many links and study material about this topic, But I found your blog more helpful to understand the concept how you explained. I can say, yes your explanation can make more and more clear only within 4 minutes. Thank you for sharing your knowledge, keep it up.
Regards
Danish
Thanks Danish
Hi Dinesh,
Thank you for the useful blog. It was really helpful and with the steps mentioned above I was able to display data in tabular format.
I have a requirement where I have to add an additional column to this table. Is it possible to add additional column to these table. If possible, can you guide me how to add additional column.
Thanks & Regards,
Jeeva S