CURRENTCALENDARDATE

CDS View

Current Calendar Date

CURRENTCALENDARDATE is a CDS View in S/4HANA. Current Calendar Date. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
DATEFUNC_CONFIG_SIMULATE view from Non-Persisted DateFunction Configuration Simulation 
@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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE"
],
"ASSOCIATED":
[
"I_CALENDARMONTH",
"I_CALENDARQUARTER",
"I_CALENDARYEAR",
"I_WEEKDAY",
"I_YEARMONTH"
],
"BASE":
[
"I_CALENDARDATE"
],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More