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