CUAN_CAL_TT_DATE

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

Date table containing dates from 01011900 to 31129999

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_IBCCalendarDate view_entity from BASIC Calendar Date

Fields (16)

KeyField Data ElementDescription
KEY calendardate CUAN_CALENDARDATE Calendar Date
calendaryear CUAN_YEAR Calendar Year
calendarmonth CUAN_CALENDARMONTH Calendar Month
calendarquarter CUAN_CALENDARQUARTER Calendar Quarter
calendarweek CUAN_CALENDARWEEK Calendar Week
calendarday CUAN_CALENDARDAY Calendar Day
weekday CUAN_WEEKDAY Week Day
yearweek CUAN_YEARWEEK Year Week
yearquarter CUAN_YEARQUARTER Year Quarter
yearmonth CUAN_YEARMONTH Year Month
firstdayofmonthdate CUAN_FIRSTDAYOFMONTHDATE First Day of Month
lastdayofmonthdate CUAN_LASTDAYOFMONTHDATE Last Day of Month
halfyear CUAN_HALFYEAR Half Year
firstdayofweekdate CUAN_FIRSTDAYOFWEEKDATE First Day of Week
calendardayofyear CUAN_CALENDARDAYOFYEAR Calendar Day of Year
yearday CUAN_YEARDAY Year Day

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 CUAN_CAL_TT_DATE (
    CALENDARDATE,         -- Calendar Date [CUAN_CALENDARDATE]
    CALENDARYEAR,         -- Calendar Year [CUAN_YEAR]
    CALENDARMONTH,        -- Calendar Month [CUAN_CALENDARMONTH]
    CALENDARQUARTER,      -- Calendar Quarter [CUAN_CALENDARQUARTER]
    CALENDARWEEK,         -- Calendar Week [CUAN_CALENDARWEEK]
    CALENDARDAY,          -- Calendar Day [CUAN_CALENDARDAY]
    WEEKDAY,              -- Week Day [CUAN_WEEKDAY]
    YEARWEEK,             -- Year Week [CUAN_YEARWEEK]
    YEARQUARTER,          -- Year Quarter [CUAN_YEARQUARTER]
    YEARMONTH,            -- Year Month [CUAN_YEARMONTH]
    FIRSTDAYOFMONTHDATE,  -- First Day of Month [CUAN_FIRSTDAYOFMONTHDATE]
    LASTDAYOFMONTHDATE,   -- Last Day of Month [CUAN_LASTDAYOFMONTHDATE]
    HALFYEAR,             -- Half Year [CUAN_HALFYEAR]
    FIRSTDAYOFWEEKDATE,   -- First Day of Week [CUAN_FIRSTDAYOFWEEKDATE]
    CALENDARDAYOFYEAR,    -- Calendar Day of Year [CUAN_CALENDARDAYOFYEAR]
    YEARDAY,              -- Year Day [CUAN_YEARDAY]
    PRIMARY KEY (CALENDARDATE)
);

Learn More