The CRMM_DQA_KPI table in SAP ERP or S/4HANA stores Data Quality Administration Task KPI data. There are total 7 fields in CRMM_DQA_KPI table. The Data Quality Administration Task KPI 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 CRMM_DQA_KPI table. It is in Data Quality Administration Framework, run time (CRM_DQAF_RUN) ABAP package and is part of the Data Quality Administration (CRM-MD-DQA) module.
SAP CRMM_DQA_KPI Table Fields
Following is the list of fields that are available in SAP CRMM_DQA_KPI table. The primary key fields of the table are CLIENT (Client), STEP_GUID (Data Quality Administration Step Instance GUID), KPI_ID (Data Quality Key Performance Indicator), JOBNAME (Background job name), JOBCOUNT (Job ID).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| STEP_GUID | Data Quality Administration Step Instance GUID | CRMT_DQA_STEP_GUID | RAW (16) | |
| KPI_ID | Data Quality Key Performance Indicator | CRMT_DQA_KPI | * | CHAR (10) |
| JOBNAME | Background job name | BTCJOB | CHAR (32) | |
| JOBCOUNT | Job ID | BTCJOBCNT | CHAR (8) | |
| VALUE | KPI value | CRMT_DQA_KPI_VALUE | INT4 (10) | |
| CHANGED_ON | Time stamp for the last change of the KPI | CRMT_DQA_CHANGE_TIME | DEC (15) |
