SAP Knowledge Base Article - Public

3300209 - Report field is not available in OData Query

Symptom

You are trying to add field e.g "ABC" in an OData Query, but the field is not available to use in the OData Query.

Environment

SAP Cloud for Customer

Reproducing the Issue

--Steps to Reproduce--

  1. Go to Business Analytics Work Center
  2. Go to Design Reports
  3. Search "ABC" (ABC is an example of a report name) and open
  4. Go to Build OData Queries
  5. Go to Selection and search for field "ABC"
  6. You will see that the field is not available in the fields list
  7. Now, you will need to go to the "Add fields" feature and add the field to the report
  8. Go back to "Build OData Queries" and see field is now available to be added to the report view

Cause

The field "ABC" is not listed in fields list and not part of the report view.

Resolution

You need to add the field to the report view via the "Add Fields" feature, then it will be available for OData Queries.

  1. Go to the "Add fields" feature and add the field to the report
  2. Then, go back to "Build OData Queries" and see field is now available to be added to the report view

Keywords

Add Fields, OData Query, OData, Field is not Available, Build OData Queries , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions