S/4 HANA Public Cloud - Sales Order Odata API - How to Add Filter to Expanded Attribute

[rahuljain257]

Hello Everyone,

Could anyone please guide me on how to add a filter to an expanded attribute?

Here is an example for your reference: The following URL expands the items (Sales Order Item) and aligns them with the Sales Order:

URL: https://xxx/sap/opu/odata/sap/API_SALES_ORDER_SRV/A_SalesOrder()?$expand=to_Item

However, when I try to add a filter inside the expand operator, it doesn't seem to work:

URL: https://xxx/sap/opu/odata/sap/API_SALES_ORDER_SRV/A_SalesOrder('2')?$expand=to_Item($filter=SDProces...

Any insights or suggestions would be greatly appreciated.

Regards,

Rahul Jain

[MartyMcCormick]

There is an OData v4 API for Sales Order to Ralf's suggestion: https://hub.sap.com/api/CE_SALESORDER_0001/overview

And the query for your requirement would look as such:

/sap/opu/odata4/sap/api_salesorder/srvd_a2x/sap/salesorder/0001/SalesOrder?$expand=_Item($filter=SDProcessStatus eq 'A')

[RalfHandl · Accepted solution]

The API in question uses OData V2, and OData V2 does not allow filtering expanded items.

Please check whether there is a newer OData V4 API and switch to it.