_PERIOD

33 Fields

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

Fields (33)

KeyField CDS FieldsUsed in Views
KEY bukrs bukrs 2
KEY comp comp 2
KEY FiscalPeriod FiscalPeriod 3
KEY FiscalYear FiscalYear 3
KEY itemtype itemtype 2
KEY logsys logsys 2
KEY period_end_date period_end_date 2
KEY ref_key ref_key 2
KEY ref_subkey ref_subkey 2
KEY rldnr rldnr 2
CalendarMonth BusSolnOrdCreationMonth,SrvcOrdCreationMonth 5
CalendarQuarter BusSolnOrdCreationQuarter,SrvcOrdCreationQuarter 5
CalendarYear BusSolnOrdCreationYear,SrvcOrdCreationYear 5
first_day FirstDayOfMonthDate 1
FiscalPeriodStartDate FiscalPeriodStartDate 1
FiscalYearPeriod FiscalYearPeriod 2
FiscalYearVariant FiscalYearVariant 1
last_day LastDayOfMonthDate 1
PostedPeriodAmtInCoCodeCrcy posted_period_hsl 2
PostedPeriodAmtInFDCrcy1 posted_period_osl 2
PostedPeriodAmtInFDCrcy2 posted_period_vsl 2
PostedPeriodAmtInFDCrcy3 posted_period_bsl 2
PostedPeriodAmtInFDCrcy4 posted_period_csl 2
PostedPeriodAmtInFDCrcy5 posted_period_dsl 2
PostedPeriodAmtInFDCrcy6 posted_period_esl 2
PostedPeriodAmtInFDCrcy7 posted_period_fsl 2
PostedPeriodAmtInFDCrcy8 posted_period_gsl 2
PostedPeriodAmtInGlobalCrcy posted_period_ksl 2
PostedPeriodAmtInTransCrcy posted_period_wsl 2
run_id CostingRun 1
run_type CostingRunType 1
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 (
    BUKRS,
    COMP,
    FISCALPERIOD,
    FISCALYEAR,
    ITEMTYPE,
    LOGSYS,
    PERIOD_END_DATE,
    REF_KEY,
    REF_SUBKEY,
    RLDNR,
    CALENDARMONTH,
    CALENDARQUARTER,
    CALENDARYEAR,
    FIRST_DAY,
    FISCALPERIODSTARTDATE,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    LAST_DAY,
    POSTEDPERIODAMTINCOCODECRCY,
    POSTEDPERIODAMTINFDCRCY1,
    POSTEDPERIODAMTINFDCRCY2,
    POSTEDPERIODAMTINFDCRCY3,
    POSTEDPERIODAMTINFDCRCY4,
    POSTEDPERIODAMTINFDCRCY5,
    POSTEDPERIODAMTINFDCRCY6,
    POSTEDPERIODAMTINFDCRCY7,
    POSTEDPERIODAMTINFDCRCY8,
    POSTEDPERIODAMTINGLOBALCRCY,
    POSTEDPERIODAMTINTRANSCRCY,
    RUN_ID,
    RUN_TYPE,
    YEARMONTH,
    YEARQUARTER,
    PRIMARY KEY (BUKRS, COMP, FISCALPERIOD, FISCALYEAR, ITEMTYPE, LOGSYS, PERIOD_END_DATE, REF_KEY, REF_SUBKEY, RLDNR)
);

Learn More