_PERIOD

14 Fields

_PERIOD is an SAP database table in S/4HANA. It contains 14 fields.

Fields (14)

KeyField CDS FieldsUsed in Views
KEY FiscalPeriod FiscalPeriod 3
KEY FiscalYear FiscalYear 3
CalendarMonth BusSolnOrdCreationMonth,SrvcOrdCreationMonth 5
CalendarQuarter BusSolnOrdCreationQuarter,SrvcOrdCreationQuarter 5
CalendarYear BusSolnOrdCreationYear,SrvcOrdCreationYear 5
FiscalPeriodStartDate FiscalPeriodStartDate 1
FiscalYearPeriod FiscalYearPeriod 2
FiscalYearVariant FiscalYearVariant 1
period_type period_type 2
PeriodTypeIDDescription PeriodTypeIDDescription 3
ProcessClusterDescription PeriodProCluDescription 3
VersionDescription PeriodVersionDescription 3
YearMonth CreationDateYearMonth 2
YearQuarter CreationDateYearQuarter 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 _PERIOD (
    FISCALPERIOD,
    FISCALYEAR,
    CALENDARMONTH,
    CALENDARQUARTER,
    CALENDARYEAR,
    FISCALPERIODSTARTDATE,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    PERIOD_TYPE,
    PERIODTYPEIDDESCRIPTION,
    PROCESSCLUSTERDESCRIPTION,
    VERSIONDESCRIPTION,
    YEARMONTH,
    YEARQUARTER,
    PRIMARY KEY (FISCALPERIOD, FISCALYEAR)
);

Learn More