The CNVPERFDATA table in SAP ERP or S/4HANA stores Table for database performance data. There are total 50 fields in CNVPERFDATA table. The Table for database performance 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 CNVPERFDATA table. It is in Performance database (CNV_PERFDB) ABAP package and is part of the Landscape Transformation (CA-LT) module.
SAP CNVPERFDATA Table Fields
Following is the list of fields that are available in SAP CNVPERFDATA table. The primary key fields of the table are MANDT (Client), PACKID (Conversion: Conversion package number), CUSTNUMMER (Customer Number), INSTNR (Character Field with Length 10), SYSID (Name of SAP System), CLIENT (Client), ANALYSETYP (Character Field with Length 10), ANALYSEDATE (System Date).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| PACKID | Conversion: Conversion package number | CNV_PACK | CHAR (5) | |
| CUSTNUMMER | Customer Number | KUNNR | CHAR (10) | |
| INSTNR | Character Field with Length 10 | CHAR10 | CHAR (10) | |
| SYSID | Name of SAP System | SYSYSID | CHAR (8) | |
| CLIENT | Client | MANDT | CLNT (3) | |
| ANALYSETYP | Character Field with Length 10 | CHAR10 | CHAR (10) | |
| ANALYSEDATE | System Date | SYDATUM | DATS (8) | |
| CUSTNAME | Name 1 | NAME1_GP | CHAR (35) | |
| SAPRL | Release of SAP System | SYSAPRL | CHAR (4) | |
| DBSYS | Central Database System | SYDBSYS | CHAR (10) | |
| OPSYS | Operating System of Application Server | SYOPSYS | CHAR (10) | |
| SYSTEMTYP | Character Field with Length 10 | CHAR10 | CHAR (10) | |
| PRODCLIENT | Number of productive clients in system | CNV_CLNR | INT2 (5) | |
| DBSIZE | Database size in Kb | CNV_DBSIZE | NUMC (15) | |
| MEMSIZE | Main memory size in Kb | CNV_MSIZE | INT4 (10) | |
| CPUNR | 2 Byte Signed Integer | INT2 | INT2 (5) | |
| ARCHIVEMODE | Character Field of Length 12 | CHAR12 | CHAR (12) | |
| ESTRECORDS | Numerical field, 15 characters long | NUMC15 | NUMC (15) | |
| ESTIMTIME | Time in minutes | CNV_TIME | INT4 (10) | |
| JOBNR | 2 Byte Signed Integer | INT2 | INT2 (5) | |
| UPDATETIME | Update in ms/record | CNV_UPD | DEC (6) | |
| THROUGHPUT | 4 Byte Signed Integer | INT4 | INT4 (10) | |
| IDLE | 2 Byte Signed Integer | INT2 | INT2 (5) | |
| PAGING | 4 Byte Signed Integer | INT4 | INT4 (10) | |
| CHKPOINT | 2 Byte Signed Integer | INT2 | INT2 (5) | |
| BATCH | 2 Byte Signed Integer | INT2 | INT2 (5) | |
| WPTOT | 2 Byte Signed Integer | INT2 | INT2 (5) | |
| UPDPROC | 2 Byte Signed Integer | INT2 | INT2 (5) | |
| NETTORUNTIME | Time in minutes | CNV_TIME | INT4 (10) | |
| RECSELECT | Numerical field, 15 characters long | NUMC15 | NUMC (15) | |
| RECRELEV | Numerical field, 15 characters long | NUMC15 | NUMC (15) | |
| RECUPD | Numerical field, 15 characters long | NUMC15 | NUMC (15) | |
| PROC_MAX | Two digit number | NUMC2 | NUMC (2) | |
| AU | 2 Byte Signed Integer | INT2 | INT2 (5) | |
| AU_CLU | 2 Byte Signed Integer | INT2 | INT2 (5) | |
| AD | 2 Byte Signed Integer | INT2 | INT2 (5) | |
| AD_CLU | 2 Byte Signed Integer | INT2 | INT2 (5) | |
| AI | 2 Byte Signed Integer | INT2 | INT2 (5) | |
| AI_CLU | 2 Byte Signed Integer | INT2 | INT2 (5) | |
| DAI | 2 Byte Signed Integer | INT2 | INT2 (5) | |
| DAI_CLU | 2 Byte Signed Integer | INT2 | INT2 (5) | |
| DROP_AI | 2 Byte Signed Integer | INT2 | INT2 (5) | |
| EU | 2 Byte Signed Integer | INT2 | INT2 (5) | |
| SUMUP | 2 Byte Signed Integer | INT2 | INT2 (5) | |
| PRIO | 2 Byte Signed Integer | INT2 | INT2 (5) | |
| DUM | 2 Byte Signed Integer | INT2 | INT2 (5) | |
| UNAME | User Name | SYUNAME | CHAR (12) | |
| DESCRIPTION | Text Field | TEXT50 | CHAR (50) | |
| REMARKS | Text Field | TEXT50 | CHAR (50) |
