SCAL_TT_MONTH

Transparent Table System Table (SAP only)
8 Fields 1 CDS Views

Month

SCAL_TT_MONTH is an SAP database table in S/4HANA. Month. It contains 8 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_YearMonth view from BASIC Year Month

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY calendaryear calendaryear Calendar Year
KEY calendarmonth calendarmonth Calendar Month
calendarquarter calendarquarter Calendar Quarter
halfyear vdm_halfyear Half Year
numberofdays numberofdays Number of Days
yearmonth vdm_yearmonth Year Month
firstdayofmonthdate firstdayofmonthdate First Day of Month
lastdayofmonthdate lastdayofmonthdate Last Day of Month

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.

-- Month
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SCAL_TT_MONTH (
    CALENDARYEAR,         -- Calendar Year [calendaryear]
    CALENDARMONTH,        -- Calendar Month [calendarmonth]
    CALENDARQUARTER,      -- Calendar Quarter [calendarquarter]
    HALFYEAR,             -- Half Year [vdm_halfyear]
    NUMBEROFDAYS,         -- Number of Days [numberofdays]
    YEARMONTH,            -- Year Month [vdm_yearmonth]
    FIRSTDAYOFMONTHDATE,  -- First Day of Month [firstdayofmonthdate]
    LASTDAYOFMONTHDATE,   -- Last Day of Month [lastdayofmonthdate]
    PRIMARY KEY (CALENDARYEAR, CALENDARMONTH)
);

Learn More