MDC_SEARCH

Transparent Table Application Table
10 Fields 1 CDS Views

Saved Searches

MDC_SEARCH is an SAP database table in S/4HANA. Saved Searches. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MDChgProcessSearch view from BASIC Master Data Change Process Search

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY search_guid MDC_WL_SEARCH_GUID GUID
description MDC_WL_SEARCH_DESCRIPTION Description
bo_type MDG_OBJECT_TYPE_CODE_BS Bus. Obj. Type
created_by MDC_SEARCH_USER_NAME User Name
created_at MDC_SEARCH_CREATED_AT Changed at
changed_by MDC_SEARCH_USER_NAME User Name
changed_at MDC_SEARCH_CHANGED_AT Changed at
promoter_id PROM_PROMOTER_ID Promoter ID
promotion_id PROM_PROMOTION_ID Promotion ID

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.

-- Saved Searches
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDC_SEARCH (
    CLIENT,        -- Client [MANDT]
    SEARCH_GUID,   -- GUID [MDC_WL_SEARCH_GUID]
    DESCRIPTION,   -- Description [MDC_WL_SEARCH_DESCRIPTION]
    BO_TYPE,       -- Bus. Obj. Type [MDG_OBJECT_TYPE_CODE_BS]
    CREATED_BY,    -- User Name [MDC_SEARCH_USER_NAME]
    CREATED_AT,    -- Changed at [MDC_SEARCH_CREATED_AT]
    CHANGED_BY,    -- User Name [MDC_SEARCH_USER_NAME]
    CHANGED_AT,    -- Changed at [MDC_SEARCH_CHANGED_AT]
    PROMOTER_ID,   -- Promoter ID [PROM_PROMOTER_ID]
    PROMOTION_ID,  -- Promotion ID [PROM_PROMOTION_ID]
    PRIMARY KEY (CLIENT, SEARCH_GUID)
);

Learn More