MMPUR_CAT_MGPTXT

Transparent Table Application Table
4 Fields 2 CDS Views

Text table for material group

MMPUR_CAT_MGPTXT is an SAP database table in S/4HANA. Text table for material group. It contains 4 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_Ctlgitem_Mgptext view left_outer BASIC Material Group Text
I_OpnCtlgMatGrpText view from BASIC Catalog Item Material Group Text

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY ctlg_itm_key mmpur_cat_d_itm_key Catalog Item Key
KEY language mmpur_cat_language Language Key
matgrouptext mmpur_cat_matgrptxt Category Text

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.

-- Text table for material group
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_CAT_MGPTXT (
    MANDT,         -- Client [mandt]
    CTLG_ITM_KEY,  -- Catalog Item Key [mmpur_cat_d_itm_key]
    LANGUAGE,      -- Language Key [mmpur_cat_language]
    MATGROUPTEXT,  -- Category Text [mmpur_cat_matgrptxt]
    PRIMARY KEY (MANDT, CTLG_ITM_KEY, LANGUAGE)
);

Learn More