_CALENDAR

9 Fields

_CALENDAR is an SAP database table in S/4HANA. It contains 9 fields.

Fields (9)

KeyField CDS FieldsUsed in Views
KEY CalendarMonth CalendarMonth 14
KEY CalendarQuarter CalendarQuarter 13
KEY CalendarYear CalendarYear,GoodsReceiptMaterialDocYear 17
KEY YearMonth YearMonth,YearPeriod 7
CalendarWeek CalendarWeek 13
FirstDayOfMonthDate FirstDayOfMonthDate 1
FirstDayOfWeekDate FirstDayOfWeekDate 1
YearQuarter YearQuarter 3
YearWeek YearWeek 6

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 _CALENDAR (
    CALENDARMONTH,
    CALENDARQUARTER,
    CALENDARYEAR,
    YEARMONTH,
    CALENDARWEEK,
    FIRSTDAYOFMONTHDATE,
    FIRSTDAYOFWEEKDATE,
    YEARQUARTER,
    YEARWEEK,
    PRIMARY KEY (CALENDARMONTH, CALENDARQUARTER, CALENDARYEAR, YEARMONTH)
);

Learn More