HSMT_MD

EHS: Hazardous Substance Basic Data | #masterdata | Component: Environment, Health and Safety: Master Data
Column Name Description
MANDT FK Client
RECN Data Record ID (GUID)
ACTN Sequential Number of the Change State
Column Name Description
Column Name Description
Column Name Description
VALFR Valid-From Date
VALTO Valid-To Date
CRDAT Created On
UPDDAT Last Changed On
Column Name Description
DELFLG Deletion Indicator Show values
PARKFLG Data Record Is Inactive Show values
WPC Water Pollution Class Is Legal Requirement Show values
Column Name Description Domain name
CRNAM Created By USNAM
UPDNAM Last Changed By USNAM
OWNID Data Provider AD_ADDRNUM
RECNROOT Data Record ID (GUID) SYSUUID
MATNR Material or Product (Internal Key) BASD_MATID
STWA Hazardous Substance Warning CHAR30
STMA State of Matter CHAR30
VBF Combustible Liquids (VbF) Hazard Class CHAR30
NAME Hazardous Substance Key CHAR30
DESCR Comment on Hazardous Substance CHAR30
Master Data Relations Join Conditions
Change Number
  • Change Number
  • Client
  • HSMT_MD.AENNR == AENR.AENNR
  • HSMT_MD.MANDT == AENR.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • HSMT_MD.COUNTRY == T005.LAND1
  • HSMT_MD.MANDT == T005.MANDT
Client HSMT_MD.MANDT == T000.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • HSMT_MD.MANDT == T005S.MANDT
  • HSMT_MD.COUNTRY == T005S.LAND1
  • HSMT_MD.REGION == T005S.BLAND
Source of Data
  • HSMT_MD.MANDT == TCG56.MANDT
  • HSMT_MD.SRSID == TCG56.SRSID