MMPUR_CAT_ITMATR

Transparent Table Application Table

Attributes for the Catalog Item

MMPUR_CAT_ITMATR is an SAP database table in S/4HANA. Attributes for the Catalog Item. It contains 8 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CtlgSrchAttributes view from BASIC Attribute for Catalog Items
I_OpnCtlgAttribute view from BASIC Catalog Item Attribute

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY attribute_guid mmpur_cat_attr_guid Attribute Guid
KEY languagecode mmpur_cat_language Language Key
KEY ctlg_itm_key mmpur_cat_d_itm_key Catalog Item Key
catagory_name mmpur_cat_cate_name Category Name
cat_attr_name mmpur_cat_attr_name Attribute Name
cat_attr_value mmpur_cat_attr_value Attribute Value
cat_attr_unit mmpur_cat_attr_unit Attribute Unit

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.

-- Attributes for the Catalog Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_CAT_ITMATR (
    MANDT,           -- Client [mandt]
    ATTRIBUTE_GUID,  -- Attribute Guid [mmpur_cat_attr_guid]
    LANGUAGECODE,    -- Language Key [mmpur_cat_language]
    CTLG_ITM_KEY,    -- Catalog Item Key [mmpur_cat_d_itm_key]
    CATAGORY_NAME,   -- Category Name [mmpur_cat_cate_name]
    CAT_ATTR_NAME,   -- Attribute Name [mmpur_cat_attr_name]
    CAT_ATTR_VALUE,  -- Attribute Value [mmpur_cat_attr_value]
    CAT_ATTR_UNIT,   -- Attribute Unit [mmpur_cat_attr_unit]
    PRIMARY KEY (MANDT, ATTRIBUTE_GUID, LANGUAGECODE, CTLG_ITM_KEY)
);