I_CalendarDate

DDL: I_CALENDARDATE SQL: ICALENDARDATE Type: view BASIC
22 Fields 1 Data Sources 7 Associations

Date

I_CalendarDate (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_CalendarDate is a Basic CDS View (Dimension) that provides data about "Date" in SAP S/4HANA. It reads from 1 data source (scal_tt_date) and exposes 22 fields with key field CalendarDate. It has 7 associations to related views.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentCA-GTF-DF
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
scal_tt_date scal_tt_date from

Associations (7)

CardinalityTargetAliasCondition
[1..1] I_CalendarMonth _CalendarMonth _CalendarMonth.CalendarMonth = scal_tt_date.calendarmonth
[1..1] I_CalendarQuarter _CalendarQuarter _CalendarQuarter.CalendarQuarter = scal_tt_date.calendarquarter
[1..1] I_CalendarYear _CalendarYear _CalendarYear.CalendarYear = scal_tt_date.calendaryear
[1..1] I_WeekDay _WeekDay _WeekDay.WeekDay = scal_tt_date.weekday
[1..1] I_YearMonth _YearMonth _YearMonth.YearMonth = scal_tt_date.yearmonth
[1..1] I_YEARWEEK _YearWeek _YearWeek.YearWeek = scal_tt_date.yearweek
[1..1] I_CALENDARWEEK _CalendarWeek _CalendarWeek.CalendarWeek = scal_tt_date.calendarweek

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey CalendarDate view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.sqlViewName ICALENDARDATE view
AbapCatalog.preserveKey true view
EndUserText.label Date view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view

Fields (22)

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

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_CalendarDate.
-- 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.
-- SQL view name: ICALENDARDATE

CREATE VIEW I_CalendarDate AS
SELECT
  scal_tt_date.calendardate AS CalendarDate,
  scal_tt_date.calendaryear AS CalendarYear,
  scal_tt_date.calendarquarter AS CalendarQuarter,
  scal_tt_date.calendarmonth AS CalendarMonth,
  scal_tt_date.calendarweek AS CalendarWeek,
  scal_tt_date.calendarday AS CalendarDay,
  scal_tt_date.yearmonth AS YearMonth,
  scal_tt_date.yearquarter AS YearQuarter,
  scal_tt_date.yearweek AS YearWeek,
  scal_tt_date.weekday AS WeekDay,
  scal_tt_date.firstdayofweekdate AS FirstDayOfWeekDate,
  scal_tt_date.firstdayofmonthdate AS FirstDayOfMonthDate,
  scal_tt_date.lastdayofmonthdate AS LastDayOfMonthDate,
  scal_tt_date.calendardayofyear AS CalendarDayOfYear,
  scal_tt_date.yearday AS YearDay
FROM scal_tt_date
LEFT OUTER JOIN I_CalendarMonth AS _CalendarMonth ON _CalendarMonth.CalendarMonth = scal_tt_date.calendarmonth  -- association [1..1]
LEFT OUTER JOIN I_CalendarQuarter AS _CalendarQuarter ON _CalendarQuarter.CalendarQuarter = scal_tt_date.calendarquarter  -- association [1..1]
LEFT OUTER JOIN I_CalendarYear AS _CalendarYear ON _CalendarYear.CalendarYear = scal_tt_date.calendaryear  -- association [1..1]
LEFT OUTER JOIN I_WeekDay AS _WeekDay ON _WeekDay.WeekDay = scal_tt_date.weekday  -- association [1..1]
LEFT OUTER JOIN I_YearMonth AS _YearMonth ON _YearMonth.YearMonth = scal_tt_date.yearmonth  -- association [1..1]
LEFT OUTER JOIN I_YEARWEEK AS _YearWeek ON _YearWeek.YearWeek = scal_tt_date.yearweek  -- association [1..1]
LEFT OUTER JOIN I_CALENDARWEEK AS _CalendarWeek ON _CalendarWeek.CalendarWeek = scal_tt_date.calendarweek  -- association [1..1]
;

Learn More