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