I_FISCALPERIODFORVARIANT

CDS View
7 Fields 11 CDS Views

Fiscal Period For Fiscal Year Variant

I_FISCALPERIODFORVARIANT is a CDS View in S/4HANA. Fiscal Period For Fiscal Year Variant. It contains 7 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
FAC_DART_Z3_FISCALVARIANT view from Fiscal period for variant
I_ConsolidationYearCalculator view from COMPOSITE Consolidation Year Calculator
I_FsclYearQtrByFsclPeriod view union_all COMPOSITE Fiscal Year Quarter by Fiscal Period
P_AnalyticalAgingIncrement view inner COMPOSITE
P_CCLdgrShiftedPeriods view inner BASIC
P_CCLdgrShiftedPrevYearPer view inner BASIC
P_CCLdngLdgrPerDates view inner BASIC
P_CCLdngLdgrPeriodDates view inner BASIC
P_FiscalYearLastFiscalPeriod view from BASIC
P_GR_CustLedgerForwardPeriod view_entity inner COMPOSITE
P_Matrix_FiscalPeriodForVar view from COMPOSITE

Fields (7)

KeyField CDS FieldsUsed in Views
KEY FiscalPeriod CurrentFiscalPeriod,FiscalPeriod,PrevFiscalYearLastFiscalPeriod,PreviousFiscalPeriod 4
KEY FiscalYear CurrentFiscalYear,FiscalYear,PreviousFiscalPeriodFiscalYear,PreviousFiscalYear 3
KEY FiscalYearVariant FiscalYearVariant 1
FiscalPeriodEndDate CurrentFiscalPeriodEndDate,FiscalPeriodEndDate,PrevFsclYrLastFsclPerdEndDate,PreviousFiscalPeriodEndDate 5
FiscalPeriodStartDate CurrentFiscalPeriodStartDate,FiscalPeriodStartDate,PrevFsclYrLastFsclPerdStrtDate,PreviousFiscalPeriodStartDate 5
FiscalYearPeriod FiscalYearPeriod,PrevFsclYearLastFsclYearPeriod,PreviousFiscalYearPeriod 2
FiscalYearStartDate CAPostingDate 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 Period For Fiscal Year Variant
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FISCALPERIODFORVARIANT (
    FISCALPERIOD,
    FISCALYEAR,
    FISCALYEARVARIANT,
    FISCALPERIODENDDATE,
    FISCALPERIODSTARTDATE,
    FISCALYEARPERIOD,
    FISCALYEARSTARTDATE,
    PRIMARY KEY (FISCALPERIOD, FISCALYEAR, FISCALYEARVARIANT)
);

Learn More