The CCGLT_MTLS table in SAP ERP or S/4HANA stores Label Definition for a Material data. There are total 17 fields in CCGLT_MTLS table. The Label Definition for a Material 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 CCGLT_MTLS table. It is in EHS: Global Label Management (CBGLM) ABAP package and is part of the Product Safety (EHS-SAF) module.
SAP CCGLT_MTLS Table Fields
Following is the list of fields that are available in SAP CCGLT_MTLS table. The primary key fields of Label Definition for a Material table in SAP are MANDT (Client), RECN (Sequential Number of Data Record), ACTN (Sequential Number of the Change State), MATNR (Material Number), RECNROOT (Sequential Number of Data Record).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| RECN | Sequential Number of Data Record | ESERECN | NUMC (20) | |
| ACTN | Sequential Number of the Change State | ESEACTN | NUMC (20) | |
| MATNR | Material Number | MATNR | MARA | CHAR (40) |
| RECNROOT | Sequential Number of Data Record | ESERECN | NUMC (20) | |
| DELFLG | Deletion Indicator | ESEDELFLG | CHAR (1) | |
| CRDAT | Created On | ESECRDAT | DATS (8) | |
| CRNAM | Created By | ESECRNAM | CHAR (12) | |
| UPDDAT | Last Changed On | ESEUPDDAT | DATS (8) | |
| UPDNAM | Last Changed By | ESEUPDNAM | CHAR (12) | |
| PUOM | Unit of Measurement | MSEHI | * | UNIT (3) |
| LTYP | Label Category | CBGLE_LTYP | CCGLC_LABTY | CHAR (10) |
| LSIZE | Name for Size of Label | CBGLE_LSIZE | CCGLC_LSIZE | CHAR (12) |
| LDEPID | Report Generation Variant | ESELDEPID | CHAR (10) | |
| NUM_LBLS | Number of Printed Copies | CBGLE_NUM | DEC (6) | |
| FLG_LOCK | Data Record Is Locked for Label Determination | CBGLE_FLGLOCKED | CHAR (1) | |
| FLG_VAL | Validity Areas Were Entered | CBGLE_FLGVALAREA | CHAR (1) |
