I_CALENDARDATE

CDS View
19 Fields 197 CDS Views

Date

I_CALENDARDATE is a CDS View in S/4HANA. Date. It contains 19 fields. 197 CDS views read from this table.

CDS Views using this table (197)

ViewTypeJoinVDMDescription
C_CashPositionProfileWithCycle view_entity cross CONSUMPTION Cash Position Profile With Cycle Info
C_CntrlPurContrItemPriceHist view inner CONSUMPTION Central Purchase Contract Item Price History
C_ContractConsumption view inner CONSUMPTION Contract Consumption
C_HCMTimeShtAttndncAbsncType view_entity inner CONSUMPTION Timesheet Attendance Absence types
C_MaterialPriceVariance view inner CONSUMPTION Material Price Variance
C_MDBusPartChgProcessYrMnthVH view_entity from CONSUMPTION Creation Year Month
C_NonMngdPurchasingSpend3 view left_outer CONSUMPTION Non Managed Purchasing Spend Cube
C_PurOrderItemHistoryValues2 view left_outer CONSUMPTION Purchase Order Item History Values 2
C_PurReqnItemTypeAnalysis view left_outer CONSUMPTION Purchase Requisition Item Type Analysis
C_QltyTskMng view left_outer CONSUMPTION Manage Quality Tasks
C_QuantityContractAcctAssgmt view left_outer CONSUMPTION Quantity Contract Account Assignment
C_QuantityVariance view left_outer CONSUMPTION Quantity Variance
C_REIntegObjMsmtByKeyDate view_entity cross CONSUMPTION Integration Object Measurement by Keydate
C_RequisitionTypeAnalysis view left_outer CONSUMPTION Purchase Requisition Type Analysis
C_RSHCalendarMonthsBtwnDates view from CONSUMPTION Calendar Month between start & end date
C_RSHCalendarWeeksBetweenDates view from CONSUMPTION Calendar Weeks Between Dates
C_RSHOpUnassignedWorkKPI view inner CONSUMPTION Operations unassigned work KPI
C_RSHSmltdWrkCtrUtilznPerDay view inner CONSUMPTION Work Center Utilization Per Day
C_RSHWrkCtrUtilizationKPI view inner CONSUMPTION Work Center Utilization Overview
C_SuplrEvalByQuality view inner CONSUMPTION Supplier Evaluation by Quality
C_ValueContractReleaseSts view left_outer CONSUMPTION Value Contract Release Status
C_WrkCtrMntrUtilznChtPeriods view left_outer CONSUMPTION WC Monitor - Utilization Chart Periods
CURRENTCALENDARDATE view from Current Calendar Date
DATEFUNC_CONFIG_SIMULATE view inner Non-Persisted DateFunction Configuration Simulation
F_EHSDateTmeIntvlLastSixMnths view_entity from DERIVATION_FUNCTION Env Data Last Six Months Time Interval
I_ARunCalendarDate view from BASIC View for Date Details for Supply Assignment Applications
I_ARunOvwTotDmndCube view left_outer COMPOSITE Supply Assignment Run Demand Cube View
I_ARunReleaseCheckCube view left_outer COMPOSITE Cube view for Release Check
I_ARunSimlnDmndCube view left_outer COMPOSITE ARun Simulation Demand Cube View
I_CmmdtyHedgeFactoryCalendar view from COMPOSITE Factory Calendar Dates
I_DDHistlBufProdDaysInMonthCt view_entity from COMPOSITE DD Historical Buffer App Days in Month
I_DDHistlBufProdDaysInWeekCt view_entity from COMPOSITE DD Historical Buffer Days in Week Count
I_FinTransFeeFlow view inner COMPOSITE Fin Trans Flows Relevant For Fee
I_FldLogsDateFuncVH view_entity from COMPOSITE Field Logistics Date Function
I_GhoMeasDocItem_Db view inner BASIC Measurement Document Item
I_HCMTimeEventCalendar view_entity from COMPOSITE HCM Time Events Calendar
I_HCMTimeEventType view_entity inner BASIC HCM Time Event Types
I_HCMTimeShtAttndncAbsncType view_entity inner BASIC HCM Timesheet Attendance Absence Types
I_LastFiveQuartersDate view from COMPOSITE Date with Last Five Quarters Information
I_LastMonthDate view from COMPOSITE Date with Last Month Information
I_MatlDocsByMonthAndBusProcess view inner COMPOSITE Mat Doc Info By Month and Bus Process
I_NominationItemVersion view inner BASIC CDS for nomination item to version
I_NominationVersionItem view inner BASIC CDS for nomination version to item
I_OIL_ExchangesMovementData view_entity inner COMPOSITE Composite For Exg Transactions
I_PlndIndepRqmtCalAggrgnMonths view from COMPOSITE PIR Calendar Aggregation Months
I_PlndIndepRqmtCalAggrgnWeeks view from COMPOSITE Aggregate weeks
I_QualityLevelAnalysisCube view left_outer COMPOSITE Quality Level History - Cube
I_ShiftedCalendarDate view from COMPOSITE Shifted Calendar Date
I_SupDmndOvwSupAssgmtAll view left_outer COMPOSITE Basic View for Supply Assignment
I_SVTAggrgnLegalEntityByMonth view inner COMPOSITE Legal Entity by Month Aggregation
I_TranspBusDshbrdFlxblIntvl view from COMPOSITE Flxbl Intvl for Transp Bus Dashboard
I_TranspBusPerfMntrFlxblIntvl view from COMPOSITE Flxbl Intvl for Transp Bus Perf Mon
I_UtilsContractProductChanges view left_outer COMPOSITE Utilities Contract Product Changes
I_VisualAnalysis view inner COMPOSITE Visual Analysis
P_Actualcalendardate view from COMPOSITE
P_AnalyzeAccrualPostingStrtDte view from COMPOSITE
P_AnalyzeAccrualPostingStrtDte view inner COMPOSITE
P_APAgingGrid1 view from COMPOSITE
P_APCalendar view from COMPOSITE
P_APCalendarLast6Mnths view from COMPOSITE
P_APCalendarLast6Mnths view inner COMPOSITE
P_APCurrentMonth view from COMPOSITE
P_APPaymentDate1 view from COMPOSITE
P_ARCalendarLast12Mnths view from COMPOSITE
P_ARCalendarLast12Mnths view inner COMPOSITE
P_ARCalendarMnthTxt view from COMPOSITE
P_ARDaysSalesOutStdgCalMnth view from COMPOSITE
P_AvgDailyUsgeHrznForCalDte view left_outer COMPOSITE
P_BkCshBalHistByCshBalDte view_entity from TRANSACTIONAL Balance By Cash Balance Date
P_Calendar view from COMPOSITE
P_CALENDAR_KEYDATE view from COMPOSITE
P_CalendarDate view from CONSUMPTION Calendar Date
P_CalendarDateCalculation view from CONSUMPTION
P_CalendarDateRange view from COMPOSITE
P_CALENDARENDWEEK view from BASIC
P_CALENDARWEEK view from COMPOSITE
P_CalendarYear view from COMPOSITE
P_CATS_CALENDARDATE_3MONTH view from COMPOSITE CATS: Three month dates
P_ChartHorizon view from COMPOSITE
P_ChartYearHorizonRange view from COMPOSITE
P_ContractDaysToExpiry view left_outer COMPOSITE
P_Contractmaintain_Trans view left_outer COMPOSITE
P_CurrentCalendarDateYearMonth view_entity from COMPOSITE
P_DailyGrossSlsPostgDte_F4674 view inner COMPOSITE
P_DailyWeeklyMnthlyPIRByDate view left_outer COMPOSITE
P_DailyWeeklyMnthlyPIRHistDate view left_outer CONSUMPTION
P_DaysBeyondTerms6 view from COMPOSITE
P_DaysPyblOutstanding01 view from COMPOSITE
P_DaysPyblOutstandingCalMonth view from COMPOSITE
P_DaysPyblOutstandingPurs03 view left_outer COMPOSITE
P_DaysSalesOutstanding01 view from COMPOSITE
P_DaysSalesOutstanding5 view from COMPOSITE
P_DaysSalesOutstandingCalMonth view from COMPOSITE
P_DaysSalesOutstandingSales03 view left_outer COMPOSITE
P_Empworkinghours view left_outer COMPOSITE
P_EvaluationStartDate view from CONSUMPTION Evaluation Start Date
P_FctryClndrDate2 view from BASIC
P_Fqmtransactiondate view from BASIC
P_Fqmtransdate view from COMPOSITE
P_FTR_KEYDATE view from COMPOSITE
P_Ghocushierfcres_Tl view inner COMPOSITE
P_GhoFcResActDtlDate_Tl view inner COMPOSITE
P_GhoFcRsNwDate_Tl view inner COMPOSITE
P_GhoFrqFiltDate_Tl view inner COMPOSITE
P_GLCalendarLast12Mnths view from COMPOSITE
P_GLCalendarLast12Mnths view inner COMPOSITE
P_GLEffectivityCalendar view from COMPOSITE
P_GregorianCalDateFunction view inner CONSUMPTION
P_InfoRecordPriceVariance1 view left_outer CONSUMPTION
P_InvoicePriceVariance view left_outer CONSUMPTION
P_IRM_Limit_Year view from COMPOSITE
P_IRM_Term_Structure view from COMPOSITE
P_Lfodates view from COMPOSITE
P_Liquidityforecast_Daterange view from COMPOSITE
P_MarketDataReportingPeriod view from COMPOSITE
P_MarketDataReportingPeriod view union_all COMPOSITE
P_MaterialStockPeriods view inner COMPOSITE
P_MatlStkPerdsInMonth view inner COMPOSITE
P_MDRefIntCalDate view from COMPOSITE
P_MnthlyPlndIndepRqmtHistByDte view left_outer CONSUMPTION
P_MonthlyPlndIndepRqmtByDate view left_outer COMPOSITE
P_PPH_ReportingDate view_entity from COMPOSITE
P_PrevCalendarDateYearMonth view_entity from COMPOSITE
P_PrevMonthForCurrentMonth view from CONSUMPTION Previous Month Details for Current Month
P_PrevMonthForCurrentMonth view left_outer CONSUMPTION Previous Month Details for Current Month
P_PrevSixQtrCalInformation view from CONSUMPTION P view for Prev Six Qtr Calc
P_PrevWeekForCurrentWeek view from CONSUMPTION Previous Week Details for Current Week
P_PrevWeekForCurrentWeek view left_outer CONSUMPTION Previous Week Details for Current Week
P_ProductBufferMicroChtHorizon view from CONSUMPTION
P_ProjCalendarWeekClassfctn view from COMPOSITE
P_ProjectCostsWithPostingDates view from CONSUMPTION Project Costs With Posting Dates
P_PurchaseOrderItemPAI_04 view inner CONSUMPTION
P_PURCHASEORDERITEMPAI_05 view inner CONSUMPTION
P_PurchaseOrderPriceVariance view left_outer CONSUMPTION
P_PurchasingCategoryPlanSpend1 view left_outer CONSUMPTION P_PurchasingCategoryPlanSpend1
P_PurchasingGroupAnalysis1 view inner CONSUMPTION Purchasing Group Analysis 1
P_PurchasingGroupAnalysis2 view inner CONSUMPTION Purchasing Group Analysis 2
P_PurContractItemConsumption view inner CONSUMPTION
P_PurContractPriceVariance2 view left_outer CONSUMPTION
P_PurDocItemCurConv view inner CONSUMPTION Purchase Document with Currency Conversion for dates
P_PurgActualFutureSpend view left_outer CONSUMPTION Purchasing Actual Future Spend
P_PurgActualFutureSpend view inner CONSUMPTION Purchasing Actual Future Spend
P_Purgdocscheduleline view inner CONSUMPTION Purchasing Document Schedule Lines
P_PurgSpendActFutrExtnd view left_outer CONSUMPTION Purg Spend Actual and Future Extended
P_PurgSpendActFutrExtnd view inner CONSUMPTION Purg Spend Actual and Future Extended
P_PurOrdItemAcctAssgmt view left_outer CONSUMPTION Purchase Order Item Account Assignment
P_PurReqnAvgApprvlCrcyConvrsn view left_outer CONSUMPTION Purchase requisiton currency conversion
P_PurReqnCurrencyConvrsn view left_outer CONSUMPTION
P_PurReqnItemTypeAnalysis view left_outer CONSUMPTION Purchase Requistion No Touch for OVP
P_QuantityContract view inner CONSUMPTION
P_RAFinCmplncUnitPrcByItemAud view_entity inner COMPOSITE
P_RAFinCmplncUnitPriceByItem view_entity inner COMPOSITE
P_Referencedates view from CONSUMPTION
P_RO_SAFTCalendarDate view_entity from CONSUMPTION
P_RPTCYL_DATE view from COMPOSITE
P_RPTCYL_MONTH_DATE view from COMPOSITE
P_RPTCYL_WEEK_DATE view from COMPOSITE
P_RSHAvailPerSupplyItem view inner COMPOSITE
P_RSHBscStaffReqSupply view from CONSUMPTION Staffing Request Supply Data from CPM
P_RshDatsFirstLastDayMonths view from COMPOSITE
P_RSHEndDate view from CONSUMPTION
P_Rshresource2monthsperiod view from CONSUMPTION 2 Months period
P_Rshresource2monthsperiod view inner CONSUMPTION 2 Months period
P_Rshresource4monthsperiod view from CONSUMPTION
P_Rshresource4monthsperiod view inner CONSUMPTION
P_RSHResourceWeeklyUtilization view inner COMPOSITE
P_RSHRsceMonthlyUtilznCmplt view left_outer COMPOSITE
P_RSHThisWeekAndNextWeek view from CONSUMPTION
P_RSHWCCapacityPerDay view inner CONSUMPTION
P_RSHWCCapacityPerDayForPeriod view inner CONSUMPTION
P_RSHWCCapacityPerDayForPrd_1 view_entity inner CONSUMPTION
P_RSHWCUtilization view inner CONSUMPTION
P_RSHWorkCenterCapacityChange view inner CONSUMPTION Work Center Capacity Change
P_SalesInsightDuration view from COMPOSITE
P_SalesPlanByPeriod view left_outer COMPOSITE
P_SECURITYPRICEDATE view from COMPOSITE
P_ShrtTrmCshPosLatestBalDate view_entity from COMPOSITE
P_SI_SalesVolumeLastYear view_entity inner COMPOSITE
P_SI_YoYCalendarDateDuration view_entity from COMPOSITE
P_SI3_CalendarDate1 view from COMPOSITE
P_SI3_Period view from COMPOSITE
P_SI4_CalendarDate1 view from COMPOSITE
P_SI4_Period view from COMPOSITE
P_SPP_PredictionDate01 view from COMPOSITE
P_SPP_PredictionPeriod view from COMPOSITE
P_SPP_TrainingDate01 view from COMPOSITE
P_SPP_TrainingPeriod view from COMPOSITE
P_SuplrDeliveryPredictCount1 view inner COMPOSITE
P_SupplierEvalOverallUnion view inner CONSUMPTION Supplier Evaluation Overall Union
P_TotalAccountsReceivables2 view from COMPOSITE
P_TrsySecuritiesClRatgDfltSttg view from COMPOSITE
P_UnusedPurchaseContract2 view left_outer CONSUMPTION Unused Purchase Contract 2
P_WeeklyPlndIndepRqmtByDate view left_outer COMPOSITE
P_WeeklyPlndIndepRqmtHistByDte view left_outer CONSUMPTION
P_WORKCENTERCAPACITYEVAL view from COMPOSITE
P_WorkCenterCapMaxMinDte view from COMPOSITE
P_WorkCenterCapShiftOp view inner COMPOSITE

