topic Re: CDS - Date calculation in Application Development and Automation Discussions

CDS - Date calculation

Former Member — Mon, 20 Jul 2015 14:36:04 GMT

Hi,

I'm trying to do som calculation with date type fields.

@AbapCatalog.sqlViewName: 'ZDEMOSDN'

@EndUserText.label: 'test'

define view ZDEMOSDN as select from aufk as a inner join afko as b

on a.aufnr = b.aufnr

{

key a.aufnr,

a.erdat - a.idat2 as date2

}

I'm getting the error messages:

Data type DATS is currently not supported in an arithmetic expression

Will this be supported in near future? Is there kind of workaround .

Regards,

Bart

Re: CDS - Date calculation

christian_seitel — Wed, 22 Jul 2015 07:53:47 GMT

There are functions like

dats_is_valid

dats_days_between

dats_add_days

dats_add_months

If they are not available yet in your current SP-release then there is no workaround as date-time calculations are very complex (just think of leap years or things like that)

Re: CDS - Date calculation

Former Member — Mon, 27 Jul 2015 14:58:11 GMT

Thanks Christian. Unfortunately
not available, because of SP-release.

Regards,

Bart

Re: CDS - Date calculation

Former Member — Tue, 16 Aug 2016 10:35:33 GMT

Hi Christian Seitel,

can we use $session.system_date as one of the parameter to dats_days_between function.

I tried it in cds view, I the following error

Function DATS_DAYS_BETWEEN: At position 2, only Expressions,Literals,Columns,Paths,Parameters allowed

please help me on this.

Re: CDS - Date calculation

christian_seitel — Tue, 13 Sep 2016 12:08:41 GMT

Usage of a parameter could serve as workaround:

define view ...

with parameters

sydat : abap.dats @<Environment.systemField: #SYSTEM_DATE

as select from svers

{

dats_days_between( $parameters.sydat, $parameters.sydat ) as delta

}

or a join with another view (wrapping $session.system_date as column)

define view ...

as select from svers

{

$session.system_date as system_date

}