I_FISCALPERIODFORVARIANT

CDS View
9 Fields 14 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 9 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
F_FiscalPeriodEndDate view_entity from DERIVATION_FUNCTION Fiscal Calendar End Date
F_FiscalPeriodStartDate view_entity from DERIVATION_FUNCTION Fiscal Calendar Start Date
F_FiscalYearLastFiscalPeriod view_entity from DERIVATION_FUNCTION Fiscal Year Last Fiscal Period
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 Calculation of the aging increments for the analytical app
P_CCLdgrShiftedPeriods view inner COMPOSITE Period Dates for CoCode Leading Ledger
P_CCLdgrShiftedPrevYearPer view inner COMPOSITE MatlCtrlRecd with simply shifted previous year period
P_CCLdngLdgrPerDates view inner COMPOSITE Current/Previous Period Dates for CoCode Leading Ledger
P_CCLdngLdgrPeriodDates view_entity inner COMPOSITE Period Dates for CoCode Leading Ledger
P_FiscalYearLastFiscalPeriod view_entity from BASIC Last Fiscal Period in Fiscal Year
P_GR_CustLedgerForwardPeriod view_entity inner COMPOSITE Greece Customer Ledger for carry forward period
P_Matrix_FiscalPeriodForVar view from COMPOSITE Matrix Consolidation: Fiscal Period for Variant

Fields (9)

KeyField CDS FieldsUsed in Views
KEY FiscalPeriod CurrentFiscalPeriod,FiscalPeriod,PrevFiscalYearLastFiscalPeriod,PreviousFiscalPeriod 4
KEY FiscalYear CurrentFiscalYear,FiscalYear,PreviousFiscalPeriodFiscalYear,PreviousFiscalYear 4
KEY FiscalYearVariant FiscalYearVariant 2
_FiscalYear _FiscalYear 1
_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,
    _FISCALYEAR,
    _FISCALYEARVARIANT,
    FISCALPERIODENDDATE,
    FISCALPERIODSTARTDATE,
    FISCALYEARPERIOD,
    FISCALYEARSTARTDATE,
    PRIMARY KEY (FISCALPERIOD, FISCALYEAR, FISCALYEARVARIANT)
);

Learn More