Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

CDS Query: Parameter used in WHERE clause

As an alternative to the filter annotation, you can introduce a parameter and use it in the where clause. In that case only single values are supported. The generated BW variable is mandatory.

Simple Example: CDS query which uses a parameter and a fix filter in the WHERE clause:

Whe we run this query in RSRT, a corresponding variable popup appears. We also use the debug function 'Disyplay SQL/SAP Hana Query' in order to get the Analytics API statement displayed: 

So, we can see that the filters defined in the CDS view are finally written into the WHERE clause of the statement the query ahs generated in order to retrieve the data from the view of type #CUBE.

  • No labels