CURRENTCALENDARDATE

DDL: CURRENTCALENDARDATE SQL: CURRCALENDARDATE Type: view Package: VDM_CAL

Current Calendar Date

CURRENTCALENDARDATE is a CDS View that provides data about "Current Calendar Date" in SAP S/4HANA. It reads from 1 data source (I_CalendarDate) and exposes 36 fields with key field CalendarDate. Part of development package VDM_CAL.

1 data source(s) 36 fields

Data Sources (1)

SourceAliasJoin Type
I_CalendarDate I_CalendarDate from

Parameters (17)

NameTypeDefault
P_DateFunctionType datefunctiontype
P_DateFunctionGranularity datefunctiongranularity
P_DateFunctionCalendarType datefunctioncalendartype
P_DateFunctionStartPoint datefunctionstartpoint
P_DateFunctionStartOffsetValue datefunctionstartoffsetvalue
P_DateFuncStartRelativeOffset datefunctionstartreloffset
P_DateFunctionStartOffsetUnit datefunctionstartoffsetunit
P_DateFuncStartRelOffsetUnit datefunctionstartreloffsetunit
P_DateFunctionStartYearOffset datefunctionstartyearoffset
P_DateFunctionStartFixedDate datefunctionstartfixeddate
P_DateFunctionEndPoint datefunctionendpoint
P_DateFunctionEndOffsetValue datefunctionendoffsetvalue
P_DateFunctionEndRelOffset datefunctionendreloffset
P_DateFunctionEndOffsetUnit datefunctionendoffsetunit
P_DateFuncEndRelOffsetUnit datefunctionendreloffsetunit
P_DateFunctionEndYearOffset datefunctionendyearoffset
P_DateFunctionEndFixedDate datefunctionendfixeddate

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName CURRCALENDARDATE view
EndUserText.label Current Calendar Date view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY CalendarDate CalendarDate
DateFunctionType
DateFunctionGranularity
DateFunctionCalendarType
DateFunctionStartPoint
DateFunctionStartOffsetValue
DateFuncStartRelativeOffset
DateFunctionStartOffsetUnit
DateFunctionStartRelOffsetUnit
DateFunctionStartYearOffset
DateFunctionStartFixedDate
DateFunctionEndPoint
DateFunctionEndOffsetValue
DateFunctionEndRelOffset
DateFunctionEndOffsetUnit
DateFunctionEndRelOffsetUnit
DateFunctionEndYearOffset
DateFunctionEndFixedDate
CalendarDay CalendarDay
CalendarDayOfYear CalendarDayOfYear
CalendarMonth CalendarMonth
CalendarQuarter CalendarQuarter
CalendarWeek CalendarWeek
CalendarYear CalendarYear
FirstDayOfMonthDate FirstDayOfMonthDate
FirstDayOfWeekDate FirstDayOfWeekDate
WeekDay WeekDay
YearDay YearDay
YearMonth YearMonth
YearQuarter YearQuarter
YearWeek YearWeek
_CalendarMonth _CalendarMonth
_CalendarQuarter _CalendarQuarter
_CalendarYear _CalendarYear
_WeekDay _WeekDay
_YearMonth _YearMonth 
@AbapCatalog.sqlViewName: 'CURRCALENDARDATE'
@EndUserText.label: 'Current Calendar Date'
@ObjectModel.usageType.serviceQuality:  #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view CURRENTCALENDARDATE
  with parameters
    P_DateFunctionType : datefunctiontype, 
    P_DateFunctionGranularity : datefunctiongranularity,
    P_DateFunctionCalendarType : datefunctioncalendartype,
    P_DateFunctionStartPoint : datefunctionstartpoint, 
    P_DateFunctionStartOffsetValue : datefunctionstartoffsetvalue,
    P_DateFuncStartRelativeOffset : datefunctionstartreloffset,
    P_DateFunctionStartOffsetUnit : datefunctionstartoffsetunit,
    P_DateFuncStartRelOffsetUnit : datefunctionstartreloffsetunit,
    P_DateFunctionStartYearOffset : datefunctionstartyearoffset,
    P_DateFunctionStartFixedDate : datefunctionstartfixeddate,
    P_DateFunctionEndPoint : datefunctionendpoint,
    P_DateFunctionEndOffsetValue : datefunctionendoffsetvalue,
    P_DateFunctionEndRelOffset : datefunctionendreloffset,
    P_DateFunctionEndOffsetUnit : datefunctionendoffsetunit,
    P_DateFuncEndRelOffsetUnit : datefunctionendreloffsetunit,
    P_DateFunctionEndYearOffset : datefunctionendyearoffset,
    P_DateFunctionEndFixedDate : datefunctionendfixeddate

 as select from I_CalendarDate {
   key CalendarDate, 
  $parameters.P_DateFunctionType as DateFunctionType,
    $parameters.P_DateFunctionGranularity as DateFunctionGranularity,
    $parameters.P_DateFunctionCalendarType as DateFunctionCalendarType,
    $parameters.P_DateFunctionStartPoint as DateFunctionStartPoint,
    $parameters.P_DateFunctionStartOffsetValue as DateFunctionStartOffsetValue,
    $parameters.P_DateFuncStartRelativeOffset as DateFuncStartRelativeOffset,
    $parameters.P_DateFunctionStartOffsetUnit as DateFunctionStartOffsetUnit,
    $parameters.P_DateFuncStartRelOffsetUnit as DateFunctionStartRelOffsetUnit,
    $parameters.P_DateFunctionStartYearOffset as DateFunctionStartYearOffset,
    $parameters.P_DateFunctionStartFixedDate as DateFunctionStartFixedDate,
    $parameters.P_DateFunctionEndPoint as DateFunctionEndPoint,
    $parameters.P_DateFunctionEndOffsetValue as DateFunctionEndOffsetValue,
    $parameters.P_DateFunctionEndRelOffset as DateFunctionEndRelOffset,
    $parameters.P_DateFunctionEndOffsetUnit as DateFunctionEndOffsetUnit,
    $parameters.P_DateFuncEndRelOffsetUnit as DateFunctionEndRelOffsetUnit,
    $parameters.P_DateFunctionEndYearOffset as DateFunctionEndYearOffset,
    $parameters.P_DateFunctionEndFixedDate as DateFunctionEndFixedDate,
  CalendarDay, 
  CalendarDayOfYear, 
  CalendarMonth, 
  CalendarQuarter, 
  CalendarWeek, 
  CalendarYear, 
  FirstDayOfMonthDate, 
  FirstDayOfWeekDate, 
  WeekDay, 
  YearDay, 
  YearMonth, 
  YearQuarter, 
  YearWeek,
  /* Associations */
  _CalendarMonth, 
  _CalendarQuarter, 
  _CalendarYear, 
  _WeekDay, 
  _YearMonth
} where CalendarDate = $session.system_date

Learn More