topic Re: Access filter parameters inside CDS virtual element calculated class in Application Development and Automation Discussions

Access filter parameters inside CDS virtual element calculated class

Chandruu0208 — Wed, 21 Oct 2020 04:23:39 GMT

Hi All,

The scenario is that, I am passing two filter parameters (BEGDA & ENDDA) to my CDS based OData service. I have a virtual element for which the data is obtained from a calculated class.

When I call the CDS by passing the filters (BEGDA & ENDDA) the CDS view is called and which in turn calls the class I had created for the virtual element. Inside this class I am try to call an FM which requires the BEGDA and ENDDA as the input parameters.

I am unable to access the dates (BEGDA and ENDDA) that is passed to the CDS entity set inside by virtual element calculated class.
Can anyone help with a solution?

Thanks in advance,

Regards

Re: Access filter parameters inside CDS virtual element calculated class

tnns — Wed, 26 Jan 2022 07:54:27 GMT

HI chandruu0208,

have you found a solution for this problem?

Re: Access filter parameters inside CDS virtual element calculated class

lei_li — Wed, 31 May 2023 06:20:27 GMT

Hi Chandrasekhar, have you found solutoin on this 🙂

Re: Access filter parameters inside CDS virtual element calculated class

Chandruu0208 — Fri, 09 Jun 2023 10:46:07 GMT

Hi Lei Li, Unfortunately it is not possible to pass filters in this approach. Instead we need to create an unmanaged query to achieve this.

Regards

Re: Access filter parameters inside CDS virtual element calculated class

sushanthherlep — Thu, 26 Oct 2023 03:30:48 GMT

Hello Chandrashekar,

The reply is quite late. May be you can check the Filter Push down approach as mentioned in this blog.

https://blogs.sap.com/2021/05/14/filters-push-down-in-abap-cds-views-for-a-better-performance-of-the-application/

Regards,

Sushanth Herle