SCAL_TT_DATE
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description |
|---|---|---|---|
| KEY | calendardate | CALENDARDATE | |
| calendaryear | CALENDARYEAR | ||
| calendarmonth | CALENDARMONTH | ||
| calendarquarter | CALENDARQUARTER | ||
| calendarweek | CALENDARWEEK | ||
| calendarday | CALENDARDAY | ||
| weekday | VDM_WEEKDAY | ||
| yearweek | VDM_YEARWEEK | ||
| yearquarter | VDM_YEARQUARTER | ||
| yearmonth | VDM_YEARMONTH | ||
| firstdayofmonthdate | FIRSTDAYOFMONTHDATE | ||
| lastdayofmonthdate | LASTDAYOFMONTHDATE | ||
| halfyear | VDM_HALFYEAR | ||
| firstdayofweekdate | VDM_FIRSTDAYOFWEEKDATE | ||
| calendardayofyear | VDM_CALENDARDAYOFYEAR | ||
| yearday | VDM_YEARDAY |