Access filter parameters inside CDS virtual element calculated class

[Chandruu0208]

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

[tnns]

HI chandruu0208,

have you found a solution for this problem?

[lei_li]

Hi Chandrasekhar, have you found solutoin on this 🙂

[Chandruu0208]

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

[sushanthherlep]

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

Regards,

Sushanth Herle