MMPUR_CAT_ITMATR
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CtlgSrchAttributes | view | from | BASIC | Attribute for Catalog Items |
| I_OpnCtlgAttribute | view | from | BASIC | Catalog Item Attribute |
Fields (8)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA