MMPUR_CAT_DSCTXT

Transparent Table Application Table
4 Fields 3 CDS Views

Text table for description text

MMPUR_CAT_DSCTXT is an SAP database table in S/4HANA. Text table for description text. It contains 4 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CatalogItemDescription view from BASIC Description of catalog item
I_CatalogMaterialText view from BASIC CDS View for Catalog Material Text
I_OpnCtlgDescription view from BASIC Catalog Item Description

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
description MMPUR_CAT_DESC_TEXT Product Description

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 description text
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_CAT_DSCTXT (
    MANDT,         -- Client [MANDT]
    CTLG_ITM_KEY,  -- Catalog Item Key [MMPUR_CAT_D_ITM_KEY]
    LANGUAGE,      -- Language Key [MMPUR_CAT_LANGUAGE]
    DESCRIPTION,   -- Product Description [MMPUR_CAT_DESC_TEXT]
    PRIMARY KEY (MANDT, CTLG_ITM_KEY, LANGUAGE)
);

Learn More