topic Re: Current date in ABAP CDS views in Application Development and Automation Discussions

Current date in ABAP CDS views

anita_dixit — Thu, 16 Jul 2015 10:50:27 GMT

Hi,

I am trying to get current system date into a variable (in the form of parameter) as shown below :

What I need is : If the end date is less than today's date, it's fine(continue with the end date) else replace it with today's date (that's get it from the system's date) . But I am getting error such that it is not supported.

Can anyone suggest a workaround solution at the earliest ?

Thanks & Kind Regards,

Anita

Re: Current date in ABAP CDS views

michaelwurst — Thu, 11 Aug 2016 14:36:34 GMT

Hi Anita,

I think one (dirty) workaround in your scenario could be to define a second CDS view with identical interface as wrapper and use the parameter as colum output. Maybe you can try something like this (untested):

1. Adjust your CDS view by adding a column with system date, e.g.:

define view ZEMP_YEARS_1

with parameters

@Environment.systemField: #SYSTEM_DATE

@EndUserText.label: 'Test'

p_start_date : abap.dats

as select from ZAD_EMPSTAFFING{

-- your column fields...

$parameters.p_start_date as sydatum

}

2. Create new CDS view, e.g.:

define view ZEMP_YEARS_1_WRAP

with parameters

@Environment.systemField: #SYSTEM_DATE

@EndUserText.label: 'Test'

p_start_date : abap.dats

as select from ZEMP_YEARS_1( p_start_date: $parameters.p_start_date ){

-- your column fields...

case

when ZEMP_YEARS_1.EndDate < ZEMP_YEARS_1.sydatum then ZEMP_YEARS_1.EndDate

else ZEMP_YEARS_1.sydatum end as EndDateU

}

I hope this helps and all the best,

Michael

Re: Current date in ABAP CDS views

retired_member — Fri, 12 Aug 2016 06:03:05 GMT

Hi Anita,

Unfortunately, result1, result2, ... of a CASE expression cannot be parameters (up to now).

But, hey, they can be CAST expressions. Therefore, a cheap trick that gives no error in 7.50:

@AbapCatalog.sqlViewName: 'KELLERH_V_TEST'

define view kellerh_cds_test

with parameters

@Environment.systemField: #SYSTEM_DATE

p_start_date : abap.dats

as select from demo_expressions

{

dats1,

dats2,

case when dats2 < $parameters.p_start_date

then dats2

else cast( $parameters.p_start_date as abap.dats )

end as res

}

Cheers

Horst

Re: Current date in ABAP CDS views

anita_dixit — Fri, 12 Aug 2016 06:25:49 GMT

Thanks. I did it long time back.

Re: Current date in ABAP CDS views

anita_dixit — Fri, 12 Aug 2016 06:26:31 GMT

Thanks a lot . It worked.

Re: Current date in ABAP CDS views

Former Member — Fri, 26 Aug 2016 08:06:51 GMT

Hello,

Is there any way to do arithmatic on date and time fields?

would you pls let me know syntax.

normal CDS view or Query type CDS view (@Analytics.query: true)

Re: Current date in ABAP CDS views

retired_member — Fri, 26 Aug 2016 08:17:37 GMT

Since 7.50 there are built-in functions for this.

Re: Current date in ABAP CDS views

anita_dixit — Thu, 01 Sep 2016 06:23:46 GMT

Hi Saif,

I am using normal CDS view (dataCategory: #CUBE).

Re: Current date in ABAP CDS views

former_member597044 — Sat, 18 Sep 2021 05:51:42 GMT

Hi Experts,
Without using Parameters , do we get the system field in Plain CDS View.

Thanks
Sumanth

Re: Current date in ABAP CDS views

carlos_candido — Fri, 24 Sep 2021 00:15:13 GMT

Hi Sumanth,

Maybe, it can help.

"tstmp_to_tims(TSTMP_CURRENT_UTCTIMESTAMP(), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL') as SYSTIME ,"

Kind Regards,

Carlos

Re: Current date in ABAP CDS views

dob1 — Wed, 01 Mar 2023 15:47:02 GMT

I know this question is old, but I just had the same "challenge".

It depends on the release you are working on.

Release 7.51 and higher provides a session-variable that gives us directly the current date.

$session.system_date

https://help.sap.com/doc/abapdocu_751_index_htm/7.51/en-us/abencds_f1_session_variable.htm