Enhance API_Sales_order_srv to update custom table post SO creation

[former_member721373]

Hi All,

I am stuck in a requirement where I need to provide an ODATA API which will be used by third party system to create a sales order and update a custom table post creation. The inputs for the custom table will also be received from third party only.

Now we already have a S4 API for sales order creation API_SALES_ORDER_SRV which is based on SADL Framework.

I have created an extension view for A_SALESORDERITEM CDS view with the fields from my custom table. And these fields are available in metadata as well.

Now the problem i am facing is how to update my custom table when doing a POST call.

Kindly can anyone help here with the appropriate and best suited solution for this requirement?

thank you in advance ��

[Jelena]

What release are you on? There is a post about extending this API but tbh it can be rather painful and it might be easier to just provide another service for custom table update. If you're on 2020, RAP should be available and using managed scenario it's quite easy to implement simple CRUD service for Z table.

[former_member721373]

jelena.perfiljeva2 thank you so much for your response. Sorry for the late reply as the requirement was on hold till now. Yes we are on 2022 version and I am already using RAP for my odata services. But if I go with custom api, i would also need to implement the logic for sales order creation and updation part using the BAPIs as only a single api is required to firstly create a sales order and then if this is successful, it should update a custom table. The import parameters for this api would be the sales order bapi import parameters and custom table data for each sales order. Kindly could you please let me know if there is any example for building sales order creation and updation api in RAP? Thanks in advance 😄