DATE

9 Fields

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

Fields (9)

KeyField CDS FieldsUsed in Views
KEY CalendarDate CalendarDate,CalendarDay 9
CalendarMonth CalendarMonth 2
CalendarQuarter CalendarQuarter,Quarter 2
CalendarWeek CalendarWeek 2
CalendarYear CalendarYear,TranYear 5
WeekDay WeekDay 1
YearMonth CalendarMonth,YearMonth 4
YearQuarter CalendarQuarter,YearQuarter 4
YearWeek WeekDay,YearWeek 4

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 DATE (
    CALENDARDATE,
    CALENDARMONTH,
    CALENDARQUARTER,
    CALENDARWEEK,
    CALENDARYEAR,
    WEEKDAY,
    YEARMONTH,
    YEARQUARTER,
    YEARWEEK,
    PRIMARY KEY (CALENDARDATE)
);

Learn More