_FISCALCALENDARDATE

9 Fields

_FISCALCALENDARDATE is an SAP database table in S/4HANA. It contains 9 fields.

Fields (9)

KeyField CDS FieldsUsed in Views
KEY FiscalPeriod FiscalPeriod 2
KEY FiscalQuarter FiscalQuarter 19
KEY FiscalYear FiscalYear 5
KEY FiscalYearVariant FiscalYearVariant 3
FiscalPeriodConsecutiveNumber FiscalPeriodConsecutiveNumber 1
FiscalWeek FiscalWeek 5
FiscalYearPeriod FiscalYearPeriod 1
FiscalYearQuarter FiscalYearQuarter 9
FiscalYearWeek FiscalYearWeek 5

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 _FISCALCALENDARDATE (
    FISCALPERIOD,
    FISCALQUARTER,
    FISCALYEAR,
    FISCALYEARVARIANT,
    FISCALPERIODCONSECUTIVENUMBER,
    FISCALWEEK,
    FISCALYEARPERIOD,
    FISCALYEARQUARTER,
    FISCALYEARWEEK,
    PRIMARY KEY (FISCALPERIOD, FISCALQUARTER, FISCALYEAR, FISCALYEARVARIANT)
);

Learn More