topic Multiple parameter values in CDS view in Application Development and Automation Discussions

Multiple parameter values in CDS view

kalpesh_pandey — Fri, 08 Mar 2019 15:55:59 GMT

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

Re: Multiple parameter values in CDS view

former_member564522 — Fri, 26 Apr 2019 04:43:16 GMT

Hi Kalpesh,

You may use Table function along with AMDP. check below blow for more informatin.

https://blogs.sap.com/2015/10/21/abap-news-for-release-750-cds-table-functions-implemented-by-amdp/

Regards

Himanshu

Re: Multiple parameter values in CDS view

kalpesh_pandey — Tue, 09 Jul 2019 19:07:13 GMT

Thanks. I guess I should have mentioned that once we expose CDS views as OData they are provisioned in Dell Boomi and then consumsed by Tableau. We don't have option as AMDP. As it cannot be exposed as OData easily. Users are outside of SAP system.

Thx

Re: Multiple parameter values in CDS view

DoanManhQuynh — Wed, 10 Jul 2019 01:38:43 GMT

Can you use BETWEEN instead?

I'm thinking of using @Consumption.derivation along with @Consumption.filter for elements but i dont know is it accept multiple value or not, you could give it a try

Re: Multiple parameter values in CDS view

kalpesh_pandey — Thu, 11 Jul 2019 04:32:37 GMT

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

I provided one filter to pass. If business needs data for multiple then they have to call those many times. Each time with single filter.

Thx