Multiple parameter values in CDS view

Hi, We are working on ABAP CDS views on S4HANA 1610. We have a requirement to pass multiple values to a parameter and then filter data on it. Basically I am using this parameter in WHERE statement. I don't see IN clause is supported in ABAP CDS views. So what is the best way to achieve this.

I cannot use RANGE Means between to restrict data. My parameter values are individual text i.e. 'XXXX','YYYY' etc

We can use filter with OR in OData to achieve this at OData layer but I think its best if I can filter data at DB level.

Thanks,

Kalpesh