Registration

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

Use annotation:

@Consumption.filter.selectionType: #RANGE or #INTERVAL

@Consumption.filter.multipleSelections:true

to generate a selection option variable in a CDS query.

A CDS query is defined as below:

Run query 2CZGL_QT3V in transaction RSRT, there is a selection option variable defined on Country. You could exclude some values, or use contain patterns in this variable. For example, here we exclude all countries start with 'C'.

The query result is:

It is not possible to set an EXcluding default value for a @Consumption.filter variable. Only Including default value is supported.

However, by using parameter, it is possible to exclude a default value. But the CDS query can only always exclude some parameter value in runtime.

 

  • No labels