SAP table HSMS_MD (Hazardous Substance Basic Data (MARA-MATNR))

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
RECN Data Record ID (GUID) RAW 16 0 BASE_RECNGUID
ACTN Sequential Number of the Change State NUMC 20 0 ESEACTN
VALFR Valid-From Date DATS 8 0 ESEVALFR
VALTO Valid-To Date DATS 8 0 ESEVALTO
AENNR Change Number CHAR 12 0 AENR ESEAENNR
DELFLG Deletion Indicator CHAR 1 0 ESEDELFLG
PARKFLG Data Record Is Inactive CHAR 1 0 ESEPARKFLG
CRDAT Created On DATS 8 0 ESECRDAT
CRNAM Created By CHAR 12 0 ESECRNAM
UPDDAT Last Changed On DATS 8 0 ESEUPDDAT
UPDNAM Last Changed By CHAR 12 0 ESEUPDNAM
SRSID Source of Data CHAR 10 0 TCG56 ESESRSID
OWNID Data Provider CHAR 10 0 * ESEVENDRID
RECNROOT Data Record ID (GUID) RAW 16 0 BASE_RECNGUID
MATNR Material Number CHAR 40 0 MARA MATNR
COUNTRY Country/Region Key CHAR 3 0 T005 LAND1
REGION Region (State, Province, County) CHAR 3 0 T005S REGIO
STOKEY1 Hazard Rating 1 CHAR 5 0 HSMC_013 HSME_STOKEY1
STOKEY2 Hazard Rating 2 CHAR 5 0 HSMC_013 HSME_STOKEY2
WPC Water Pollution Class Is Legal Requirement CHAR 1 0 HSME_WPC
STWA Hazardous Substance Warning CHAR 30 0 HSME_STWA
STMA State of Matter CHAR 30 0 HSME_STMA
VBF Combustible Liquids (VbF) Hazard Class CHAR 30 0 HSME_VBF
NAME Hazardous Substance Key CHAR 30 0 HSME_NAME
DESCR Comment on Hazardous Substance CHAR 30 0 HSME_DESC

HSMS_MD foreign key relationships

Table Field Check Table Check Field
0 HSMS_MD AENNR AENR Change Master AENNR
1 HSMS_MD COUNTRY T005 Countries MANDT
1 HSMS_MD COUNTRY T005 Countries LAND1
0 HSMS_MD MANDT T000 Clients MANDT
1 HSMS_MD MATNR MARA General Material Data MANDT
1 HSMS_MD MATNR MARA General Material Data MATNR
0 HSMS_MD REGION T005S Taxes: Region (Province) Key LAND1
1 HSMS_MD SRSID TCG56 EHS: Data Origin MANDT
1 HSMS_MD SRSID TCG56 EHS: Data Origin SRSID
0 HSMS_MD STOKEY1 HSMC_013 EHS: Hazard Rating MANDT
0 HSMS_MD STOKEY1 HSMC_013 EHS: Hazard Rating STOCAT
1 HSMS_MD STOKEY2 HSMC_013 EHS: Hazard Rating MANDT
1 HSMS_MD STOKEY2 HSMC_013 EHS: Hazard Rating STOCAT