Sales Order and SAP BTP Use Case with SAP Build Apps, SAP Integration Suite and Sales Order API

[TomBroussard]

Hi all,

I'm currently working on my first Business Use Case using the SAP BTP abilities. What I would like to do is the following Use case : Anticipate delivery delay and inform the customer

I wanted to go trough those steps : 

• Detection: The SAP system detects a delay or application.
• Transmission: The event is sent to SAP Integration Suite through an API connection.
• Preparation: SAP Integration Suite prepares the notification message.
• Sending: Notification is sent to the client via email, SMS, or portal.
• Confirmation: Receipt by the client is recorded.

I directly found my self in a bad spot about the delay detection and how to automate this step. So, I figured I had to simplify the use case in order to learn step by step the SAP BTP abilities and go with the automate delay detection later on. 

I finally chose to follow thoses steps : 

=> Develop a Build Apps Application and connect it to an Sales Order API from our S/4.

=> On the application, insert the product ID and the date on which the product will be delivered. 

=> Connected to the API Sales Order, we get the data about the product ID :

• SalesOrder (key) : ID
• RequestedDeliveryDate : Suggered delivery date by the system
• DeliveryDateTypeRule : <blank>: The goods should be delivered on the requested delivery date or later. A: The goods must be delivered exactly on the confirmed delivery date. B: The goods must be delivered by the confirmed delivery date (that is, on the date or earlier).

=> We compare with the date input from the application to see if there will be any delay.

=>If there is any, we informe automatically the client by email (with intégration suite ?)

It brings me to the SAP community, to get an idea of the success possibility of this use case based on your opinions. To know if my choice of tools is accurate or if I could use any others, if the order in which I use them is accurate and if there is any advice or tips to be aware of before starting this use case.

Thank you all.

Regards,

Tom

[lwillnat]

Hi Tom, regarding "detecting delay", I had the idea about creating an ABAP report which checks for each schedule line if for the corresponding "outbound delivery date" (table LIPS) there is a mismatch, if yes ; put into a temporary table. At the end send this temporary result table to Integration Suite through a POST HTTP Call as an JSON/XML structure. Please feel free everyone to comment my suggestion.

[Sankara1]

Hello Tom, Thank you for reaching out to us. Could you please clarify if you're aiming to achieve this particular use case or if you're looking to upskill in SAP Build Apps? If your focus is on the use case, I recommend trying SAP Build Process Automation instead of SAP Build Apps, as it might be a better fit. However, if you're seeking to improve your skills in SAP Build Apps on BTP, you can follow the SAP Build Apps help portal for further insights - https://help.sap.com/docs/build-apps?locale=en-US

[gregorw · Accepted solution]

Hi Tom,

before starting with development I would suggest that you check that the API_SALES_ORDER_SRV provides you the needed data. So activate the service in your S/4HANA System and try to consume it directly with Postman or REST Client (which I'm a big fan of). I think your entrypoint will be A_SalesOrderItem as you want to filter for a specific product. I suggest you also check the API Documentation at Sales Order Item because it gives a detailed description about the fields. 

I'm not sure if a Build Apps application is the right tool here. Should the app be used interactive by your company employees or should it run scheduled in background?

Best Regards
Gregor

[TomBroussard · Accepted solution]

Hi gregor, 

thanks for the quick response and your help. 

I checked in the API documentation and I think I would also need the  API_SALES_SCHEDULING_AGREEMENT with the delivery schedule entrypoint. 

Regarding SAP Build App, I’m using it to improve my BTP skills. There might be a different way to achieve this, which is why I made this post. To get advice, tips or knowledge about it.  I’ve already connected the Sales Order API to the app. I’m using this app for now for the sake of learning.

Regards,

Tom