MDQ_MINEDRULES

Transparent Table Application Table
19 Fields 1 CDS Views

Master Data Quality Mined Rule

MDQ_MINEDRULES is an SAP database table in S/4HANA. Master Data Quality Mined Rule. 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 Rule
-- 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