MDQ_RULE_DEF

Transparent Table Application Table
6 Fields 5 CDS Views

Master Data Quality Rule Definition

MDQ_RULE_DEF is an SAP database table in S/4HANA. Master Data Quality Rule Definition. It contains 6 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_MDQltyBusRuleActvDrftMapping view_entity from BASIC Master Data Quality Business Rule Draft Mapping
I_MDQualityBusinessRule view_entity from BASIC Master Data Quality Business Rule
I_MDQualityBusinessRuleKeys view from BASIC Master Data Quality Business Rule Keys
I_MDQualityBusinessRuleTP view_entity from TRANSACTIONAL Master Data Quality Business Rule
I_MDQualityTechnicalRule view_entity from BASIC Master Data Quality Technical Rule

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY mdqualitybusinessruleuuid mdq_rule_definition_uuid Rule UUID
mdqltybusrulecreationdatetime timestampl Time Stamp
mdqltybusrulecreatedbyuser uname User Name
mdqltybusrulechangedatetime timestampl Time Stamp
mdqltybusrulechangedbyuser uname User Name

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 Quality Rule Definition
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDQ_RULE_DEF (
    CLIENT,                         -- Client [mandt]
    MDQUALITYBUSINESSRULEUUID,      -- Rule UUID [mdq_rule_definition_uuid]
    MDQLTYBUSRULECREATIONDATETIME,  -- Time Stamp [timestampl]
    MDQLTYBUSRULECREATEDBYUSER,     -- User Name [uname]
    MDQLTYBUSRULECHANGEDATETIME,    -- Time Stamp [timestampl]
    MDQLTYBUSRULECHANGEDBYUSER,     -- User Name [uname]
    PRIMARY KEY (CLIENT, MDQUALITYBUSINESSRULEUUID)
);

Learn More