SAP Knowledge Base Article - Public

3139933 - Date fields not available in Custom Analytical Queries

Symptom

When creating an analytical query on a CDS view(an analytical dimension) which has the fields "ValidityStartDate" and "ValidityEndDate", these fields are not available in the analytical query.

Environment

S/4HANA Cloud

Reproducing the Issue

1. Create a Standard CDS View with a primary data source which has the fields "ValidityStartDate" and "ValidityEndDate".

2. Create an Analytical Dimension with the CDS View.

3. Make sure that the Semantic Value of "BusinessDate.From" and "BusinessDate.To" are ON.

4. With this Analytical Dimension, create an Analytical Query, these two date fields are not available in the list of Field Selection tab.


Resolution

Set the Semantic Value of "BusinessDate.From" and "BusinessDate.To" to OFF in the Analytical Dimension.

Keywords

Date fields, ValidityStartDate, ValidityEndDate. , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem

Product

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