3759381 - Parameter "P_KeyDate" Is Not Visible in the Filters of Custom Analytical Query

You have created a custom analytical query using standard CDS view "I_APJRNLENTRITMAGINGGRID", however, when editing the query, you observe that parameter "P_KeyDate" does not show in the filters of the query.

SAP S/4HANA Cloud Public Edition

1. Open the app Custom Analytical Queries and Services.
2. Select the affected custom analytical query.
3. Go to the Filters tab.
4. Observe that the parameter "P_KeyDate" is not listed.

The parameter "P_KeyDate" is defined using the system field SYDATE without derivation or default value annotations, so the system assigns the current date and treats the parameter as hidden at runtime.

You can create a custom CDS view with data source "I_APJRNLENTRITMAGINGGRID", and recreate the parameter "P_KeyDate". After published the custom CDS view, create a new custom analytical query using the CDS view as a data source. Steps as below:

1. Open the app Custom CDS Views.
2. Create a new custom CDS view with an analytical scenario (for example, Analytical Cube) based on data source "I_APJRNLENTRITMAGINGGRID".
3. Navigate to the Parameters tab of the custom CDS view.
4. Delete the parameter P_KeyDate.
5. Add a new parameter with the same name and label as the deleted parameter. (Name and Label: P_KeyDate )
6. Adjust the CDS view as required and publish it.
7. Create a new custom analytical query using this custom CDS view as a data source.
8. Open the query and verify that P_KeyDate is now available under Filters tab.

KB1371513 - P_KeyDate not visible in custom analytical query and preview defaults to current date – SAP S/4HANA Cloud Public Edition

key date, P_KeyDate, parameter not visible, filters tab, custom analytical query, query filters, cds view, custom cds views, analytical cube, data source parameter, filter parameter, runtime parameter , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , Problem