I_IBCCalendarDate

DDL: I_IBCCALENDARDATE Type: view_entity BASIC
17 Fields 1 Data Sources 2 Associations

Calendar Date

I_IBCCalendarDate is a Basic CDS View that provides data about "Calendar Date" in SAP S/4HANA. It reads from 1 data source (cuan_cal_tt_date) and exposes 17 fields with key field CalendarDate. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
cuan_cal_tt_date cuan_cal_tt_date from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_IBCCalendarMonth _IBCCalendarMonth _IBCCalendarMonth.CalendarMonth = cuan_cal_tt_date.calendarmonth
[1..1] I_IBCWeekDay _IBCWeekDay _IBCWeekDay.WeekDay = cuan_cal_tt_date.weekday

Annotations (10)

NameValueLevelField
EndUserText.label Calendar Date view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.technicalName IIBCCALENDARDATE view
ObjectModel.representativeKey CalendarDate view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Metadata.ignorePropagatedAnnotations true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY CalendarDate cuan_cal_tt_date calendardate Calendar Date
CalendarYear cuan_cal_tt_date calendaryear Year
CalendarQuarter cuan_cal_tt_date calendarquarter Calendar Quarter
CalendarMonth cuan_cal_tt_date calendarmonth Calendar Month
CalendarWeek cuan_cal_tt_date calendarweek Calendar Week
CalendarDay cuan_cal_tt_date calendarday Occur Day in a Month
YearMonth cuan_cal_tt_date yearmonth Year Month
YearQuarter cuan_cal_tt_date yearquarter Year Quarter
YearWeek cuan_cal_tt_date yearweek Year and Calendar Week
WeekDay cuan_cal_tt_date weekday Weekdays
FirstDayOfWeekDate cuan_cal_tt_date firstdayofweekdate First day of week date
FirstDayOfMonthDate cuan_cal_tt_date firstdayofmonthdate First Day of Month
LastDayOfMonthDate cuan_cal_tt_date lastdayofmonthdate Last Day of Month
CalendarDayOfYear cuan_cal_tt_date calendardayofyear Calendar day of year
YearDay cuan_cal_tt_date yearday Day of the year
_IBCWeekDay _IBCWeekDay
_IBCCalendarMonth _IBCCalendarMonth

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_IBCCalendarDate.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_IBCCalendarDate AS
SELECT
  cuan_cal_tt_date.calendardate AS CalendarDate,
  cuan_cal_tt_date.calendaryear AS CalendarYear,
  cuan_cal_tt_date.calendarquarter AS CalendarQuarter,
  cuan_cal_tt_date.calendarmonth AS CalendarMonth,
  cuan_cal_tt_date.calendarweek AS CalendarWeek,
  cuan_cal_tt_date.calendarday AS CalendarDay,
  cuan_cal_tt_date.yearmonth AS YearMonth,
  cuan_cal_tt_date.yearquarter AS YearQuarter,
  cuan_cal_tt_date.yearweek AS YearWeek,
  cuan_cal_tt_date.weekday AS WeekDay,
  cuan_cal_tt_date.firstdayofweekdate AS FirstDayOfWeekDate,
  cuan_cal_tt_date.firstdayofmonthdate AS FirstDayOfMonthDate,
  cuan_cal_tt_date.lastdayofmonthdate AS LastDayOfMonthDate,
  cuan_cal_tt_date.calendardayofyear AS CalendarDayOfYear,
  cuan_cal_tt_date.yearday AS YearDay
FROM cuan_cal_tt_date
LEFT OUTER JOIN I_IBCCalendarMonth AS _IBCCalendarMonth ON _IBCCalendarMonth.CalendarMonth = cuan_cal_tt_date.calendarmonth  -- association [1..1]
LEFT OUTER JOIN I_IBCWeekDay AS _IBCWeekDay ON _IBCWeekDay.WeekDay = cuan_cal_tt_date.weekday  -- association [1..1]
;

Learn More