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:
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.