SAP Knowledge Base Article - Public

2638695 - Date Time Fields Have Format Edm.String in OData

Symptom

You are using an OData query for a report which contains a date time field. You would like to filter on it, however when you check the metadata for this report, you notice that the field has an Edm.String format. You cannot filter on it.

Environment

  • SAP Cloud for Customer
  • SAP Business ByDesign

Cause

Currently, date time fields are handled as Edm.String fields, which is correct. Additionally as per the product documentation, filtering on date time fields is not supported.

Resolution

We would recommend to use a date field for filtering.

See Also

For further information on how this feature is designed and how to set up your OData query correctly, please see the following blog:

https://blogs.sap.com/2015/03/10/odata-for-sap-business-bydesign-analytics/

Keywords

OData, date-time, DateTime, $filter, edm, reporting, business analytics, cannot filter, filter not possile, $select not working , KBA , report selection , string , edm , odata filter , datetime , 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 ; SAP Cloud for Customer core applications all versions