MDQ_RULE_DEF

Transparent Table Application Table
17 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 17 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_MDQualityBusinessRule_2 view_entity from Master Data Quality Business Rule
I_MDQualityBusinessRuleKeys view from BASIC Master Data Quality Business Rule Keys
I_MDQualityTechnicalRule view_entity from BASIC Master Data Quality Technical Rule

Fields (17)

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
mdqualitybusinessrule MDQ_RULE_DEFINITION_ID Rule Definition ID
mdqltybusinessobjecttypecode MDG_OBJECT_TYPE_CODE_BS Bus. Obj. Type
mdqualitybusinessrulename MDQ_RULE_DEFINITION_NAME Rule Name
mdqltybusinessrulebasetable MDQ_BASE_TABLE Base Table
mdqltybusinessrulestatus MDQ_RULE_STATUS Rule Status
mdqltybusinessruleowner MDQ_RULE_OWNER Rule Owner
mdqltybusinessruleexpert MDQ_RULE_EXPERT Rule Expert
mdqltybusrulecheckedfield MDQ_CHKFLD_FIELDNAME Fieldname
mdqltybusrulecheckedfieldtable MDQ_CHKFLD_TABNAME Chkd. Field Table
mdqltybusrulechkdfieldandtable MDQ_CHKFLD_TABANDFIELDNAME Table and Field Name
mdqltybusruleusgeispermitted MDQ_RULE_USAGE_PERMITTED Permitted

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]
    MDQUALITYBUSINESSRULE,           -- Rule Definition ID [MDQ_RULE_DEFINITION_ID]
    MDQLTYBUSINESSOBJECTTYPECODE,    -- Bus. Obj. Type [MDG_OBJECT_TYPE_CODE_BS]
    MDQUALITYBUSINESSRULENAME,       -- Rule Name [MDQ_RULE_DEFINITION_NAME]
    MDQLTYBUSINESSRULEBASETABLE,     -- Base Table [MDQ_BASE_TABLE]
    MDQLTYBUSINESSRULESTATUS,        -- Rule Status [MDQ_RULE_STATUS]
    MDQLTYBUSINESSRULEOWNER,         -- Rule Owner [MDQ_RULE_OWNER]
    MDQLTYBUSINESSRULEEXPERT,        -- Rule Expert [MDQ_RULE_EXPERT]
    MDQLTYBUSRULECHECKEDFIELD,       -- Fieldname [MDQ_CHKFLD_FIELDNAME]
    MDQLTYBUSRULECHECKEDFIELDTABLE,  -- Chkd. Field Table [MDQ_CHKFLD_TABNAME]
    MDQLTYBUSRULECHKDFIELDANDTABLE,  -- Table and Field Name [MDQ_CHKFLD_TABANDFIELDNAME]
    MDQLTYBUSRULEUSGEISPERMITTED,    -- Permitted [MDQ_RULE_USAGE_PERMITTED]
    PRIMARY KEY (CLIENT, MDQUALITYBUSINESSRULEUUID)
);

Learn More