I_FISCALYEARPERIOD

CDS View
15 Fields 17 CDS Views

Fiscal Year Period

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

CDS Views using this table (17)

ViewTypeJoinVDMDescription
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 from BASIC Fiscal Year Period for Ledger
I_FiscalPeriodValueList view from COMPOSITE Fiscal Period Value List
I_FiscalPeriodValueList view union COMPOSITE Fiscal Period Value List
I_FiscalYearPeriodForCmpnyCode view from BASIC Fiscal Year Period For Company Code
I_FiscalYearPeriodForLedger view 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
P_FiscalPeriodCalendarDate view inner COMPOSITE
P_FiscalYearPeriod000 view from BASIC
P_RAFiscalYearPeriod view_entity from COMPOSITE

Fields (15)

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

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