P_FISCALCALENDARDATE

CDS View
20 Fields 2 CDS Views

Fiscal Calendar Date

P_FISCALCALENDARDATE is a CDS View in S/4HANA. Fiscal Calendar Date. It contains 20 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_FiscalCalendarDate view_entity from BASIC Fiscal Calendar Date
P_Distinct_Postingdate view_entity inner BASIC Distinct Posting Date

Fields (20)

KeyField CDS FieldsUsed in Views
KEY calendar_date calendar_date,CalendarDate 2
KEY fiscal_year_variant FiscalYearVariant 1
fiscal_period FiscalPeriod 1
fiscal_period_end_date FiscalPeriodEndDate 1
fiscal_period_start_date FiscalPeriodStartDate 1
fiscal_quarter FiscalQuarter 1
fiscal_quarter_end_date FiscalQuarterEndDate 1
fiscal_quarter_start_date FiscalQuarterStartDate 1
fiscal_week FiscalWeek 1
fiscal_week_end_date FiscalWeekEndDate 1
fiscal_week_start_date FiscalWeekStartDate 1
fiscal_year FiscalYear 1
fiscal_year_end_date fiscal_year_end_date,FiscalYearEndDate 2
fiscal_year_period FiscalYearPeriod 1
fiscal_year_period_int FiscalPeriodConsecutiveNumber 1
fiscal_year_quarter FiscalYearQuarter 1
fiscal_year_quarter_int FiscalQuarterConsecutiveNumber 1
fiscal_year_start_date fiscal_year_start_date,FiscalYearStartDate 2
fiscal_year_week FiscalYearWeek 1
fiscal_year_week_int FiscalWeekConsecutiveNumber 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 Calendar Date
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_FISCALCALENDARDATE (
    CALENDAR_DATE,
    FISCAL_YEAR_VARIANT,
    FISCAL_PERIOD,
    FISCAL_PERIOD_END_DATE,
    FISCAL_PERIOD_START_DATE,
    FISCAL_QUARTER,
    FISCAL_QUARTER_END_DATE,
    FISCAL_QUARTER_START_DATE,
    FISCAL_WEEK,
    FISCAL_WEEK_END_DATE,
    FISCAL_WEEK_START_DATE,
    FISCAL_YEAR,
    FISCAL_YEAR_END_DATE,
    FISCAL_YEAR_PERIOD,
    FISCAL_YEAR_PERIOD_INT,
    FISCAL_YEAR_QUARTER,
    FISCAL_YEAR_QUARTER_INT,
    FISCAL_YEAR_START_DATE,
    FISCAL_YEAR_WEEK,
    FISCAL_YEAR_WEEK_INT,
    PRIMARY KEY (CALENDAR_DATE, FISCAL_YEAR_VARIANT)
);

Learn More