MDQ_RULE_DEF_D

Transparent Table Application Table
29 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 29 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 (29)

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
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code

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]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    PRIMARY KEY (MANDT, MDQUALITYBUSINESSRULEUUID)
);

Learn More