MMPUR_CT_ITM_SRH

Transparent Table Application Table
5 Fields 3 CDS Views

Item search

MMPUR_CT_ITM_SRH is an SAP database table in S/4HANA. Item search. It contains 5 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CatalogItemSearchTerm view from BASIC Catalog Item Search Term Interface View
I_OpnCtlgSearchTerm view from BASIC Search term for Catalog Item
P_Searchterms view from BASIC

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY ctlg_itm_key mmpur_cat_d_itm_key Catalog Item Key
KEY languagecode spras Language
KEY sequence_no int4 INT4
search_term char255 Char255

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.

-- Item search
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_CT_ITM_SRH (
    MANDT,         -- Client [mandt]
    CTLG_ITM_KEY,  -- Catalog Item Key [mmpur_cat_d_itm_key]
    LANGUAGECODE,  -- Language [spras]
    SEQUENCE_NO,   -- INT4 [int4]
    SEARCH_TERM,   -- Char255 [char255]
    PRIMARY KEY (MANDT, CTLG_ITM_KEY, LANGUAGECODE, SEQUENCE_NO)
);

Learn More