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