OPENPOSTGPERIOD

Transparent Table Customizing Table
10 Fields 1 CDS Views

Open Posting Periods

OPENPOSTGPERIOD is an SAP database table in S/4HANA. Open Posting Periods. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OpenPostingPeriod view from BASIC Interface View for table OpenPostgPeriod

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY companycode BUKRS Company Code
KEY ledger FINS_LEDGER Ledger
KEY bttype FINS_BTTYPE Bus. Trans. Category
KEY fiscalyear GJAHR Fiscal Year
KEY fiscalperiod POPER Posting Period
periodstatus POSTINGPERIODSTATUS Status
lastchangetime POSTINGPERIODCHANGETIME Last Change Time
lastchangedate POSTINGPERIODCHANGEDATE Last Change Date
lastchangeuser USNAM User Name

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.

-- Open Posting Periods
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OPENPOSTGPERIOD (
    MANDT,           -- Client [MANDT]
    COMPANYCODE,     -- Company Code [BUKRS]
    LEDGER,          -- Ledger [FINS_LEDGER]
    BTTYPE,          -- Bus. Trans. Category [FINS_BTTYPE]
    FISCALYEAR,      -- Fiscal Year [GJAHR]
    FISCALPERIOD,    -- Posting Period [POPER]
    PERIODSTATUS,    -- Status [POSTINGPERIODSTATUS]
    LASTCHANGETIME,  -- Last Change Time [POSTINGPERIODCHANGETIME]
    LASTCHANGEDATE,  -- Last Change Date [POSTINGPERIODCHANGEDATE]
    LASTCHANGEUSER,  -- User Name [USNAM]
    PRIMARY KEY (MANDT, COMPANYCODE, LEDGER, BTTYPE, FISCALYEAR, FISCALPERIOD)
);

Learn More