MDSUBSRCE

Transparent Table System Table (SAP only)
6 Fields 1 CDS Views

Master Data Substitution Source

MDSUBSRCE is an SAP database table in S/4HANA. Master Data Substitution Source. It contains 6 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MDSubstnSource view_entity from BASIC Master Data Substitution Source

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY source MD_SUBSTN_SOURCE Source Name
object_type SBO_BO_TYPE SAP Object Type
implementation MD_SUBSTN_IMPLEMENTATION Implementation
rule_name MD_SUBSTN_RULE_NAME Rule Name
context_type1 SBO_BO_TYPE SAP Object Type
context_type2 SBO_BO_TYPE SAP Object Type

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.

-- Master Data Substitution Source
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDSUBSRCE (
    SOURCE,          -- Source Name [MD_SUBSTN_SOURCE]
    OBJECT_TYPE,     -- SAP Object Type [SBO_BO_TYPE]
    IMPLEMENTATION,  -- Implementation [MD_SUBSTN_IMPLEMENTATION]
    RULE_NAME,       -- Rule Name [MD_SUBSTN_RULE_NAME]
    CONTEXT_TYPE1,   -- SAP Object Type [SBO_BO_TYPE]
    CONTEXT_TYPE2,   -- SAP Object Type [SBO_BO_TYPE]
    PRIMARY KEY (SOURCE)
);

Learn More