TPIR2

Transparent Table Customizing Table

Value Categories

TPIR2 is an SAP database table in S/4HANA. Value Categories. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProjectValueCategory view_entity from BASIC List of Value Categories

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY appl PS_APPL Component
KEY kokrs KOKRS CO Area
KEY acpos ACPOS Val.category
meinh CO_MEINH Unit of Measure
beltp BP_INOUT Debit Type
mentp MENTP Quantity type

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.

-- Value Categories
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TPIR2 (
    MANDT,  -- Client [MANDT]
    APPL,   -- Component [PS_APPL]
    KOKRS,  -- CO Area [KOKRS]
    ACPOS,  -- Val.category [ACPOS]
    MEINH,  -- Unit of Measure [CO_MEINH]
    BELTP,  -- Debit Type [BP_INOUT]
    MENTP,  -- Quantity type [MENTP]
    PRIMARY KEY (MANDT, APPL, KOKRS, ACPOS)
);