SAP Knowledge Base Article - Public

3334892 - Descriptions Missing in OData Query

Symptom

You are running an OData query for a report and you notice that some texts are missing and it only shows the IDs. For example, material descriptions might be missing and only material IDs are shown, even when you use the text field.

Environment

  • SAP Cloud for Customer
  • SAP Business byDesign
  • ODATA interface

Cause

The descriptions are language specific and were only maintained in a logon language other than English.

When you run an OData query in the browser, it will take the logon language of your UI session, if you are already logged on in the UI.

If you run the query from another tool like POSTMAN for example, it will take English as a default language.

Resolution

You can specify the language in the OData query to ensure that texts are returned in a specific language.

Please add the following to your query: &sap-language=<ISO code>

For example: &sap-language=es for Spanish or &sap-language=fr for French.

Keywords

odata, report, wrong language, missing text, missing descriptions, business analytics, reporting , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions