YTD|MTD|QTD in SAP HANA CDs Views using date function

[akashkannan22]

Introduction

In SAP HANA - CDS views need some customization to have the feature of Date Function in Parameter.
In this blog, we will learn on how to add date functions in custom cds views.

Environment
HANA Studio/ Eclipse

Solution
Let’s assume that you have a view with Posting Date and you need to Implement Date function on Posting Date, then follow below steps-
 

1. There is a Standard CDS view - C_SglGregorianCalDateFunction which is based on datefunction_val transparent table.

This table contains precalculated Start Date & End Date for respective date with date functions.

1. C_SglGregorianCalDateFunction - Views need input parameter as Date Function & Language

1. Let’s join this CDS view with our view on posting date-

1. In your consumption query use below code for value help on date function parameter

1. Report output will be as below-

• Date Function Prompt Screen-

• Previous Year To Date - Date Function

• Previous Year Date Function