P_CalendarDate

DDL: P_CALENDARDATE SQL: PMMCALENDATE Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS

Calendar Date

P_CalendarDate is a Consumption CDS View that provides data about "Calendar Date" in SAP S/4HANA. It reads from 1 data source (I_CalendarDate) and exposes 20 fields. Part of development package ODATA_MM_ANALYTICS.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_CalendarDate I_CalendarDate from

Parameters (1)

NameTypeDefault
P_Date sydate

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PMMCALENDATE view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Calendar Date view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (20)

KeyFieldSource TableSource FieldDescription
CalendarDate I_CalendarDate CalendarDate
CalendarYear I_CalendarDate CalendarYear
CalendarQuarter I_CalendarDate CalendarQuarter
CalendarMonth I_CalendarDate CalendarMonth
CalendarWeek I_CalendarDate CalendarWeek
CalendarDay I_CalendarDate CalendarDay
YearMonth I_CalendarDate YearMonth
YearQuarter I_CalendarDate YearQuarter
YearWeek I_CalendarDate YearWeek
WeekDay I_CalendarDate WeekDay
FirstDayOfWeekDate I_CalendarDate FirstDayOfWeekDate
FirstDayOfMonthDate I_CalendarDate FirstDayOfMonthDate
CalendarDayOfYear I_CalendarDate CalendarDayOfYear
YearDay I_CalendarDate YearDay
_CalendarMonth I_CalendarDate _CalendarMonth
_CalendarQuarter I_CalendarDate _CalendarQuarter
_CalendarYear I_CalendarDate _CalendarYear
_WeekDay I_CalendarDate _WeekDay
_YearMonth I_CalendarDate _YearMonth
DaysBetween 
@AbapCatalog.sqlViewName: 'PMMCALENDATE'
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
@VDM.private : true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Calendar Date'
@VDM.viewType : #CONSUMPTION
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view P_CalendarDate with parameters 
    P_Date : sydate
as select from I_CalendarDate 
{ 
    I_CalendarDate.CalendarDate,
    I_CalendarDate.CalendarYear, 
    I_CalendarDate.CalendarQuarter, 
    I_CalendarDate.CalendarMonth, 
    I_CalendarDate.CalendarWeek, 
    I_CalendarDate.CalendarDay, 
    I_CalendarDate.YearMonth, 
    I_CalendarDate.YearQuarter, 
    I_CalendarDate.YearWeek, 
    I_CalendarDate.WeekDay, 
    I_CalendarDate.FirstDayOfWeekDate, 
    I_CalendarDate.FirstDayOfMonthDate, 
    I_CalendarDate.CalendarDayOfYear, 
    I_CalendarDate.YearDay,
    /* Associations */
    I_CalendarDate._CalendarMonth, 
    I_CalendarDate._CalendarQuarter, 
    I_CalendarDate._CalendarYear, 
    I_CalendarDate._WeekDay, 
    I_CalendarDate._YearMonth,
    
    dats_days_between(I_CalendarDate.CalendarDate, :P_Date) as DaysBetween 
}

Learn More