FIRSTDAYOFMONTHDATE in SCAL_TT_DATE
First Day of Month (DE: Erster Tag d. Monats)
FIRSTDAYOFMONTHDATE is a field in SAP table SCAL_TT_DATE (Date table containing dates from 01011900 to 31129999). It represents "First Day of Month". Data element: FIRSTDAYOFMONTHDATE. Available in 37 CDS view(s) as FirstDayOfMonthDate, FirstDateFirstMonth, FirstDateSecondMonth.
Business Meaning
| Description (EN) | First Day of Month |
|---|---|
| Beschreibung (DE) | Erster Tag d. Monats |
| Data Element | FIRSTDAYOFMONTHDATE |
| Key Field | No |
CDS Views & Technical Names (37)
SCAL_TT_DATE.FIRSTDAYOFMONTHDATE is exposed in CDS views under the following technical names. Views reading the table directly are listed first; "via" marks views that pass the field on through intermediate views.
FirstDayOfMonthDate
(32 views)
First Day of Month Date
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_CalendarDate | direct | BASIC | Date | |
| C_PurgInfoRecdAvgPrHist | via 2 level | CONSUMPTION | Calculating Average Price History for PIR | |
| C_PurgInfoRecdPOAvgPrHist | via 2 level | CONSUMPTION | Price change analysis by PO | |
| C_RSHCalendarMonthsBtwnDates | via 2 level | CONSUMPTION | Calendar Month between start & end date | |
| CURRENTCALENDARDATE | via 2 level | Current Calendar Date | ||
| I_ARunCalendarDate | via 2 level | BASIC | View for Date Details for Supply Assignment Applications | |
| I_DDHistlBufProdDaysInMonthCt | via 2 level | COMPOSITE | DD Historical Buffer App Days in Month | |
| I_LastFiveQuartersDate | via 2 level | COMPOSITE | Date with Last Five Quarters Information | |
| I_LastMonthDate | via 2 level | COMPOSITE | Date with Last Month Information | |
| I_SalesForecastKeyFigure | via 2 level | BASIC | Sales Figure Collection | |
| I_SrvcPartsDistrRqmtsPlngC | via 2 level | COMPOSITE | Analytics Requirements Planning - Cube | |
| I_SrvcPartsDmndHistRawC | via 2 level | COMPOSITE | Analytics Raw Demand for Demand History - Cube | |
| I_SrvcPartsDmndHistRawLocC | via 2 level | COMPOSITE | Analytics RawDemLoc for DemHist - Cube | |
| I_SrvcPartsForecastMonthC | via 2 level | COMPOSITE | Analytics Monthly Forecast - Cube | |
| I_SrvcPartsForecastWeekC | via 2 level | COMPOSITE | Analytics Weekly Forecast - Cube | |
| I_TranspBusDshbrdFlxblIntvl | via 2 level | COMPOSITE | Flxbl Intvl for Transp Bus Dashboard | |
| I_TranspBusPerfMntrFlxblIntvl | via 2 level | COMPOSITE | Flxbl Intvl for Transp Bus Perf Mon | |
| P_CALENDAR_KEYDATE | via 2 level | COMPOSITE | ||
| P_CalendarDate | via 2 level | CONSUMPTION | Calendar Date | |
| P_CATS_CALENDARDATE_3MONTH | via 2 level | COMPOSITE | CATS: Three month dates | |
| P_FTR_KEYDATE | via 2 level | COMPOSITE | ||
| P_PrevSixQtrCalInformation | via 2 level | CONSUMPTION | P view for Prev Six Qtr Calc | |
| P_ServiceContractDataCube | via 2 level | COMPOSITE | ||
| P_SI_YoYCalendarDateDuration | via 2 level | COMPOSITE | ||
| P_SuplrDeliveryPredictCount1 | via 2 level | COMPOSITE | ||
| C_SrvcPartsDistrRqmtsPlngQ | via 3 levels | CONSUMPTION | Analytics Requirements Planning Query | |
| C_SrvcPartsDmndHistRawLocQ | via 3 levels | CONSUMPTION | Analytics RawDemLoc for DemHist V3 Query | |
| C_SrvcPartsDmndHistRawQ | via 3 levels | CONSUMPTION | Analytics Raw Demand History Query | |
| C_SrvcPartsForecastMonthQ | via 3 levels | CONSUMPTION | Analytics - Monthly Forecast Query | |
| C_SrvcPartsForecastWeekQ | via 3 levels | CONSUMPTION | Analytics - Weekly Forecast Query | |
| I_ServiceContractCube_2 | via 3 levels | COMPOSITE | Service Contract - Cube | |
| P_RelevantDates | via 3 levels | CONSUMPTION | Relevant Dates |
FirstDateFirstMonth
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_Rshresource2monthsperiod | via 2 level | CONSUMPTION | 2 Months period | |
| P_Rshresource4monthsperiod | via 2 level | CONSUMPTION |
FirstDateSecondMonth
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_Rshresource2monthsperiod | via 2 level | CONSUMPTION | 2 Months period | |
| P_Rshresource4monthsperiod | via 2 level | CONSUMPTION |
firstDate
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_RshDatsFirstLastDayMonths | via 2 level | COMPOSITE |
FirstDateFourthMonth
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_Rshresource4monthsperiod | via 2 level | CONSUMPTION |
FirstDateThirdMonth
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_Rshresource4monthsperiod | via 2 level | CONSUMPTION |
FirstDayOfLastHalfYearDate
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_APCalendarLast6Mnths | via 2 level | COMPOSITE |
FirstDayOfLastYearDate
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_ARCalendarLast12Mnths | via 2 level | COMPOSITE |
Other Tables with Field FIRSTDAYOFMONTHDATE (2)
| Table | Data Element | Key | Description |
|---|---|---|---|
| CUAN_CAL_TT_DATE | CUAN_FIRSTDAYOFMONTHDATE | Date table containing dates from 01011900 to 31129999 | |
| SCAL_TT_MONTH | FIRSTDAYOFMONTHDATE | Month |
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA