SAP Knowledge Base Article - Public

2848700 - Key Date Not Available in OData Query Filter


In some reports, for example, Material Inventories - Balance Summary (FININVU14_Q0001), 'Key Date' is available for selection but not available in OData queries filter when using Build OData Queries.


SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Analytics work center.
  2. Go to Design Reports view.
  3. Open a report, for example, Material Inventories - Balance Summary (FININVU14_Q0001).
  4. You can see 'Key Date' is available in Selection. 
  5. Click Build OData Queries.
  6. Search for 'Key Date' in Filters tab.
  7. You will notice that 'Key Date' is not available.


The parameter 'Key Date' is actually available in the OData Service. It does not show up in the Query Builder.

You can find it in the $metadata document, for example, f'. /sap/byd/odata/ana_businessanalytics_analytics.svc/$metadata?entityset=RPFININVU14_Q0001QueryResults'.


If you want to provide a $filter on it, you can write the $filter statement manually.

See Also

2734842 - Attributes Not Available in OData Query


Key Date, OData, Report , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To


SAP Business ByDesign all versions