I_FISCALCALENDARDATE

CDS View
22 Fields 45 CDS Views

Fiscal Calendar Date

I_FISCALCALENDARDATE is a CDS View in S/4HANA. Fiscal Calendar Date. It contains 22 fields. 45 CDS views read from this table.

CDS Views using this table (45)

ViewTypeJoinVDMDescription
C_HU_StRpECSLPer view from CONSUMPTION HU ECSL: Getting start date and end date from year, period
F_FiscalCalendarDayShift view_entity from DERIVATION_FUNCTION Fiscal Calendar Day Shift
I_BalanceAuditTrail view left_outer COMPOSITE Line Items for Balance Audit Trail
I_CADocumentsBtwnPostingDate view_entity inner COMPOSITE FICA Transactions between posting dates
I_CurrentYearFiscalPeriodText view inner BASIC Fiscal Period of Current Fiscal Year - Text
I_FiscalCalDateForFinMgmtArea view from BASIC Fiscal Year For FM Area
I_FiscalCalendarDateForLedger view from COMPOSITE Fiscal Calendar Dates for Ledger
I_FiscalYearForCompanyCode view from BASIC Fiscal Year for Company Code
I_FiscCalendarDateForCompCode view from BASIC Fiscal Calendar Date For Company Code
I_FsclCalDateFsclYrLastPeriod view inner COMPOSITE Last fiscal period of fiscal year
I_FsclDateFuncRangeFiscalValue view inner COMPOSITE Fiscal Time Ranges for Range of Fiscal Date Function
I_FsclDateFuncRangeForLedger view inner COMPOSITE Fiscal Date Function for Ledger
I_FsclQtrWthoutFsclYrForVar view from COMPOSITE Fiscal Quarters For Fiscal Year Variant Without Fiscal Year
I_SAFTHeaderCA view inner COMPOSITE SAF-T FI-CA Header
I_USFedFiscalCalendarDate view_entity from BASIC US Fed Financials Fiscal Calendar Date
P_ActualPlanGLAcctBalance2 view left_outer COMPOSITE
P_AvgDailyBalKeyFig view inner COMPOSITE
P_Bcmitem view left_outer BASIC Analyze Payment Detail BCM Item
P_CACUSTTRIALBALITEM1 view_entity inner COMPOSITE
P_EntProjPredictionFsclPerd view inner CONSUMPTION
P_FiscalCalendarDateDteFnction view inner COMPOSITE
P_FiscalCalendarDateNxtPeriods view from COMPOSITE
P_FiscalCalendarDtePrevPeriods view from COMPOSITE
P_FiscalCalendarYTDRange2 view from COMPOSITE
P_FiscalDateFunctionValueFY view inner COMPOSITE
P_FiscalYearGroup view from COMPOSITE
P_FiscalYearPeriodGroup view from COMPOSITE
P_FiscalYearQuarterGroup view from COMPOSITE
P_FiscalYearWeekGroup view from COMPOSITE
P_FixedAssetOvwFiscalPeriod2 view from COMPOSITE
P_GLE_ADB_GR_01 view inner COMPOSITE
P_LU_SAFTContractAccJournal view_entity inner COMPOSITE
P_MaterialStockPeriods view from COMPOSITE
P_MLInventoryFiscalPeriod view inner COMPOSITE
P_PL_SAFTFiscalCalendarDate view inner BASIC
P_ProjCostTmeRngeWthSpclPerd view left_outer COMPOSITE
P_PROJCOTMERNGEWTHSPCLPERD view left_outer COMPOSITE
P_ProjFiscalTRSPCLPerd view inner COMPOSITE
P_PubSecCtrlObjProfileCurDate1 view inner BASIC
P_RealTimeRptdFinData_01 view inner COMPOSITE
P_REALTIMERPTDFINDATANRL_01 view inner COMPOSITE
P_RepFinData_RT_Aggr_02 view inner COMPOSITE
P_RepFinData_RT_AggrNRL_02 view inner COMPOSITE
P_RU_GLAcctBalance12 view inner CONSUMPTION G/L Account Balance
P_ShiftedFiscalCalDate1 view from COMPOSITE

Fields (22)

KeyField CDS FieldsUsed in Views
KEY CalendarDate CalendarDate,PostingDate 7
KEY FiscalPeriod FiscalPeriod,poper 17
KEY FiscalQuarter FiscalQuarter 1
KEY FiscalWeek FiscalWeek 1
KEY FiscalYear EndFiscalYear,FiscalYear,ryear,StartFiscalYear 20
KEY FiscalYearPeriod FiscalYearPeriod,NextFiscalYearPeriod,ToFiscalYearPeriod,YearPeriod 11
KEY FiscalYearVariant FiscalYearVariant 9
_FiscalYearVariant _FiscalYearVariant 3
_Text _Text 1
FiscalPeriodConsecutiveNumber FiscalPeriodConsecutiveNumber 1
FiscalPeriodEndDate FiscalPeriodEndDate 2
FiscalPeriodStartDate FiscalPeriodStartDate,StartDate 3
FiscalQuarterConsecutiveNumber FiscalQuarterConsecutiveNumber 1
FiscalQuarterEndDate FiscalQuarterEndDate 1
FiscalQuarterStartDate FiscalQuarterStartDate 1
FiscalWeekConsecutiveNumber FiscalWeekConsecutiveNumber 1
FiscalWeekEndDate FiscalWeekEndDate 1
FiscalWeekStartDate FiscalWeekStartDate 1
FiscalYearEndDate FiscalYearEndDate 2
FiscalYearQuarter FiscalYearQuarter 2
FiscalYearStartDate FiscalYearStartDate 2
FiscalYearWeek FiscalYearWeek 1

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.

-- Fiscal Calendar Date
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FISCALCALENDARDATE (
    CALENDARDATE,
    FISCALPERIOD,
    FISCALQUARTER,
    FISCALWEEK,
    FISCALYEAR,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    _FISCALYEARVARIANT,
    _TEXT,
    FISCALPERIODCONSECUTIVENUMBER,
    FISCALPERIODENDDATE,
    FISCALPERIODSTARTDATE,
    FISCALQUARTERCONSECUTIVENUMBER,
    FISCALQUARTERENDDATE,
    FISCALQUARTERSTARTDATE,
    FISCALWEEKCONSECUTIVENUMBER,
    FISCALWEEKENDDATE,
    FISCALWEEKSTARTDATE,
    FISCALYEARENDDATE,
    FISCALYEARQUARTER,
    FISCALYEARSTARTDATE,
    FISCALYEARWEEK,
    PRIMARY KEY (CALENDARDATE, FISCALPERIOD, FISCALQUARTER, FISCALWEEK, FISCALYEAR, FISCALYEARPERIOD, FISCALYEARVARIANT)
);

Learn More