SAP ABAP Table HSMS_MDIO (EHS: I/O Hazardous Substance Basic Data)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS-HSM (Application Component) Hazardous Substance Management
     ⤷ CBHS (Package) Hazardous Substance Management

Basic Data

Table Category	INTTAB	Structure
Structure	HSMS_MDIO	Table Relationship Diagram
Short Description	EHS: I/O Hazardous Substance Basic Data

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	EHS: Standard fields for IOTABs (step loop library)
2	MARKFLG	☐	ESEMARKFLG	ESDFLAG	CHAR	1	0	Row Is Selected
3	SELEFLG	☐	ESESELEFLG	ESDFLAG	CHAR	1	0	Step Loop Line Selected
4	LINENO	☐	ESECOUNTER	NUMC10	NUMC	10	0	General Auxiliary Counter
5	LINEMOD	☐	ESELINEMOD	CHAR1	CHAR	1	0	Processing status or mode of a record/step loop line
6	CHCOFLG	☐	ESECHCOFLG	ESDFLAG	CHAR	1	0	Indicator: Change number collision
7	LOCKMOD	☐	ESELOCKMOD	CHAR1	CHAR	1	0	Lock Mode (Shared, Exclusive)
8	INTRFLG	☐	ESEINTRFLG	ESDFLAG	CHAR	1	0	Flag for Internal Use
9	.INCLUDE	☐				0	0	EHS: Hazardous Substance Basic Data (MARA-MATNR)
10	.INCLUDE	☐				0	0	EHS: Structure for Standard Key Fields in Master Data
11	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
12	RECN	☐	BASE_RECNGUID	SYSUUID	RAW	16	0	Data Record ID (GUID)
13	ACTN	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
14	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
15	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
16	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
17	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
18	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
19	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
20	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
21	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
22	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
23	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
24	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
25	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
26	RECNROOT	☐	BASE_RECNGUID	SYSUUID	RAW	16	0	Data Record ID (GUID)
27	.INCLUDE	☐				0	0	EHS: Logical Key for Hazardous Substance
28	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
29	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
30	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
31	.INCLUDE	☐				0	0	EHS: Data Structure for Hazardous Substance Basic Data
32	.INCLUDE	☐				0	0	EHS: Data Structure for Hazard Ratings 1 ... n
33	STOKEY1	☐	HSME_STOKEY1	HSMD_STOKEY	CHAR	5	0	Hazard Rating 1	HSMC_013
34	STOKEY2	☐	HSME_STOKEY2	HSMD_STOKEY	CHAR	5	0	Hazard Rating 2	HSMC_013
35	WPC	☐	HSME_WPC	ESDBOOLE	CHAR	1	0	Water Pollution Class Is Legal Requirement
36	STWA	☐	HSME_STWA	CHAR30	CHAR	30	0	Hazardous Substance Warning
37	STMA	☐	HSME_STMA	CHAR30	CHAR	30	0	State of Matter
38	VBF	☐	HSME_VBF	CHAR30	CHAR	30	0	Combustible Liquids (VbF) Hazard Class
39	NAME	☐	HSME_NAME	CHAR30	CHAR	30	0	Hazardous Substance Key
40	DESCR	☐	HSME_DESC	CHAR30	CHAR	30	0	Comment on Hazardous Substance
41	STOCAT1	☐	HSME_STOCAT	HSMD_STOCAT	CHAR	5	0	Storage Hazard Type	*
42	STOCAT2	☐	HSME_STOCAT	HSMD_STOCAT	CHAR	5	0	Storage Hazard Type	*
43	STOCAT1TXT	☐	HSME_STOCATTXT	ACCHAR40	CHAR	40	0	Description for Storage Hazard Type
44	STOCAT2TXT	☐	HSME_STOCATTXT	ACCHAR40	CHAR	40	0	Description for Storage Hazard Type
45	STOKEY1TXT	☐	HSME_STOKEY1TXT	TEXT60	CHAR	60	0	Description of Hazard Rating 1
46	STOKEY2TXT	☐	HSME_STOKEY2TXT	TEXT60	CHAR	60	0	Description of Hazard Rating 2
47	STWATXT	☐	HSME_STWATXT	TEXT132	CHAR	132	0	Description for Hazardous Substance Warning
48	STMATXT	☐	HSME_STMATXT	TEXT132	CHAR	132	0	Description of Aggregate State
49	VBFTXT	☐	HSME_VBFTXT	TEXT132	CHAR	132	0	Description of Combustible Liquids (VbF) Hazard Class
50	NAMETXT	☐	HSME_NAMETXT	TEXT132	CHAR	132	0	Description of Hazardous Substance
51	DESCRTXT	☐	HSME_DESCTXT	TEXT132	CHAR	132	0	Comment on Hazardous Substance Description
52	MATERIALTXT	☐	MAKTX	TEXT40	CHAR	40	0	Material description
53	COUNTRYTXT	☐	LANDX	TEXT15	CHAR	15	0	Country Name
54	REGIONTXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
55	VALDAT	☐	ESEDIAGVD	DATUM	DATS	8	0	Key Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HSMS_MDIO	AENNR	AENR	AENNR	REF	1	CN
2	HSMS_MDIO	COUNTRY	T005	LAND1	KEY	1	CN
3	HSMS_MDIO	MANDT	T000	MANDT		1	CN
4	HSMS_MDIO	MATNR	MARA	MATNR	KEY	1	CN
5	HSMS_MDIO	REGION	T005S	BLAND	KEY	1	CN
6	HSMS_MDIO	SRSID	TCG56	SRSID	REF	1	CN
7	HSMS_MDIO	STOKEY1	HSMC_013	STOKEY	REF	1	CN
8	HSMS_MDIO	STOKEY2	HSMC_013	STOKEY	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	600