MDQ_RULE_DEF_D

Transparent Table Application Table
24 Fields 2 CDS Views

I_MDQUALITYBUSINESSRULETP I_MDQUALITYBUSINESSRULETP

MDQ_RULE_DEF_D is an SAP database table in S/4HANA. I_MDQUALITYBUSINESSRULETP I_MDQUALITYBUSINESSRULETP. It contains 24 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MDQltyBusRuleActvDrftMapping view_entity left_outer BASIC Master Data Quality Business Rule Draft Mapping
I_MDQualityBusinessRule view_entity left_outer BASIC Master Data Quality Business Rule

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY mdqualitybusinessruleuuid mdq_rule_definition_uuid Rule UUID
mdqltybusinessruleactiveuuid mdq_rule_definition_uuid Rule UUID
mdqualitybusinessrule mdq_rule_definition_id Rule Definition ID
mdqualitybusinessrulename mdq_rule_definition_name Rule Name
mdqltybusinessobjecttypecode mdg_object_type_code_bs Bus. Obj. Type
mdqltybusinessrulebasetable mdq_base_table Base Table
mdqltybusinessrulestatus mdq_rule_status Rule Status
mdqltybusrulecreationdatetime timestampl Time Stamp
mdqltybusrulecreatedbyuser uname User Name
mdqltybusrulechangedatetime timestampl Time Stamp
mdqltybusrulechangedbyuser uname User Name
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
mdqltybusinessrulehasnoresults abap_boolean Truth Value
mdqltyrulehaslinkedminedrules mdq_rule_linked_to_mined_rule Linkage
mdqltybusruleusgeispermitted mdq_rule_usage_permitted Permitted
mdqltybusruleusgeisforbidden abap.char
mdchgprocrapbsdswitchisactive boole_d TRUE
activeuuid /bobf/uuid Key
hasactiveentity sdraft_has_active Has active

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.

-- I_MDQUALITYBUSINESSRULETP I_MDQUALITYBUSINESSRULETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MDQ_RULE_DEF_D (
    MANDT,                           -- Client [mandt]
    MDQUALITYBUSINESSRULEUUID,       -- Rule UUID [mdq_rule_definition_uuid]
    MDQLTYBUSINESSRULEACTIVEUUID,    -- Rule UUID [mdq_rule_definition_uuid]
    MDQUALITYBUSINESSRULE,           -- Rule Definition ID [mdq_rule_definition_id]
    MDQUALITYBUSINESSRULENAME,       -- Rule Name [mdq_rule_definition_name]
    MDQLTYBUSINESSOBJECTTYPECODE,    -- Bus. Obj. Type [mdg_object_type_code_bs]
    MDQLTYBUSINESSRULEBASETABLE,     -- Base Table [mdq_base_table]
    MDQLTYBUSINESSRULESTATUS,        -- Rule Status [mdq_rule_status]
    MDQLTYBUSRULECREATIONDATETIME,   -- Time Stamp [timestampl]
    MDQLTYBUSRULECREATEDBYUSER,      -- User Name [uname]
    MDQLTYBUSRULECHANGEDATETIME,     -- Time Stamp [timestampl]
    MDQLTYBUSRULECHANGEDBYUSER,      -- User Name [uname]
    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]
    MDQLTYBUSINESSRULEHASNORESULTS,  -- Truth Value [abap_boolean]
    MDQLTYRULEHASLINKEDMINEDRULES,   -- Linkage [mdq_rule_linked_to_mined_rule]
    MDQLTYBUSRULEUSGEISPERMITTED,    -- Permitted [mdq_rule_usage_permitted]
    MDQLTYBUSRULEUSGEISFORBIDDEN,    -- abap.char
    MDCHGPROCRAPBSDSWITCHISACTIVE,   -- TRUE [boole_d]
    ACTIVEUUID,                      -- Key [/bobf/uuid]
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, MDQUALITYBUSINESSRULEUUID)
);

Learn More