HSMT_MD - EHS: Hazardous Substance Basic Data
EHS: Hazardous Substance Basic Data information is stored in SAP table HSMT_MD.
It is part of development package CBEHS_HSM in software component CA-GTF-EHS. This development package consists of objects that can be grouped under "Hazardous Substance Master Data".
It is part of development package CBEHS_HSM in software component CA-GTF-EHS. This development package consists of objects that can be grouped under "Hazardous Substance Master Data".
Fields for table HSMT_MD
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| .INCLUDE | X | BASS_KEYGUID | 0 | |||
| MANDT | Client | X | MANDT | CLNT | 3 | T000 |
| RECN | Data Record ID (GUID) | X | BASE_RECNGUID | RAW | 16 | |
| ACTN | Sequential Number of the Change State | X | ESEACTN | NUMC | 20 | |
| .INCLUDE | BASS_ADMGUID | 0 | ||||
| VALFR | Valid-From Date | ESEVALFR | DATS | 8 | ||
| VALTO | Valid-To Date | ESEVALTO | DATS | 8 | ||
| AENNR | Change Number | ESEAENNR | CHAR | 12 | AENR | |
| 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 | CHAR | 10 | TCG56 | |
| OWNID | Data Provider | ESEVENDRID | CHAR | 10 | * | |
| RECNROOT | Data Record ID (GUID) | BASE_RECNGUID | RAW | 16 | ||
| .INCLUDE | HSMS_KEY | 0 | ||||
| MATNR | Material or Product (Internal Key) | BASE_MATID | CHAR | 40 | ||
| COUNTRY | Country/Region Key | LAND1 | CHAR | 3 | T005 | |
| REGION | Region (State, Province, County) | REGIO | CHAR | 3 | T005S | |
| .INCLUDE | HSMS_MDDATA | 0 | ||||
| .INCLUDE | HSMS_STOKEYS | 0 | ||||
| STOKEY1 | Hazard Rating 1 | HSME_STOKEY1 | CHAR | 5 | HSMV_STOKEY | |
| STOKEY2 | Hazard Rating 2 | HSME_STOKEY2 | CHAR | 5 | HSMV_STOKEY | |
| WPC | Water Pollution Class Is Legal Requirement | HSME_WPC | CHAR | 1 | ||
| STWA | Hazardous Substance Warning | HSME_STWA | CHAR | 30 | ||
| STMA | State of Matter | HSME_STMA | CHAR | 30 | ||
| VBF | Combustible Liquids (VbF) Hazard Class | HSME_VBF | CHAR | 30 | ||
| NAME | Hazardous Substance Key | HSME_NAME | CHAR | 30 | ||
| DESCR | Comment on Hazardous Substance | HSME_DESC | CHAR | 30 |