MDQ_RULEMINING

Transparent Table Application Table
15 Fields 1 CDS Views

Master Data Quality Rule Mining

MDQ_RULEMINING is an SAP database table in S/4HANA. Master Data Quality Rule Mining. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MDQltyRuleMining view from BASIC MDQlty Manage Mining Runs

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY mdqltyrulemininguuid mdq_rulemining_uuid Rule Mining UUID
mdqltybusinessobjecttypecode mdc_object_type_code Bus. Obj. Type
mdqltyrulemining mdq_rulemining_id Mining Run
mdqltyruleminingtext mdq_rulemining_text Description
mdqltyrulemininggoaltext mdq_rulemining_goaltxt Goal
mdqltyruleminingmaxnmbrofrules mdq_rulemining_max_nmbr_rule Max. No. of Rules
mdqltyruleminingstatus mdq_rulemining_status Rule Mining Status
mdqltyruleminingcreationdtetme mdq_rulemining_create_dtetme Created At
mdqltyruleminingcrtedbyusr uname User Name
mdqltyruleminingchangedatetime mdq_rulemining_change_dtetme Changed On
mdqltyruleminingchgdbyusr uname User Name
mdqltyruleminingcompltndtetme mdq_rulemining_compltn_dtetme Completed At
mdqltyruleminingjob btcjob Job Name
mdqltyruleminingjobinstance btcjobcnt Job No.

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 Mining
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDQ_RULEMINING (
    CLIENT,                          -- Client [mandt]
    MDQLTYRULEMININGUUID,            -- Rule Mining UUID [mdq_rulemining_uuid]
    MDQLTYBUSINESSOBJECTTYPECODE,    -- Bus. Obj. Type [mdc_object_type_code]
    MDQLTYRULEMINING,                -- Mining Run [mdq_rulemining_id]
    MDQLTYRULEMININGTEXT,            -- Description [mdq_rulemining_text]
    MDQLTYRULEMININGGOALTEXT,        -- Goal [mdq_rulemining_goaltxt]
    MDQLTYRULEMININGMAXNMBROFRULES,  -- Max. No. of Rules [mdq_rulemining_max_nmbr_rule]
    MDQLTYRULEMININGSTATUS,          -- Rule Mining Status [mdq_rulemining_status]
    MDQLTYRULEMININGCREATIONDTETME,  -- Created At [mdq_rulemining_create_dtetme]
    MDQLTYRULEMININGCRTEDBYUSR,      -- User Name [uname]
    MDQLTYRULEMININGCHANGEDATETIME,  -- Changed On [mdq_rulemining_change_dtetme]
    MDQLTYRULEMININGCHGDBYUSR,       -- User Name [uname]
    MDQLTYRULEMININGCOMPLTNDTETME,   -- Completed At [mdq_rulemining_compltn_dtetme]
    MDQLTYRULEMININGJOB,             -- Job Name [btcjob]
    MDQLTYRULEMININGJOBINSTANCE,     -- Job No. [btcjobcnt]
    PRIMARY KEY (CLIENT, MDQLTYRULEMININGUUID)
);

Learn More