SAP CCGLT_LSHD Table – Label Stock Header Table

The CCGLT_LSHD table in SAP ERP or S/4HANA stores Label Stock Header Table data. There are total 30 fields in CCGLT_LSHD table. The Label Stock Header Table 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_LSHD table. It is in EHS: Global Label Management (CBGLM) ABAP package and is part of the Product Safety (EHS-SAF) module.

SAP CCGLT_LSHD Table Fields

Following is the list of fields that are available in SAP CCGLT_LSHD table. The primary key fields of Label Stock Header Table table in SAP are MANDT (Client), RECN (Sequential Number of Data Record), ACTN (Sequential Number of the Change State).

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)
VALFR Valid-From Date ESEVALFR DATS (8)
VALTO Valid-To Date ESEVALTO DATS (8)
AENNR Change Number ESEAENNR AENR CHAR (12)
DELFLG Deletion Indicator ESEDELFLG CHAR (1)
PARKFLG Data Record Is Inactive ESEPARKFLG 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)
SRSID Source of Data ESESRSID TCG56 CHAR (10)
OWNID Data Provider ESEVENDRID * CHAR (10)
RECNROOT Sequential Number of Data Record ESERECN NUMC (20)
LSID Label Stock CBGLE_LSID CHAR (12)
LSIZE Name for Size of Label CBGLE_LSIZE CCGLC_LSIZE CHAR (12)
MAXUSY Maximum Number of Hazard Pictograms CBGLE_MAXUSY NUMC (3)
MAXNBX Number of Labels per Row CBGLE_MAXNBX NUMC (10)
MAXNBY Number of Labels per Column CBGLE_MAXNBY NUMC (10)
DISTLX Horizontal Distance of Labels CBGLE_DISTLX QUAN (10)
DISTLY Vertical Distance of Labels CBGLE_DISTLY QUAN (10)
DISTEDGX Left Margin CBGLE_DISTEDGX QUAN (10)
DISTEDGY Upper Margin CBGLE_DISTEDGY QUAN (10)
UOM Unit of Length CBGLE_UOM T006 UNIT (3)
LSLANDSCAPE Landscape Format CBGLE_LSLANDSCAPE CHAR (1)
MATNR Material Number of Label Stock CBGLE_MATNR MARA CHAR (40)
LSSIZE Name for Size of Label Stock CBGLE_LSSIZE CCGLC_LSSIZE CHAR (12)
FLG_GHS_LABEL GHS Label CBGLE_GHS_FLG_LABEL CHAR (1)
MINUSY Minimum Number of Danger Pictograms CBGLE_MINUSY NUMC (3)