PERIOD

20 Fields

PERIOD is an SAP database table in S/4HANA. It contains 20 fields.

Fields (20)

KeyField CDS FieldsUsed in Views
KEY AccountingPrinciple AccountingPrinciple 1
KEY CompanyCode CompanyCode 3
KEY EndDate EndDate 1
KEY FiscalPeriod FiscalPeriod 2
KEY FiscalYear FiscalYear 2
KEY FiscalYearPeriod FiscalYearPeriod 1
KEY pabrj period_year 1
KEY pabrp period_id 1
KEY permo frequency 1
KEY StartDate StartDate 2
KEY YearMonth YearMonth 2
KEY YearPeriod YearPeriod 1
begda begda 1
CalendarMonth CalendarMonth 3
CalendarYear CalendarYear 3
endda endda 1
ReportingPeriod ReportingPeriod 2
ReportingPeriodEndDate ReportingPeriodEndDate 3
ReportingPeriodStartDate ReportingPeriodStartDate 3
ReportingYear ReportingYear 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 (
    ACCOUNTINGPRINCIPLE,
    COMPANYCODE,
    ENDDATE,
    FISCALPERIOD,
    FISCALYEAR,
    FISCALYEARPERIOD,
    PABRJ,
    PABRP,
    PERMO,
    STARTDATE,
    YEARMONTH,
    YEARPERIOD,
    BEGDA,
    CALENDARMONTH,
    CALENDARYEAR,
    ENDDA,
    REPORTINGPERIOD,
    REPORTINGPERIODENDDATE,
    REPORTINGPERIODSTARTDATE,
    REPORTINGYEAR,
    PRIMARY KEY (ACCOUNTINGPRINCIPLE, COMPANYCODE, ENDDATE, FISCALPERIOD, FISCALYEAR, FISCALYEARPERIOD, PABRJ, PABRP, PERMO, STARTDATE, YEARMONTH, YEARPERIOD)
);

Learn More