Fields (19)

KeyField CDS FieldsUsed in Views
KEY CalendarDate CalendarDate,DeliveryDate,FactoryCalendarDate,HCMTimeEventDate,HCMWorkDate,KeyDate,LastYearCurrentDate,PostingDate,TransactionDate 48
KEY CalendarMonth CalendarMonth,PODATE_MONTH 41
KEY CalendarYear CalendarYear,NominationCalendarYear 47
KEY FirstDayOfMonthDate firstDate,FirstDateFirstMonth,FirstDateFourthMonth,FirstDateSecondMonth,FirstDateThirdMonth,FirstDayOfLastHalfYearDate,FirstDayOfLastYearDate,FirstDayOfMonthDate 10
KEY FirstDayOfWeekDate FirstDayOfWeekDate,WrkCtrUtilznPerdStartDateTime 7
KEY YearMonth CurrentYearMonth,LastMonthStartDateYearMonth,NominationCalendarMonth,YearMonth,YearMonthFirstMonth,YearMonthFourthMonth,YearMonthSecondMonth,YearMonthThirdMonth 19
KEY YearQuarter YearQuarter 11
KEY YearWeek NominationCalendarWeek,WeekNumber,YearWeek 11
_CalendarMonth _CalendarMonth 3
_CalendarQuarter _CalendarQuarter 2
_CalendarYear _CalendarYear 2
_WeekDay _WeekDay 2
_YearMonth _YearMonth 2
CalendarDay CalendarDay 8
CalendarDayOfYear CalendarDayOfYear 4
CalendarQuarter CalendarQuarter 26
CalendarWeek CalendarWeek,PODATE_WEEK 31
WeekDay PODATE_WEEKDAY,WeekDay 10
YearDay YearDay 2

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CALENDARDATE (
    CALENDARDATE,
    CALENDARMONTH,
    CALENDARYEAR,
    FIRSTDAYOFMONTHDATE,
    FIRSTDAYOFWEEKDATE,
    YEARMONTH,
    YEARQUARTER,
    YEARWEEK,
    _CALENDARMONTH,
    _CALENDARQUARTER,
    _CALENDARYEAR,
    _WEEKDAY,
    _YEARMONTH,
    CALENDARDAY,
    CALENDARDAYOFYEAR,
    CALENDARQUARTER,
    CALENDARWEEK,
    WEEKDAY,
    YEARDAY,
    PRIMARY KEY (CALENDARDATE, CALENDARMONTH, CALENDARYEAR, FIRSTDAYOFMONTHDATE, FIRSTDAYOFWEEKDATE, YEARMONTH, YEARQUARTER, YEARWEEK)
);

Learn More