MDQ_DS_SCN - Derivation Scenario
Derivation Scenario information is stored in SAP table MDQ_DS_SCN.
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_SCN
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CLIENT | Client | X | MANDT | CLNT | 6 | |
| MDQLTYDRVTNSCENUUID | UUID of Derivation Scenario | X | MDQ_DS_SCENARIO_UUID | RAW | 16 | |
| .INCLUDE | SCENARIO_KEYS | MDQ_S_DS_SCENARIO_KEY | 0 | |||
| MDQLTYDRVTNSCEN | ID of Derivation Scenario | MDQ_DS_SCENARIO_ID | CHAR | 40 | ||
| MDQLTYBUSINESSOBJECTTYPECODE | Business Object Type | MDG_OBJECT_TYPE_CODE_BS | CHAR | 20 | ||
| .INCLUDE | SCENARIO_ATTRIBUTES | MDQ_S_DS_SCENARIO_ATTRIBUTES | 0 | |||
| MDQLTYDRVTNSCENNAME | Name of Derivation Scenario | MDQ_DS_SCENARIO_NAME | CHAR | 100 | ||
| MDQLTYDRVTNSCENBASETABLE | Base Table for Derivation Scenario | MDQ_DS_BASE_TABLE | CHAR | 60 | * | |
| MDQLTYDRVTNSCENDESCRIPTION | Description of Derivation Scenario | MDQ_DS_SCENARIO_DESCRIPTION | STRG | 8 | ||
| MDQLTYDRVTNSCENSTATUS | Status of the Derivation Scenario | MDQ_DS_SCENARIO_STATUS | NUMC | 4 | ||
| MDQLTYDRVTNSCENOWNER | Scenario Owner | MDQ_DS_SCENARIO_OWNER | CHAR | 24 | ||
| MDQLTYDRVTNSCENEXPERT | Scenario Expert | MDQ_DS_SCENARIO_EXPERT | CHAR | 24 | ||
| MDQLTYDRVTNSCENSCOPEDESC | Scope Description for Derivation Scenario | MDQ_DS_SCENARIO_SCOPE_DESC | CHAR | 500 | ||
| MDQLTYDRVTNGNRTNSTARTDATETIME | Start Date and Time of Artefact Generation | MDQ_DS_GENERATION_DATE_TIME | DEC | 11 | ||
| MDQLTYDRVTNSCENSTATUSBFRGNRTN | Scenario Status Before Generation. | MDQ_DS_SCEN_STATUS_BFR_GNRTN | NUMC | 4 | ||
| MDQLTYDRVTNSCENCRTNDATETIME | Date and Time When the Entry Was Created | MDQ_DS_CREATION_DATE_TIME | DEC | 11 | ||
| MDQLTYDRVTNSCENCREATEDBYUSER | User Who Created the Entry | MDQ_DS_CREATED_BY_USER | CHAR | 24 | ||
| MDQLTYDRVTNSCENCHANGEDATETIME | Date and Time When the Entry Was Changed | MDQ_DS_CHANGE_DATE_TIME | DEC | 11 | ||
| MDQLTYDRVTNSCENCHANGEDBYUSER | User Who Changed the Entry | MDQ_DS_CHANGED_BY_USER | CHAR | 24 | ||
| MDQLTYDRVTNSCENLASTCHGDATETIME | Date and Time When the Entry Was Last Changed | MDQ_DS_LAST_CHANGE_DATE_TIME | DEC | 11 |