T023

Transparent Table Customizing Table
16 Fields 5 CDS Views

Material Groups

T023 is an SAP database table in S/4HANA. Material Groups. It contains 16 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
CIC_MrchdsCategoryHierNode view_entity left_outer Projection View on Merchandise Category Hierarchy
I_MaterialGroup view from BASIC Material Group
I_MerchandiseCategory view_entity from BASIC Merchandise Category
I_ProductGroup view from BASIC Product Group
I_ProductGroup_2 view from BASIC Product Group

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matkl MATKL Material Group
spart SPART Division
lref3 LREF3 Logist.ref.
wwgda WWGDA MG Ref. Mat
wwgpa WWGPA MG Material
abtnr ABTNR Department
begru BEGRU AuthorizGroup
gewei GEWEI_V Unit of weight
j_1bnbm J_1BNBMCO1 NCM Code
bklas BKLAS Valuation Class
ekwsl EKWSL Purch.value key
anlkl MEVAK Asset Class
last_changed_at RFM_MC_TIMESTAMP Last changed at (only for merch. cat.)
def_schdsc EXP_SCHDSC Scenario
price_group PRICE_GROUP Price Level Group

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.

-- Material Groups
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T023 (
    MANDT,            -- Client [MANDT]
    MATKL,            -- Material Group [MATKL]
    SPART,            -- Division [SPART]
    LREF3,            -- Logist.ref. [LREF3]
    WWGDA,            -- MG Ref. Mat [WWGDA]
    WWGPA,            -- MG Material [WWGPA]
    ABTNR,            -- Department [ABTNR]
    BEGRU,            -- AuthorizGroup [BEGRU]
    GEWEI,            -- Unit of weight [GEWEI_V]
    J_1BNBM,          -- NCM Code [J_1BNBMCO1]
    BKLAS,            -- Valuation Class [BKLAS]
    EKWSL,            -- Purch.value key [EKWSL]
    ANLKL,            -- Asset Class [MEVAK]
    LAST_CHANGED_AT,  -- Last changed at (only for merch. cat.) [RFM_MC_TIMESTAMP]
    DEF_SCHDSC,       -- Scenario [EXP_SCHDSC]
    PRICE_GROUP,      -- Price Level Group [PRICE_GROUP]
    PRIMARY KEY (MANDT, MATKL)
);

Learn More