T009B

Transparent Table Customizing Table
7 Fields 1 CDS Views

Fiscal year variant periods

T009B is an SAP database table in S/4HANA. Fiscal year variant periods. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FiscalPeriodRawData view_entity from BASIC Fiscal Periods Raw Data

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY periv PERIV FY Variant
KEY bdatj BDATJ Year
KEY bumon BUMON Calendar month
KEY butag BUTAG Calendar day
poper POPER Posting Period
reljr RELJR Year shift

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.

-- Fiscal year variant periods
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T009B (
    MANDT,  -- Client [MANDT]
    PERIV,  -- FY Variant [PERIV]
    BDATJ,  -- Year [BDATJ]
    BUMON,  -- Calendar month [BUMON]
    BUTAG,  -- Calendar day [BUTAG]
    POPER,  -- Posting Period [POPER]
    RELJR,  -- Year shift [RELJR]
    PRIMARY KEY (MANDT, PERIV, BDATJ, BUMON, BUTAG)
);

Learn More