The CNVCMIS_A_1_TYPE table in SAP ERP or S/4HANA stores Type Pool Information Table(CMIS) data. There are total 37 fields in CNVCMIS_A_1_TYPE table. The Type Pool Information Table(CMIS) 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 CNVCMIS_A_1_TYPE table. It is in CMIS Repository Comparison (CNV_CMIS_A_10) ABAP package and is part of the Landscape Transformation (CA-LT) module.
SAP CNVCMIS_A_1_TYPE Table Fields
Following is the list of fields that are available in SAP CNVCMIS_A_1_TYPE table. The primary key fields of the table are MANDT (Client), PACKID (Package ID), VERSN (Version of an Analysis), TYPEGROUP (Type Group), SYSID (Name of SAP System).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| PACKID | Package ID | CNVCMIS_A_10_PACKID | CHAR (5) | |
| VERSN | Version of an Analysis | CNVCMIS_A_10_VERSN | NUMC (3) | |
| TYPEGROUP | Type Group | TYPEGROUP | CHAR (5) | |
| SYSID | Name of SAP System | SYSYSID | CHAR (8) | |
| STATE | ABAP: Program Status (Active, Saved, Transported…) | R3STATE | CHAR (1) | |
| SQLX | Source code protection | SQLX | CHAR (1) | |
| EDTX | Editor lock flag | EDTX | CHAR (1) | |
| VARCL | Case-Sensitive | VARCL | CHAR (1) | |
| DBAPL | Application database | DBAPL | CHAR (1) | |
| DBNA | Logical database | DBNA | CHAR (2) | |
| CLAS | Program class | CLAS | * | CHAR (4) |
| TYPE | Selection screen version | RDIR_TYPE | CHAR (3) | |
| OCCURS | Size of OCCURS parameter in reports | CNVCMIS_A_OCCURS | NUMC (4) | |
| SUBC | Program type | SUBC | CHAR (1) | |
| APPL | Application | RDIR_APPL | * | CHAR (1) |
| SECU | Authorization Group | SECU | CHAR (8) | |
| CNAM | Author | CNAM | CHAR (12) | |
| CDAT | Created On | RDIR_CDATE | DATS (8) | |
| UNAM | Last changed by | UNAM | CHAR (12) | |
| UDAT | Changed On | RDIR_UDATE | DATS (8) | |
| VERN | Version number | VERN | CHAR (6) | |
| LEVL | Level | RDIR_LEVL | CHAR (4) | |
| RSTAT | Status | RDIR_RSTAT | CHAR (1) | |
| RMAND | Client | RMAND | CHAR (3) | |
| RLOAD | Master Language | RLOAD | LANG (1) | |
| FIXPT | Fixed point arithmetic | FIXPT | CHAR (1) | |
| SSET | Start Using Variant Only | SSET | CHAR (1) | |
| SDATE | Standard selection screen generation: Date | RDIR_SDATE | DATS (8) | |
| STIME | Standard selection screen generation: Time | RDIR_STIME | CHAR (6) | |
| IDATE | Selection screen generation: Date | RDIR_IDATE | DATS (8) | |
| ITIME | Selection screen generation: Time | RDIR_ITIME | CHAR (6) | |
| LDBNAME | LDB name | LDBNAM | CHAR (20) | |
| UCCHECK | ABAP Version | UCCHECK | CHAR (1) | |
| DDTEXT | Explanatory Short Text | DDTEXT | CHAR (60) | |
| DDLANGUAGE | Language Key | SPRAS | * | LANG (1) |
| SEVERITY | Severity | CNV_CMIS_A_10_SEVERITY | * | CHAR (4) |
