T023T

Transparent Table Customizing Table
5 Fields 7 CDS Views

Material Group Descriptions

T023T is an SAP database table in S/4HANA. Material Group Descriptions. It contains 5 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_MaterialGroupText view from BASIC Material Group Text
I_MerchandiseCategoryText view_entity from BASIC Merchandise Category - Text
I_ProductGroupText view from BASIC Product Group - Text
I_ProductGroupText_2 view from BASIC Product Group - Text
M_V_inforecord view left_outer MM-PUR: CDS View for Purchasing Info Record
m_v_m2s_pr_itm view left_outer CDS View for Purchase Requisition
VC_INTEGRATION_T023T view from Extraction for T023T

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY spras SPRAS Language
KEY matkl MATKL Material Group
wgbez WGBEZ Matl Grp Desc.
wgbez60 WGBEZ60 Mat.Grp Desc. 2

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 Group Descriptions
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T023T (
    MANDT,    -- Client [MANDT]
    SPRAS,    -- Language [SPRAS]
    MATKL,    -- Material Group [MATKL]
    WGBEZ,    -- Matl Grp Desc. [WGBEZ]
    WGBEZ60,  -- Mat.Grp Desc. 2 [WGBEZ60]
    PRIMARY KEY (MANDT, SPRAS, MATKL)
);

Learn More