Symptom
User is working with Custom CDS view and attempting to use function DATS_DAYS_BETWEEN in a calculated field with session date $session.system_date. The variable is causing error:
Function DATS_DAYS_BETWEEN: At position 1, only Expressions, Literals, Columns, Paths, Parameters allowed
Environment
SAP S/4HANA Cloud Public Edition 1808
Reproducing the Issue
-
Create Custom CDS View
- Create calculated field
- Use Function
DATS_DAYS_BETWEEN($session.system_date,$session.system_date)
- Observe Error Function DATS_DAYS_BETWEEN: At position 1, only Expressions, Literals, Columns, Paths, Parameters allowed
Cause
Session variable $session.system_date is not valid type for function DATS_DAYS_BETWEEN.
Resolution
Cast $session.system_date to proper type for function DATS_DAYS_BETWEEN
DATS_DAYS_BETWEEN(cast( $session.system_date as ABAP.DATS ), cast( $session.system_date as ABAP.DATS ))
Keywords
DATS_DAYS_BETWEEN $session.system_date system_date , KBA , BC-SRV-APS-GKE , Generic CDS Key User Editor , Problem