MDSUBRULE

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

Master Data Substitution Rule

MDSUBRULE is an SAP database table in S/4HANA. Master Data Substitution Rule. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MDSubstnRule view_entity from BASIC Master Data Substitution Rule

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY rule_name MD_SUBSTN_RULE_NAME Rule Name
has_validities MD_SUBSTN_CONSIDER_VALIDITIES Supports Time Range
has_sets MD_SUBSTN_CONSIDER_SETS Supports Sets
has_conversions MD_SUBSTN_CONSIDER_CONVERSIONS Supports Conversion Factor
has_percent MD_SUBSTN_CONSIDER_PERCENT Supports Percentage Factor
has_groups MD_SUBSTN_CONSIDER_GROUPS Supports Groups
has_versions MD_SUBSTN_CONSIDER_VERSIONS Supports Versions
is_atp_prod MD_SUBSTN_IS_ATP_PRODUCT aATP Relevant
is_atp_plant MD_SUBSTN_IS_ATP_PLANT ATP Plant
is_espp MD_SUBSTN_IS_ESPP eSPP Relevant
is_atp_sloc MD_SUBSTN_IS_ATP_SLOC ATP Storage Location
is_atp_mrp_area MD_SUBSTN_IS_ATP_MRP_AREA ATP MRP Area

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 Rule
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDSUBRULE (
    RULE_NAME,        -- Rule Name [MD_SUBSTN_RULE_NAME]
    HAS_VALIDITIES,   -- Supports Time Range [MD_SUBSTN_CONSIDER_VALIDITIES]
    HAS_SETS,         -- Supports Sets [MD_SUBSTN_CONSIDER_SETS]
    HAS_CONVERSIONS,  -- Supports Conversion Factor [MD_SUBSTN_CONSIDER_CONVERSIONS]
    HAS_PERCENT,      -- Supports Percentage Factor [MD_SUBSTN_CONSIDER_PERCENT]
    HAS_GROUPS,       -- Supports Groups [MD_SUBSTN_CONSIDER_GROUPS]
    HAS_VERSIONS,     -- Supports Versions [MD_SUBSTN_CONSIDER_VERSIONS]
    IS_ATP_PROD,      -- aATP Relevant [MD_SUBSTN_IS_ATP_PRODUCT]
    IS_ATP_PLANT,     -- ATP Plant [MD_SUBSTN_IS_ATP_PLANT]
    IS_ESPP,          -- eSPP Relevant [MD_SUBSTN_IS_ESPP]
    IS_ATP_SLOC,      -- ATP Storage Location [MD_SUBSTN_IS_ATP_SLOC]
    IS_ATP_MRP_AREA,  -- ATP MRP Area [MD_SUBSTN_IS_ATP_MRP_AREA]
    PRIMARY KEY (RULE_NAME)
);

Learn More