CCGLT_MTLS SAP table for – EHS: Label Definition for a Material

Here we would like to draw your attention to CCGLT_MTLS table in SAP. As we know it is being mainly used with the SAP EHS-SAF (Product Safety in EHS) component which is coming under EHS module (Environment, Health and Safety). CCGLT_MTLS is a SAP standard transp table used for storing EHS: Label Definition for a Material related data in SAP. It comes under the package CBGLM.

SAP CCGLT_MTLS table

Table CCGLT_MTLS technical data

TableCCGLT_MTLS
Data storingEHS: Label Definition for a Material
ModuleEHS
Sub ModuleEHS-SAF
SAP PackageCBGLM
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP CCGLT_MTLS Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in CCGLT_MTLS table.

  • .INCLUDE : EHS: Structure for key info of master data
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RECN : Sequential Number of Data Record
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
  • ACTN : Sequential Number of the Change State
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
  • MATNR : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • RECNROOT : Sequential Number of Data Record
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
  • .INCLUDE : EHS: Label Data – Header Data
  • DELFLG : Deletion Indicator
    Its data type is CHAR (Character String) with field length 1
  • CRDAT : Created On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CRNAM : Created By
    Its data type is CHAR (Character String) with field length 12
  • UPDDAT : Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UPDNAM : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : EHS: Logical Key for Labeling Specification
  • PUOM : Unit of Measurement
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • LTYP : Label Category
    Its data type is CHAR (Character String) with field length 10
  • LSIZE : Name for Size of Label
    Its data type is CHAR (Character String) with field length 12
  • LDEPID : Report Generation Variant
    Its data type is CHAR (Character String) with field length 10
  • NUM_LBLS : Number of Printed Copies
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • FLG_LOCK : Data Record Is Locked for Label Determination
    Its data type is CHAR (Character String) with field length 1
  • FLG_VAL : Validity Areas Were Entered
    Its data type is CHAR (Character String) with field length 1