MDQ_DS_RULE - Derivation Scenario Rule
Derivation Scenario Rule information is stored in SAP table MDQ_DS_RULE.
It is part of development package MDQ_RULEMGMT_DERIVATION in software component CA-MDG-ADQ-RUL. This development package consists of objects that can be grouped under "Master Data Quality Rule Management: Derivation Rules".
It is part of development package MDQ_RULEMGMT_DERIVATION in software component CA-MDG-ADQ-RUL. This development package consists of objects that can be grouped under "Master Data Quality Rule Management: Derivation Rules".
Fields for table MDQ_DS_RULE
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | X | CLNT | 6 | |||
| MDQLTYDRVTNSCENRULEUUID | UUID of Derivation Rule | X | MDQ_DS_RULE_UUID | RAW | 16 | |
| MDQLTYDRVTNSCENUUID | UUID of Derivation Scenario | MDQ_DS_SCENARIO_UUID | RAW | 16 | MDQ_DS_SCN | |
| .INCLUDE | RULE_ATTRIBUTES | MDQ_S_DS_RULE_ATTRIBUTES | 0 | |||
| MDQLTYDRVTNSCENRULE | ID of Derivation Rule | MDQ_DS_RULE_ID | CHAR | 40 | ||
| MDQLTYDRVTNSCENRULENAME | Name of Derivation Rule | MDQ_DS_RULE_NAME | CHAR | 100 | ||
| MDQLTYDRVTNSCENRULETYPE | Type of Derivation Rule | MDQ_DS_RULE_TYPE | CHAR | 20 | ||
| MDQLTYDRVTNSCENRULEDESCRIPTION | Description for Derivation Rule | MDQ_DS_RULE_DESC | CHAR | 500 | ||
| MDQLTYDRVTNSCENRULESCOPEDESC | Scope Description for Derivation Rule | MDQ_DS_RULE_SCOPE_DESC | CHAR | 500 | ||
| MDQLTYDRVTNSCENRULETABLE | Base Table for Derivation Rule | MDQ_DS_RULE_TABLE | CHAR | 60 | * | |
| MDQLTYDRVTNSCENRULERESULTTABLE | Result Table for Derivation Rule | MDQ_DS_RULE_RESULT_TABLE | CHAR | 60 | * | |
| MDQLTYDRVTNSCENRULESTATUS | Status of the Derivation Rule | MDQ_DS_RULE_STATUS | NUMC | 4 | ||
| MDQLTYDRVTNSCENRULEOWNER | Rule Owner | MDQ_DS_RULE_OWNER | CHAR | 24 | ||
| MDQLTYDRVTNSCENRULEDATAOWNER | Rule Data Owner | MDQ_DS_RULE_DATA_OWNER | CHAR | 24 | ||
| MDQLTYDRVTNSCENRULEEXECSTATUS | Execution Status of Derivation Rule | MDQ_DS_RULE_EXEC_STATUS | NUMC | 4 | ||
| MDQLTYDRVTNSCENRULEEXECSQNC | Execution Sequence | MDQ_DS_RULE_EXEC_SEQUENCE | NUMC | 8 | ||
| MDQLTYDRVTNRULEDCSNTBLISCUR | Derivation rule๏ฟฝs decision table is current | MDQ_DS_RULE_DT_IS_CURRENT | CHAR | 2 | ||
| MDQLTYDRVTNSCENRULECSTMISACTV | Custom adjustment of the rule artifacts is required. | MDQ_DS_RULE_CUSTOM_IS_ACTIV | CHAR | 2 | ||
| MDQLTYDRVTNSCENRULESTSBFRGNRTN | Rule Status Before Generation | MDQ_DS_RULE_STATUS_BFR_GNRTN | NUMC | 4 |