SCAL_TT_DATE - Date table containing dates from 01011900 to 31129999
Date table containing dates from 01011900 to 31129999 information is stored in SAP table SCAL_TT_DATE.
It is part of development package VDM_CAL in software component CA-GTF-DF. This development package consists of objects that can be grouped under "Date Function".
It is part of development package VDM_CAL in software component CA-GTF-DF. This development package consists of objects that can be grouped under "Date Function".
Fields for table SCAL_TT_DATE
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CALENDARDATE | Calendar Date | X | CALENDARDATE | DATS | 16 | |
| CALENDARYEAR | Calendar Year | CALENDARYEAR | NUMC | 8 | ||
| CALENDARMONTH | Calendar Month | CALENDARMONTH | NUMC | 4 | ||
| CALENDARQUARTER | Calendar Quarter | CALENDARQUARTER | NUMC | 2 | ||
| CALENDARWEEK | Calendar Week | CALENDARWEEK | NUMC | 4 | ||
| CALENDARDAY | Calendar Day | CALENDARDAY | NUMC | 4 | ||
| WEEKDAY | Week Day | VDM_WEEKDAY | NUMC | 2 | ||
| YEARWEEK | Year Week | VDM_YEARWEEK | NUMC | 12 | ||
| YEARQUARTER | Year Quarter | VDM_YEARQUARTER | NUMC | 10 | ||
| YEARMONTH | Year Month | VDM_YEARMONTH | NUMC | 12 | ||
| FIRSTDAYOFMONTHDATE | First Day of Month Date | FIRSTDAYOFMONTHDATE | DATS | 16 | ||
| LASTDAYOFMONTHDATE | Last Day of Month Date | LASTDAYOFMONTHDATE | DATS | 16 | ||
| HALFYEAR | Half Year | VDM_HALFYEAR | NUMC | 2 | ||
| FIRSTDAYOFWEEKDATE | First day of week date | VDM_FIRSTDAYOFWEEKDATE | DATS | 16 | ||
| CALENDARDAYOFYEAR | Calendar day of year | VDM_CALENDARDAYOFYEAR | NUMC | 6 | ||
| YEARDAY | Year Day | VDM_YEARDAY | NUMC | 14 |