PERIODGRID

PERIODGRID is an SAP database table in S/4HANA. It contains 9 fields.

Fields (9)

KeyField CDS FieldsUsed in Views
KEY InnerPeriod ComprnPeriodSequenceNumber 1
ComprnPeriodSequenceNumberPrev ComprnPeriodSequenceNumberPrev 1
ComprnPeriodSequenceNumberRef ComprnPeriodSequenceNumberRef 1
DayOfMonth DayOfMonth 1
DayOfMonthPrev DayOfMonthPrev 1
YearMonth YearMonth 1
YearMonthPrev YearMonthPrev 1
YearQuarter YearQuarter 1
YearQuarterPrev YearQuarterPrev 1

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 PERIODGRID (
    INNERPERIOD,
    COMPRNPERIODSEQUENCENUMBERPREV,
    COMPRNPERIODSEQUENCENUMBERREF,
    DAYOFMONTH,
    DAYOFMONTHPREV,
    YEARMONTH,
    YEARMONTHPREV,
    YEARQUARTER,
    YEARQUARTERPREV,
    PRIMARY KEY (INNERPERIOD)
);