How to get all the dates in a month by passing year and month in CDS views?

[former_member587863]

Hi all,

I am receiving values of month and year from the UI. Based on that how to get all the dates in a month.

Then i have to pass all the dates to CDS Query.

Thanks,

Jagapathi.

[mhappe]

Create an own table functions with specified parameter. Within the table function write some SQL script code to return all dates within the specified period:

[filipn]

Hello,

you may have a look at CDS Views with parameters. I found some blog here: https://blogs.sap.com/2016/06/08/abap-cds-view-with-input-parameters/

can you have a look if it helps?

Regards,

Filip