SAP Knowledge Base Article - Preview

3633183 - OData service fails with "500 Internal Server" error with filters based on subentities

Symptom

While calling a GET request based on sub-entity filters (example in Sales Order processing): 

/sap/opu/odata/sap/API_SALES_ORDER_SRV/A_SalesOrder?$select=to_Partner,*,to_Item/to_Partner&$expand=to_Partner,to_Item,to_Item/to_Partner&$filter=(SalesOrder%20eq%20'1234567890')

In some cases the request fails with "500 Internal Server" Error if it is called in JSON format ("Accept: application/json"), but it works in XML format ("Accept: application/xml").


Read more...

Environment

  • Sales and Distribution (SD) 
  • Fiori 
  • SAP S/4HANA 
  • SAP S/4HANA Cloud Private Edition

Product

SAP S/4HANA Cloud Private Edition all versions ; SAP S/4HANA all versions

Keywords

500 Internal Server, JSON, XML, filters, expand, API_SALES_ORDER_SRV, API_SALES_CONTRACT_SRV, API_CREDIT_MEMO_REQUEST_SRV, API_DEBIT_MEMO_REQUEST_SRV, API_CUSTOMER_RETURN_SRV, API_SALES_QUOTATION_SRV  , KBA , SD-SLS-API , APIs for Sales Document in S/4 Sales & Distribution , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.