CALENDARDATE

25 Fields

CALENDARDATE is an SAP database table in S/4HANA. It contains 25 fields.

Fields (25)

KeyField CDS FieldsUsed in Views
KEY CalendarDate CalendarDate 2
KEY KeyDate KeyDate 10
_CalendarMonth _CalendarMonth 1
_CalendarYear _CalendarYear 1
CalendarDay CalendarDay,ItemCreationCalendarDay 4
CalendarMonth CalendarMonth,ItemCreationCalendarMonth 6
CalendarQuarter CalendarQuarter,ItemCreationCalendarQuarter 5
CalendarWeek CalendarWeek,ItemCreationCalendarWeek 5
CalendarYear CalendarYear 4
CON_DAY CON_DAY 5
CON_MONTH_END CON_MONTH_END 4
CON_MONTH_START CON_MONTH_START 4
CON_QUARTER_END CON_QUARTER_END 4
CON_QUARTER_START CON_QUARTER_START 4
CON_WEEK_END CON_WEEK_END 4
CON_WEEK_START CON_WEEK_START 4
CON_YEAR_END CON_YEAR_END 4
CON_YEAR_START CON_YEAR_START 4
CreditLineReportingPeriod CreditLineReportingPeriod 8
FirstDayOfMonthDate FirstDayOfMonthDate 2
MaturityEndDate MaturityEndDate 1
MaturityStartDate MaturityStartDate 1
YearMonth YearMonth 1
YearQuarter YearQuarter 1
YearWeek CreationDateYearWeek,YearWeek 2

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 (
    CALENDARDATE,
    KEYDATE,
    _CALENDARMONTH,
    _CALENDARYEAR,
    CALENDARDAY,
    CALENDARMONTH,
    CALENDARQUARTER,
    CALENDARWEEK,
    CALENDARYEAR,
    CON_DAY,
    CON_MONTH_END,
    CON_MONTH_START,
    CON_QUARTER_END,
    CON_QUARTER_START,
    CON_WEEK_END,
    CON_WEEK_START,
    CON_YEAR_END,
    CON_YEAR_START,
    CREDITLINEREPORTINGPERIOD,
    FIRSTDAYOFMONTHDATE,
    MATURITYENDDATE,
    MATURITYSTARTDATE,
    YEARMONTH,
    YEARQUARTER,
    YEARWEEK,
    PRIMARY KEY (CALENDARDATE, KEYDATE)
);

Learn More