MDQ_MINEDRULES

Transparent Table Application Table
19 Fields 1 CDS Views

Master Data Quality Mined Rules

MDQ_MINEDRULES is an SAP database table in S/4HANA. Master Data Quality Mined Rules. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MDQltyMinedRule view from BASIC Master Data Quality Mined Rule

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY mdqltyminedruleuuid MDQ_MINEDRULE_UUID Mined Rule UUID
mdqltybusinessobjecttypecode MDC_OBJECT_TYPE_CODE Bus. Obj. Type
mdqltyminedrule MDQ_MINEDRULE_ID Mined Rule ID
mdqltyminedrulerecdvioltncnt MDQ_MNDRUL_REC_VIOLTN_CNT Violation Count
mdqltyminedrulerecdcmplnccnt MDQ_MNDRUL_REC_COMPLNT_CNT Compliant Records
mdqltyminedrulerecdnotrlvtcnt MDQ_MNDRUL_REC_NOT_RELVT_CNT Records Not Relevant
mdqltyminedrulestatus MDQ_MNDRUL_STATUS Mined Rule Status
mdqltyminedrulestsdcsnusr UNAME User Name
mdqltyminedrulestsdcsndatetime MDQ_MNDRUL_STAT_DECISN_DTETME Status Decision Time
mdqltyminedrulerecdevaldtetme MDQ_RULEMINING_COMPLTN_DTETME Completed At
mdqltyminedrulechkdfieldtable MDQ_MINEDRULE_CHKDFLD_TABLE Checked Field Table
mdqltyminedrulechkdfield MDQ_MINEDRULE_CHKDFIELD Checked Field
mdqltyminedrulechkdfieldvalue MDQ_MINEDRULE_CHKDFLD_VALUE Checked Field Value
mdqltyminedrulechgdbyusr UNAME User Name
mdqltyminedrulechgddatetime MDQ_MINEDRULE_CHANGE_DTETME Changed On
mdqltyminedrulehash MDQ_MINEDRULE_HASH Checked Field
mdqltyminedrulecreationusr UNAME User Name
mdqltyminedrulecreationdtetme MDQ_MNDRUL_CREATION_DTETME Created On

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 Mined Rules
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDQ_MINEDRULES (
    CLIENT,                          -- Client [MANDT]
    MDQLTYMINEDRULEUUID,             -- Mined Rule UUID [MDQ_MINEDRULE_UUID]
    MDQLTYBUSINESSOBJECTTYPECODE,    -- Bus. Obj. Type [MDC_OBJECT_TYPE_CODE]
    MDQLTYMINEDRULE,                 -- Mined Rule ID [MDQ_MINEDRULE_ID]
    MDQLTYMINEDRULERECDVIOLTNCNT,    -- Violation Count [MDQ_MNDRUL_REC_VIOLTN_CNT]
    MDQLTYMINEDRULERECDCMPLNCCNT,    -- Compliant Records [MDQ_MNDRUL_REC_COMPLNT_CNT]
    MDQLTYMINEDRULERECDNOTRLVTCNT,   -- Records Not Relevant [MDQ_MNDRUL_REC_NOT_RELVT_CNT]
    MDQLTYMINEDRULESTATUS,           -- Mined Rule Status [MDQ_MNDRUL_STATUS]
    MDQLTYMINEDRULESTSDCSNUSR,       -- User Name [UNAME]
    MDQLTYMINEDRULESTSDCSNDATETIME,  -- Status Decision Time [MDQ_MNDRUL_STAT_DECISN_DTETME]
    MDQLTYMINEDRULERECDEVALDTETME,   -- Completed At [MDQ_RULEMINING_COMPLTN_DTETME]
    MDQLTYMINEDRULECHKDFIELDTABLE,   -- Checked Field Table [MDQ_MINEDRULE_CHKDFLD_TABLE]
    MDQLTYMINEDRULECHKDFIELD,        -- Checked Field [MDQ_MINEDRULE_CHKDFIELD]
    MDQLTYMINEDRULECHKDFIELDVALUE,   -- Checked Field Value [MDQ_MINEDRULE_CHKDFLD_VALUE]
    MDQLTYMINEDRULECHGDBYUSR,        -- User Name [UNAME]
    MDQLTYMINEDRULECHGDDATETIME,     -- Changed On [MDQ_MINEDRULE_CHANGE_DTETME]
    MDQLTYMINEDRULEHASH,             -- Checked Field [MDQ_MINEDRULE_HASH]
    MDQLTYMINEDRULECREATIONUSR,      -- User Name [UNAME]
    MDQLTYMINEDRULECREATIONDTETME,   -- Created On [MDQ_MNDRUL_CREATION_DTETME]
    PRIMARY KEY (CLIENT, MDQLTYMINEDRULEUUID)
);

Learn More