The CNVINDEX table in SAP ERP or S/4HANA stores Table for index information data. There are total 12 fields in CNVINDEX table. The Table for index information 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 CNVINDEX table. It is in Conversion: Basis functions (CNV_BASIS) ABAP package and is part of the Landscape Transformation (CA-LT) module.
SAP CNVINDEX Table Fields
Following is the list of fields that are available in SAP CNVINDEX table. The primary key fields of the table are MANDT (Client), PACKID (Conversion: Conversion package number), TABNAME (Table Name), INDEXNAME (Unique Index ID in a Table).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| PACKID | Conversion: Conversion package number | CNV_PACK | CHAR (5) | |
| TABNAME | Table Name | TABNAME | CHAR (30) | |
| INDEXNAME | Unique Index ID in a Table | INDEXID | CHAR (3) | |
| DBINDEX | Database index | DBINDEX_D | CHAR (40) | |
| INDEXSIZE | Size of an index in KByte | CNV_INDEX_SIZE | NUMC (10) | |
| TABSPACE | Tablespace Name for ORACLE | ORATSPNAME | CHAR (30) | |
| INITEXT | Size of an initial ORACLE extent in KB | ORAINIT | NUMC (10) | |
| NEXTEXT | Size of an ORACLE next extent in KB | ORANEXT | NUMC (10) | |
| MINEXT | Minimum number of ORACLE extents | ORAMINEXT | NUMC (10) | |
| MAXEXT | Maximum number of ORACLE extents | ORAMAXEXT | NUMC (10) | |
| STATUS | Index Status | STATUS_IND | CHAR (11) |
