SCAL_TT_DATE

Transparent Table System Table (SAP only)
16 Fields 3 CDS Views

Date table containing dates from 01011900 to 31129999

SCAL_TT_DATE is an SAP database table in S/4HANA. Date table containing dates from 01011900 to 31129999. It contains 16 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CalendarDate view from BASIC Date
m_v_inforecord_sos view inner MM-PUR: CDS View for SOS
m_v_outline_agreement_sos view inner MM-PUR: CDS View for SOS

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY calendardate CALENDARDATE Calendar Date
calendaryear CALENDARYEAR Calendar Year
calendarmonth CALENDARMONTH Calendar Month
calendarquarter CALENDARQUARTER Calendar Quarter
calendarweek CALENDARWEEK Calendar Week
calendarday CALENDARDAY Calendar Day
weekday VDM_WEEKDAY Week Day
yearweek VDM_YEARWEEK Year and Calendar Week
yearquarter VDM_YEARQUARTER Year Quarter
yearmonth VDM_YEARMONTH Year Month
firstdayofmonthdate FIRSTDAYOFMONTHDATE First Day of Month
lastdayofmonthdate LASTDAYOFMONTHDATE Last Day of Month
halfyear VDM_HALFYEAR Half Year
firstdayofweekdate VDM_FIRSTDAYOFWEEKDATE First day of week date
calendardayofyear VDM_CALENDARDAYOFYEAR Calendar day of year
yearday VDM_YEARDAY Day of the year

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.

-- Date table containing dates from 01011900 to 31129999
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SCAL_TT_DATE (
    CALENDARDATE,         -- Calendar Date [CALENDARDATE]
    CALENDARYEAR,         -- Calendar Year [CALENDARYEAR]
    CALENDARMONTH,        -- Calendar Month [CALENDARMONTH]
    CALENDARQUARTER,      -- Calendar Quarter [CALENDARQUARTER]
    CALENDARWEEK,         -- Calendar Week [CALENDARWEEK]
    CALENDARDAY,          -- Calendar Day [CALENDARDAY]
    WEEKDAY,              -- Week Day [VDM_WEEKDAY]
    YEARWEEK,             -- Year and Calendar Week [VDM_YEARWEEK]
    YEARQUARTER,          -- Year Quarter [VDM_YEARQUARTER]
    YEARMONTH,            -- Year Month [VDM_YEARMONTH]
    FIRSTDAYOFMONTHDATE,  -- First Day of Month [FIRSTDAYOFMONTHDATE]
    LASTDAYOFMONTHDATE,   -- Last Day of Month [LASTDAYOFMONTHDATE]
    HALFYEAR,             -- Half Year [VDM_HALFYEAR]
    FIRSTDAYOFWEEKDATE,   -- First day of week date [VDM_FIRSTDAYOFWEEKDATE]
    CALENDARDAYOFYEAR,    -- Calendar day of year [VDM_CALENDARDAYOFYEAR]
    YEARDAY,              -- Day of the year [VDM_YEARDAY]
    PRIMARY KEY (CALENDARDATE)
);

Learn More