_FISCALCALENDARDATE

10 Fields

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

Fields (10)

KeyField CDS FieldsUsed in Views
KEY FiscalPeriod FiscalPeriod 2
KEY FiscalQuarter FiscalQuarter 25
KEY FiscalYear FinMgmtAreaFiscalYear,FiscalYear 6
KEY FiscalYearVariant FiscalYearVariant 3
CalendarDate CalendarDate 2
FiscalPeriodConsecutiveNumber FiscalPeriodConsecutiveNumber 1
FiscalWeek FiscalWeek 12
FiscalYearPeriod FiscalYearPeriod 1
FiscalYearQuarter FiscalYearQuarter 16
FiscalYearWeek FiscalYearWeek 12

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

Learn More