Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Aug 06, 2018 at 02:08 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 04, 2018 at 08:02 AM

    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:


    screenshot.jpg (127.6 kB)
    Add comment
    10|10000 characters needed characters exceeded