CALENDAR

10 Fields

CALENDAR is an SAP database table in S/4HANA. It contains 10 fields.

Fields (10)

KeyField CDS FieldsUsed in Views
KEY CalendarDate CalendarDate 3
CalendarMonth CalendarMonth 3
CalendarQuarter CalendarQuarter 2
CalendarWeek CalendarWeek 2
CalendarYear CalendarYear 3
FiscalPeriod FiscalPeriod 3
FiscalYear FiscalYear 3
FiscalYearPeriod FiscalYearPeriod 3
LastDayOfMonthDate LastDayOfMonth 1
YearMonth YearMonth 1

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 (
    CALENDARDATE,
    CALENDARMONTH,
    CALENDARQUARTER,
    CALENDARWEEK,
    CALENDARYEAR,
    FISCALPERIOD,
    FISCALYEAR,
    FISCALYEARPERIOD,
    LASTDAYOFMONTHDATE,
    YEARMONTH,
    PRIMARY KEY (CALENDARDATE)
);

Learn More