SAP Analysis and Remediation of Data Quality. Tables

Are you looking for the right table related to SAP Analysis and Remediation of Data Quality. Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Analysis and Remediation of Data Quality. (CA-MDG-ADQ) module.

Top 10 tables in Analysis and Remediation of Data Quality.

TableDescription
MBEW_DQ_RESMaster Data Quality Results of OTC 194, Table MBEW
MARA_AUSP_DQ_RESMaster Data Quality Results of OTC 194, Table MARA_AUSP
MDQ_RULE_MDG_INTMaster Data Qualitiy Business Rule MDG Integration
MDQ_MND_SCPFLDSMaster Data Quality Mined Rules Scope Fields
MARA_DQ_RESMaster Data Quality Results of OTC 194, Table MARA
MDQ_FILE_BUFFERFile Buffer for Data Import via File Upload
MDQ_EVAL_SETTINGMaster Data Quality Evaluation Setting
BUT_ADR3_DQ_RESMaster Data Quality Results of OTC 147, Table ADR3
MDQ_RULE_REPOMaster Data Quality Rule Repository
MARD_DQ_RESMaster Data Quality Results of OTC 194, Table MARD

List of tables in Analysis and Remediation of Data Quality.

TableDescription
MBEW_DQ_RESMaster Data Quality Results of OTC 194, Table MBEW
MARA_AUSP_DQ_RESMaster Data Quality Results of OTC 194, Table MARA_AUSP
MDQ_RULE_MDG_INTMaster Data Qualitiy Business Rule MDG Integration
MDQ_MND_SCPFLDSMaster Data Quality Mined Rules Scope Fields
MARA_DQ_RESMaster Data Quality Results of OTC 194, Table MARA
MDQ_FILE_BUFFERFile Buffer for Data Import via File Upload
MDQ_EVAL_SETTINGMaster Data Quality Evaluation Setting
BUT_ADR3_DQ_RESMaster Data Quality Results of OTC 147, Table ADR3
MDQ_RULE_REPOMaster Data Quality Rule Repository
MARD_DQ_RESMaster Data Quality Results of OTC 194, Table MARD
MDQ_EXPRTD_RLMaster Data Quality Exported Rules
MDQ_IMPRTD_RLMaster Data Quality Imported Rules
MDQ_BUSRUL_USGMaster Data Quality Business Rule Usage
MARC_STXL_DQ_RESMaster Data Quality Results of OTC 194, Table MARC_STXL
BUT_ADR2_DQ_RESMaster Data Quality Results of OTC 147, Table ADR2
KNB5_DQ_RESMaster Data Quality Results of OTC 147, Table KNB5
KNB1_DQ_RESMaster Data Quality Results of OTC 147, Table KNB1
MDQ_RULEMININGMaster Data Quality Rule Mining Run
MDQ_BRF_RULE_MAPMaster Data Quality BRF+ Rule Mapping
MDQ_MNDRULE_RUNMaster Data Quality Mined Rule Mining Run
MDQ_IMPRTD_RL_DI_MDQUALITYRULEIMPORTTP I_MDQUALITYIMPORTEDRULETP
MDQ_RLEX_FILEMaster Data Quality Rule Export Files
MDQ_RULE_REPO_TMaster Data Quality Rule Repository Texts
LFA1_KSSK_DQ_RESMaster Data Quality Results of OTC 147, Table LFA1_KSSK
MDQ_RULEMNNG_VHMaster Data Quality Rule Mining Value Help
MAT_PGMI_DQ_RESMaster Data Quality Results of OTC 194, Table PGMI
MDQ_RLIM_FLCNT_DI_MDQUALITYRULEIMPORTTP I_MDQLTYRULEIMPRTFILECONTENTTP
MARA_DRAD_DQ_RESMaster Data Quality Results of OTC 194, Table MARA_DRAD
MDQ_RULESTAGE_TMaster Data Quality Rule Stage Text Table
MDQ_RULEMINING_DI_MDQLTYRULEMININGTP I_MDQLTYRULEMININGTP
KNA1_AUSP_DQ_RESMaster Data Quality Results of OTC 147, Table KNA1_AUSP
MDQ_RULEUSAGE_TMaster Data Qality Rule Usage Text Table
CKMLPR_DQ_RESMaster Data Quality Results of OTC 194, Table CKMLPR
MDQ_BRF_APPL_MAPMaster Data Quality BRF+ Application Mapping
MDQ_RLIM_FILEMaster Data Quality Rule Export Files
KNVA_DQ_RESMaster Data Quality Results of OTC 147, Table KNVA
MDQ_RLEX_FILE_DI_MDQUALITYRULEEXPORTTP I_MDQUALITYRULEEXPORTFILETP
MDQ_OBJECT_ERRORMaster Data Quality Business Objects with Errors
MDQ_MINEDRLSTSTMaster Data Quality Mined Rule Status Text
MDQ_MNDRULE_CMNTMaster Data Quality Mined Rule Comment
LFA1_AUSP_DQ_RESMaster Data Quality Results of OTC 147, Table LFA1_AUSP
BUT020_DQ_RESMaster Data Quality Results of OTC 147, Table BUT020
MDQ_RULE_IMPMaster Data Quality Rule Import
BUT_ADR6_DQ_RESMaster Data Quality Results of OTC 147, Table ADR6
MDQ_SCORERULERESMDQ Score Rule
LFA1_DRAD_DQ_RESMaster Data Quality Results of OTC 147, Table LFA1_DRAD
BUT000_DQ_RESMaster Data Quality Results of OTC 147, Table BUT000
LFA1_DQ_RESMaster Data Quality Results of OTC 147, Table LFA1
MDQ_RULE_DATA_TMaster Data Quality Rule Data
MDQ_RULE_EXPMaster Data Quality Rule Export
MARC_STXH_DQ_RESMaster Data Quality Results of OTC 194, Table MARC_STXH
MARA_AEOI_DQ_RESMaster Data Quality Results of OTC 194, Table MARA_AEOI
BUT_ADRC_DQ_RESMaster Data Quality Results of OTC 147, Table ADRC
MDQ_BUSRUL_USG_DI_MDQUALITYBUSINESSRULETP I_MDQLTYBUSINESSRULEUSAGETP
BUT_ADR12_DQ_RESMaster Data Quality Results of OTC 147, Table ADR12
MDQ_EVAL_RUNMaster Data Quality Evaluation Runs
WYT1T_DQ_RESMaster Data Quality Results of OTC 147, Table WYT1T
BUT0IS_DQ_RESMaster Data Quality Results of OTC 147, Table BUT0IS
MARC_DQ_RESMaster Data Quality Results of OTC 194, Table MARC
MAPR_DQ_RESMaster Data Quality Results of OTC 194, Table MAPR
MDQ_MNDRUL_LNK_DI_MDQUALITYBUSINESSRULETP I_MDQLTYMINEDRULELINKAGETP
MDQ_DIMN_CAT_DI_MDQLTYDIMENSIONCATEGORYTP I_MDQLTYDIMENSIONCATEGORYTP
KNVV_DQ_RESMaster Data Quality Results of OTC 147, Table KNVV
MDQ_STATUSStatus of Error Resolution
MDQ_RULESTAGEMaster Data Quality Rule Stage
MDQ_PROC_TMPLMaster Data Quality Process Template for Evaluation Setting
BUT0ID_DQ_RESMaster Data Quality Results of OTC 147, Table BUT0ID
CKMLHD_DQ_RESMaster Data Quality Results of OTC 194, Table CKMLHD
MDQ_FLPPATHFiori launchpad path
KNVP_DQ_RESMaster Data Quality Results of OTC 147, Table KNVP
KNA1_KSSK_DQ_RESMaster Data Quality Results of OTC 147, Table KNA1_KSSK
MDQ_RULE_DEFD_DI_MDQUALITYBUSINESSRULETP I_MDQLTYBUSINESSRULEDETAILSTP
MDQ_BRF_FUNC_MAPMaster Data Quality BRF+ Function Mapping
MDQ_STATUS_TStatus of Error Resolution
LFM2_DQ_RESMaster Data Quality Results of OTC 147, Table LFM2
MDQ_DATA_IMPORTSMaster Data Quality Data Imports
MDQ_BRF_FUNC_USGMaster Data Quality: BRF+ Function Mapping per Usage
CKMLCR_DQ_RESMaster Data Quality Results of OTC 194, Table CKMLCR
WYT3_DQ_RESMaster Data Quality Results of OTC 147, Table WYT3
MDQ_RLIM_FLCNTMaster Data Quality Rule Export File Content
MDQ_RLEX_FLCNT_DI_MDQUALITYRULEEXPORTTP I_MDQLTYRULEEXPRTFILECONTENTTP
MDQ_MNDRUL_LNKLinkage of Mined Rules to Data Quality Business Rules
MDQ_RULE_DEFDMaster Data Quality Rule Defintion Details/Descriptions
QMAT_DQ_RESMaster Data Quality Results of OTC 194, Table QMAT
MVKE_STXL_DQ_RESMaster Data Quality Results of OTC 194, Table MVKE_STXL
MDQ_MND_CONDFLDSMaster Data Quality Mined Rule Condition Fields
MEAN_DQ_RESMaster Data Quality Results of OTC 194, Table MEAN
MDQ_DIMENMDQ_DIMEN
MDQ_RMFLDSELMaster Data Quality Rule Mining Selected Field
BUT0BK_DQ_RESMaster Data Quality Results of OTC 147, Table BUT0BK
MDQ_BRF_RULE_USGMaster Data Quality BRF+ Rule Mapping per Usage
KNA1_DRAD_DQ_RESMaster Data Quality Results of OTC 147, Table KNA1_DRAD
LFM1_DQ_RESMaster Data Quality Results of OTC 147, Table LFM1
MDQ_RLMSG_ASSG_DI_MDQUALITYBUSINESSRULETP I_MDQLTYBUSRULEMSGASSIGNMENTTP
MVKE_DQ_RESMaster Data Quality Results of OTC 194, Table MVKE
MDMA_DQ_RESMaster Data Quality Results of OTC 194, Table MDMA
MDQ_DIMN_CATMDQ_DIMN_CAT
MDQ_RLEX_FLCNTMaster Data Quality Rule Export File Content
MDQ_DIM_R_ASSG_DI_MDQLTYDIMENSIONCATEGORYTP I_MDQLTYDIMNRULEASSGMTTP
MDQ_RULEUSAGEMaster Data Quality Rule Usage
BUT100_DQ_RESMaster Data Quality Results of OTC 147, Table BUT100
KNA1_ASSGMNT_DQMaster Data Quality Results of OTC 147, Table KNA1_ASSGMNT
MDQ_RULE_DATAMaster Data Quality Rule Data
LFA1_ASSGMNT_DQMaster Data Quality Results of OTC 147, Table LFA1_ASSGMNT
BUT_ADRP_DQ_RESMaster Data Quality Results of OTC 147, Table ADRP
MDQ_RULE_DEFMaster Data Quality Rule Definition
KNA1_DQ_RESMaster Data Quality Results of OTC 147, Table KNA1
MDQ_RMTBLSELMaster Data Quality Rule Mining Selected Table
MLGN_DQ_RESMaster Data Quality Results of OTC 194, Table MLGN
MDQ_IMPORTTYPEMaster Data Quality Import Type
MKAL_DQ_RESMaster Data Quality Results of OTC 194, Table MKAL
LFBW_DQ_RESMaster Data Quality Results of OTC 147, Table LFBW
MARA_KSSK_DQ_RESMaster Data Quality Results of OTC 194, Table MARA_KSSK
MDQ_RULE_DEF_DI_MDQUALITYBUSINESSRULETP I_MDQUALITYBUSINESSRULETP
MDQ_MINEDRLSTSMaster Data Quality Mined Rule Status
MAKT_DQ_RESMaster Data Quality Results of OTC 194, Table MAKT
MDQ_BR_MDG_INT_DI_MDQUALITYBUSINESSRULETP I_MDQLTYBUSRULEMDGOVINTEGTP
MDQ_EVAL_RUN_TEvaluation Run Texts
MARM_DQ_RESMaster Data Quality Results of OTC 194, Table MARM
MDQ_EXPRTD_RL_DI_MDQUALITYRULEEXPORTTP I_MDQUALITYEXPORTEDRULETP
MDQ_MINEDRULESMaster Data Quality Mined Rules
MDQ_RULE_EXP_DI_MDQUALITYRULEEXPORTTP I_MDQUALITYRULEEXPORTTP
MVKE_STXH_DQ_RESMaster Data Quality Results of OTC 194, Table MVKE_STXH
MDQ_RULEPRPS_TMaster Data Quality Rule Purpose Text Table
MDQ_EVAL_SETTG_TMaster Data Quality: Evaluation Setting Texts
MARA_STXL_DQ_RESMaster Data Quality Results of OTC 194, Table MARA_STXL
MDQ_RLIM_FILE_DI_MDQUALITYRULEIMPORTTP I_MDQUALITYRULEIMPORTFILETP
LFB1_DQ_RESMaster Data Quality Results of OTC 147, Table LFB1
KNVI_DQ_RESMaster Data Quality Results of OTC 147, Table KNVI
BUT021_FS_DQ_RESMaster Data Quality Results of OTC 147, Table BUT021_FS
MDQ_RMFLDSEL_DI_MDQLTYRULEMININGTP I_MDQLTYRULEMININGFLDSELFLDTP
KNBW_DQ_RESMaster Data Quality Results of OTC 147, Table KNBW
MDQ_RMTBLSEL_DI_MDQLTYRULEMININGTP I_MDQLTYRULEMININGTBLSELTBLTP
MDQ_IMPORTTYPE_TImport Type Texts
MAT_PGZU_DQ_RESMaster Data Quality Results of OTC 194, Table PGZU
MDQ_DIM_R_ASSGMDQ_DIM_R_ASSG
MDQ_RULEPRPSMaster Data Quality Rule Purpose
MDQ_RES_RECORDSMDQ Rule Management Total Number of Records per Table
WYT1_DQ_RESMaster Data Quality Results of OTC 147, Table WYT1
LFB5_DQ_RESMaster Data Quality Results of OTC 147, Table LFB5
MDQ_RMDTSEL_DI_MDQLTYRULEMININGTP I_MDQLTYRULEMININGDATASELFLDTP
MLGT_DQ_RESMaster Data Quality Results of OTC 194, Table MLGT
MDQ_RMDTSELMaster Data Quality Rule Mining Selection Condition
MDQ_RULE_IMP_DI_MDQUALITYRULEIMPORTTP I_MDQUALITYRULEIMPORTTP
MARA_STXH_DQ_RESMaster Data Quality Results of OTC 194, Table MARA_STXH
MDQ_RLMSG_ASSGMaster Data Quality Rule Message Assignment
MDQ_TMPL_DQ_RESMaster Data Quality Results of OTC &OTC, Table &TABLE
MDQ_DATAPROV_TMaster Data Quality Data Provider Texts
MDQ_MDC_EXECData Quality Rule Execution in Master Data Process Step
MDQ_DIMEN_DI_MDQLTYDIMENSIONCATEGORYTP I_MDQLTYDIMENSIONTP
MLAN_DQ_RESMaster Data Quality Results of OTC 194, Table MLAN
MDQ_DATAPROVIDERMaster Data Quality Data Provider
MDQ_EVALDETAILMaster Data Quality Evaluation Details
DFKKBPTAXNUM_DQMaster Data Quality Results of OTC 147, Table DFKKBPTAXNUM