_CALENDARDATE

19 Fields

_CALENDARDATE is an SAP database table in S/4HANA. It contains 19 fields.

Fields (19)

KeyField CDS FieldsUsed in Views
KEY YearMonth CalendarYearMonth,YearMonth 20
_CalendarMonth _CalendarMonth 18
_CalendarQuarter _CalendarQuarter 8
_CalendarYear _CalendarYear 18
_WeekDay _WeekDay 5
_YearMonth _YearMonth 5
CalendarDate CalendarDate,ValidOnDate 8
CalendarDay CalendarDay 5
CalendarDayOfYear CalendarDayOfYear 5
CalendarMonth CalendarMonth,EHSTaskMonth,PostingMonth 32
CalendarQuarter CalendarQuarter 27
CalendarWeek CalendarWeek,WarrantyClaimWeek 26
CalendarYear CalendarYear,EHSTaskYear 32
FirstDayOfMonthDate FirstDayOfMonthDate 7
FirstDayOfWeekDate FirstDayOfWeekDate,StartDate 9
WeekDay WeekDay 7
YearDay YearDay 5
YearQuarter CalendarYearQuarter,YearQuarter 15
YearWeek CalendarYearWeek,YearWeek 15

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _CALENDARDATE (
    YEARMONTH,
    _CALENDARMONTH,
    _CALENDARQUARTER,
    _CALENDARYEAR,
    _WEEKDAY,
    _YEARMONTH,
    CALENDARDATE,
    CALENDARDAY,
    CALENDARDAYOFYEAR,
    CALENDARMONTH,
    CALENDARQUARTER,
    CALENDARWEEK,
    CALENDARYEAR,
    FIRSTDAYOFMONTHDATE,
    FIRSTDAYOFWEEKDATE,
    WEEKDAY,
    YEARDAY,
    YEARQUARTER,
    YEARWEEK,
    PRIMARY KEY (YEARMONTH)
);

Learn More