MDQ_RULE_DEF - Master Data Quality Rule Definition

Master Data Quality Rule Definition information is stored in SAP table MDQ_RULE_DEF.
It is part of development package MDQ_RULEMGMT_RULE in software component CA-MDG-ADQ. This development package consists of objects that can be grouped under "Master Data Quality Rule Definition".

Fields for table MDQ_RULE_DEF

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6
MDQUALITYBUSINESSRULEUUID	MDQ Rule Definition UUID	X	MDQ_RULE_DEFINITION_UUID	RAW	16
MDQLTYBUSRULECREATIONDATETIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)		TIMESTAMPL	DEC	11
MDQLTYBUSRULECREATEDBYUSER	User Name		UNAME	CHAR	24
MDQLTYBUSRULECHANGEDATETIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)		TIMESTAMPL	DEC	11
MDQLTYBUSRULECHANGEDBYUSER	User Name		UNAME	CHAR	24
.INCLUDE	RULE_KEYS			MDQ_S_RUL_DEF_KEY	0
MDQUALITYBUSINESSRULE	Master Data Quality Rule Definition ID		MDQ_RULE_DEFINITION_ID	CHAR	52
MDQLTYBUSINESSOBJECTTYPECODE	Business Object Type		MDG_OBJECT_TYPE_CODE_BS	CHAR	20
.INCLUDE	RULE_ATTRIBUTES			MDQ_S_RUL_DEF_ATTRIBUTES	0
MDQUALITYBUSINESSRULENAME	Master Data Quality Rule Definition Name		MDQ_RULE_DEFINITION_NAME	CHAR	100
MDQLTYBUSINESSRULEBASETABLE	Master Data Quality Base Table		MDQ_BASE_TABLE	CHAR	60	*
MDQLTYBUSINESSRULESTATUS	Master Data Quality: Validation Rule Status		MDQ_RULE_STATUS	CHAR	20
MDQLTYBUSINESSRULEOWNER	Master Data Quality Business Rule Owner		MDQ_RULE_OWNER	CHAR	24
MDQLTYBUSINESSRULEEXPERT	Master Data Quality Business Rule Expert		MDQ_RULE_EXPERT	CHAR	24
MDQLTYBUSRULECHECKEDFIELD	Master Data Quality Fieldname of the Checked Field		MDQ_CHKFLD_FIELDNAME	CHAR	60	*
MDQLTYBUSRULECHECKEDFIELDTABLE	Maste Data Quality Table Name of Checked Field		MDQ_CHKFLD_TABNAME	CHAR	60	*
MDQLTYBUSRULECHKDFIELDANDTABLE	Master Data Quality Table and Field Name of Checked Field		MDQ_CHKFLD_TABANDFIELDNAME	CHAR	122
MDQLTYBUSRULEUSGEISPERMITTED	Master Data Quality Rule Usage is Permitted		MDQ_RULE_USAGE_PERMITTED	CHAR	2