P_FISCALYEARPERIOD

CDS View
11 Fields 6 CDS Views

P_FISCALYEARPERIOD is a CDS View in S/4HANA. It contains 11 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_FiscalCalYearPeriodForCoCode view from BASIC Fiscal Year Period for Company Code
I_FiscalPeriodForVariant view_entity from BASIC Fiscal Period For Fiscal Year Variant
I_FiscalYearPeriod view_entity from BASIC Fiscal Year Period
I_FiscalYearPeriodForVariant view_entity from BASIC Fiscal Year Period For Fiscal Year Variant
P_Distinct_Postingdate view from BASIC
P_GLAcctCreditDebitBalance view inner COMPOSITE

Fields (11)

KeyField CDS FieldsUsed in Views
KEY fiscal_period fiscal_period,FiscalPeriod 5
KEY fiscal_year fiscal_year,FiscalYear 6
KEY fiscal_year_period fiscal_year_period,FiscalYearPeriod 5
KEY fiscal_year_variant fiscal_year_variant,FiscalYearVariant 6
fiscal_period_end_date fiscal_period_end_date,FiscalPeriodEndDate 5
fiscal_period_start_date FiscalPeriodStartDate 4
fiscal_year_end_date FiscalYearEndDate 5
fiscal_year_start_date FiscalYearStartDate 5
is_special_period is_special_period,IsSpecialPeriod 5
next_fiscal_period NextFiscalPeriod 3
next_fiscal_period_fiscal_year 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_FISCALYEARPERIOD (
    FISCAL_PERIOD,
    FISCAL_YEAR,
    FISCAL_YEAR_PERIOD,
    FISCAL_YEAR_VARIANT,
    FISCAL_PERIOD_END_DATE,
    FISCAL_PERIOD_START_DATE,
    FISCAL_YEAR_END_DATE,
    FISCAL_YEAR_START_DATE,
    IS_SPECIAL_PERIOD,
    NEXT_FISCAL_PERIOD,
    NEXT_FISCAL_PERIOD_FISCAL_YEAR,
    PRIMARY KEY (FISCAL_PERIOD, FISCAL_YEAR, FISCAL_YEAR_PERIOD, FISCAL_YEAR_VARIANT)
);

Learn More