_FISCALYEARPERIOD

7 Fields

_FISCALYEARPERIOD is an SAP database table in S/4HANA. It contains 7 fields.

Fields (7)

KeyField CDS FieldsUsed in Views
KEY FiscalYear ExportInvcConfirmedFiscalYear,FinMgmtAreaFiscalYear,FiscalYear 7
KEY FiscalYearPeriod FiscalYearPeriod 1
FiscalPeriod FiscalPeriod,PostingPeriod 4
FiscalPeriodEndDate FiscalPeriodEndDate,ReportingDate 2
FiscalPeriodStartDate FiscalPeriodStartDate 1
FiscalYearEndDate FiscalYearEndDate 2
FiscalYearStartDate FiscalYearStartDate 2

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 _FISCALYEARPERIOD (
    FISCALYEAR,
    FISCALYEARPERIOD,
    FISCALPERIOD,
    FISCALPERIODENDDATE,
    FISCALPERIODSTARTDATE,
    FISCALYEARENDDATE,
    FISCALYEARSTARTDATE,
    PRIMARY KEY (FISCALYEAR, FISCALYEARPERIOD)
);

Learn More