MDQ_RULE_DEFD

Transparent Table Application Table
9 Fields 1 CDS Views

Master Data Quality Rule Defintion Details/Descriptions

MDQ_RULE_DEFD is an SAP database table in S/4HANA. Master Data Quality Rule Defintion Details/Descriptions. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MDQltyBusinessRuleDetails view_entity from BASIC Master Data Quality Business Rule Details

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY mdqualitybusinessruleuuid MDQ_RULE_DEFINITION_UUID Rule UUID
mdqltybusinessruledescription MDQ_RULE_DEFINITION_DESCR Description
mdqltybusrulescopedescription MDQ_RULE_SCOPE_DESCR Scope
mdqltybusrulebusrsndescription MDQ_RULE_BUSINESS_REASON Business Reason
mdqltybusruledetailsurl MDQ_RULE_DEFINITION_URL Rule URL
mdqltybusruledetailsurltext MDQ_RULE_DEFINITION_URL_TEXT Rule URL Text
mdqltybusruledataownertext MDQ_RULE_DATA_OWNER Data Owner
mdqltybusrulebuscontacttext MDQ_RULE_BUSINESS_CONTACT Business Contact

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 Defintion Details/Descriptions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDQ_RULE_DEFD (
    CLIENT,                          -- Client [MANDT]
    MDQUALITYBUSINESSRULEUUID,       -- Rule UUID [MDQ_RULE_DEFINITION_UUID]
    MDQLTYBUSINESSRULEDESCRIPTION,   -- Description [MDQ_RULE_DEFINITION_DESCR]
    MDQLTYBUSRULESCOPEDESCRIPTION,   -- Scope [MDQ_RULE_SCOPE_DESCR]
    MDQLTYBUSRULEBUSRSNDESCRIPTION,  -- Business Reason [MDQ_RULE_BUSINESS_REASON]
    MDQLTYBUSRULEDETAILSURL,         -- Rule URL [MDQ_RULE_DEFINITION_URL]
    MDQLTYBUSRULEDETAILSURLTEXT,     -- Rule URL Text [MDQ_RULE_DEFINITION_URL_TEXT]
    MDQLTYBUSRULEDATAOWNERTEXT,      -- Data Owner [MDQ_RULE_DATA_OWNER]
    MDQLTYBUSRULEBUSCONTACTTEXT,     -- Business Contact [MDQ_RULE_BUSINESS_CONTACT]
    PRIMARY KEY (CLIENT, MDQUALITYBUSINESSRULEUUID)
);

Learn More