I_FISCALYEARPERIOD

CDS View
15 Fields 21 CDS Views

Fiscal Year Period

I_FISCALYEARPERIOD is a CDS View in S/4HANA. Fiscal Year Period. It contains 15 fields. 21 CDS views read from this table.

CDS Views using this table (21)

ViewTypeJoinVDMDescription
/VSCEW/A_ProductConsumption view_entity left_outer Product Consumption
C_CnsldtnGroupHierarchyVH view_entity inner CONSUMPTION Consolidation Group Hierarchy
F_FiscalYearPeriodShift view inner DERIVATION_FUNCTION Fiscal Year Period Shift
F_FsclYearPeriodByFsclPeriod view from DERIVATION_FUNCTION Fiscal Year Period by Fiscal Period
I_FiscalCalYearPeriodForLedger view_entity from BASIC Fiscal Year Period for Ledger
I_FiscalPeriodValueList view_entity from COMPOSITE Fiscal Period Value List
I_FiscalPeriodValueList view_entity union COMPOSITE Fiscal Period Value List
I_FiscalYearPeriodForCmpnyCode view_entity from BASIC Fiscal Year Period For Company Code
I_FiscalYearPeriodForLedger view_entity from BASIC Fiscal Year Period for Ledger
I_FundAcctgBalanceItemC view inner COMPOSITE Fund Accounting Balance Item - Cube
I_GteeMLfcycCumltvStsCube view inner COMPOSITE Grant Life Cyc Cumltv Sts Changes - Cube
I_HR_StRpTaxReturnPeriod view_entity from COMPOSITE Croatia Tax Return Period
I_HR_StRpTaxReturnPeriodDetail view_entity from COMPOSITE Croatia Tax Return Period
I_JVAFsclYearPerdCoCodeForITD view from COMPOSITE JVA Fiscal Year Period For Company Code
I_JVAFsclYearPerdCoCodeForYTD view from COMPOSITE JVA Fiscal Year Period For Company Code
I_PubSecCumltvBdgtCnsmpnC view inner COMPOSITE Cumulative bdgt cnsmpn values - Cube
I_PubSecGrantCumltvStsHistC view_entity inner COMPOSITE Grant Cumulative Status - Cube
P_FiscalPeriodCalendarDate view_entity inner COMPOSITE Fiscal Period Calendar Date
P_FiscalYearPeriod000 view from BASIC Fiscal Year Period 000
P_LastDayofFsclDteFunctionV2 view_entity inner BASIC Last day of fiscal date function V2
P_RAFiscalYearPeriod view_entity from COMPOSITE Revenue Accounting Fiscar Year Period

Fields (15)

KeyField CDS FieldsUsed in Views
KEY FiscalPeriod CurrentFiscalPeriod,FiscalPeriod,poper,PreviousFiscalPeriod 11
KEY FiscalPeriodEndDate FiscalPeriodEndDate 12
KEY FiscalPeriodStartDate FiscalPeriodStartDate 10
KEY FiscalYear CurrentFiscalYear,FiscalYear,PreviousFiscalYear,RYEAR 11
KEY FiscalYearPeriod FiscalYearPeriod,FISCYEARPER 9
KEY FiscalYearVariant FiscalYearVariant,periv 10
_FiscalPeriodStartDate _FiscalPeriodStartDate 5
_FiscalYear _FiscalYear 2
_FiscalYearVariant _FiscalYearVariant 3
_Text _Text 2
FiscalYearEndDate FiscalYearEndDate 7
FiscalYearStartDate FiscalYearStartDate 7
IsSpecialPeriod IsSpecialPeriod 6
NextFiscalPeriod NextFiscalPeriod 5
NextFiscalPeriodFiscalYear NextFiscalPeriodFiscalYear 5

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 Year Period
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FISCALYEARPERIOD (
    FISCALPERIOD,
    FISCALPERIODENDDATE,
    FISCALPERIODSTARTDATE,
    FISCALYEAR,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    _FISCALPERIODSTARTDATE,
    _FISCALYEAR,
    _FISCALYEARVARIANT,
    _TEXT,
    FISCALYEARENDDATE,
    FISCALYEARSTARTDATE,
    ISSPECIALPERIOD,
    NEXTFISCALPERIOD,
    NEXTFISCALPERIODFISCALYEAR,
    PRIMARY KEY (FISCALPERIOD, FISCALPERIODENDDATE, FISCALPERIODSTARTDATE, FISCALYEAR, FISCALYEARPERIOD, FISCALYEARVARIANT)
);

Learn More