The BUT_ADR6_DQ_RES table in SAP ERP or S/4HANA stores Master Data Quality Results of OTC 147, Table ADR6 data. There are total 12 fields in BUT_ADR6_DQ_RES table. The Master Data Quality Results of OTC 147, Table ADR6 table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of BUT_ADR6_DQ_RES table. It is in Master Data Quality Evaluation Results for Business Partner (MDQ_EVAL_RESULTS_BUPA) ABAP package and is part of the Analysis and Remediation of Data Quality. (CA-MDG-ADQ) module.
SAP BUT_ADR6_DQ_RES Table Fields
Following is the list of fields that are available in SAP BUT_ADR6_DQ_RES table. The primary key fields of the table are CLIENT (Client), PROCESS_ID (Master Data Change Process Identifier), PROCESS_STEP_NO (Master Data Change Process Step Number), SOURCE_SYSTEM (Source System), SOURCE_ID (Master Data Consolidation: ID of a Source Objects), SOURCE_ADDRNUMBER (Address Number), DATE_FROM (Valid-from date – in current Release only 00010101 possible), CONSNUMBER (Sequence Number), RULEUUID (MDQ Rule Definition UUID), RESULTTYPE (Master Data Quality Rule Evaluation Result Type).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| PROCESS_ID | Master Data Change Process Identifier | MDC_PROCESS_ID | NUMC (12) | |
| PROCESS_STEP_NO | Master Data Change Process Step Number | MDC_PROCESS_STEP_NO | NUMC (4) | |
| SOURCE_SYSTEM | Source System | MDC_BUSINESS_SYSTEM | CHAR (60) | |
| SOURCE_ID | Master Data Consolidation: ID of a Source Objects | MDC_SOURCE_ID | CHAR (60) | |
| SOURCE_ADDRNUMBER | Address Number | AD_ADDRNUM | CHAR (10) | |
| DATE_FROM | Valid-from date – in current Release only 00010101 possible | AD_DATE_FR | DATS (8) | |
| CONSNUMBER | Sequence Number | AD_CONSNUM | NUMC (3) | |
| RULEUUID | MDQ Rule Definition UUID | MDQ_RULE_DEFINITION_UUID | RAW (16) | |
| RESULTTYPE | Master Data Quality Rule Evaluation Result Type | MDQ_RULE_EVAL_RESULT_TYPE | CHAR (1) | |
| BASETABLE | Master Data Quality Base Table | MDQ_BASE_TABLE | CHAR (30) | |
| PARTNER | Business Partner Number | BU_PARTNER | CHAR (10) |
