SAP ABAP Table HSMT_DN (EHS: Hazardous Substance Addit. Data 2 (Numeric Type))

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ CA-GTF-EHS (Application Component) Environment, Health and Safety: Master Data
     ⤷ CBEHS_HSM (Package) Hazardous Substance Master Data

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	HSMT_DN	Table Relationship Diagram
Short Description	EHS: Hazardous Substance Addit. Data 2 (Numeric Type)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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: Structure for Standard Key Fields in Master Data
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
3	RECN	☑	BASE_RECNGUID	SYSUUID	RAW	16	0	Data Record ID (GUID)
4	ACTN	☑	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
5	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
6	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
7	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
8	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
9	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
10	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
11	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
12	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
13	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
14	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
15	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
16	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
17	RECNROOT	☐	BASE_RECNGUID	SYSUUID	RAW	16	0	Data Record ID (GUID)
18	.INCLUDE	☐				0	0	EHS: Data Structure for Haz. Subs. Addit. Data 2 (Num. Type)
19	NUMTYPE	☐	HSME_NUMTYPE	HSMD_NUMTYPE	CHAR	6	0	Numeric Value Type	HSMC_019
20	AVGVAL	☐	HSME_AVGVAL	HSMD_NUMVAL	FLTP	16	16	Target Value
21	AVGVALFLG	☐	HSME_FLGVAL	ESDBOOLE	CHAR	1	0	Value Exists
22	AVGDEC	☐	HSME_NUMDEC	INT4	INT4	10	0	Number of Decimal Places
23	LOWOP	☐	HSME_OPLOW	HSMD_OPLOW	CHAR	5	0	Operator for Lower Limit of Interval
24	LOWVAL	☐	HSME_LOWVAL	HSMD_NUMVAL	FLTP	16	16	Lower Limit of Interval
25	LOWVALFLG	☐	HSME_FLGVAL	ESDBOOLE	CHAR	1	0	Value Exists
26	LOWDEC	☐	HSME_NUMDEC	INT4	INT4	10	0	Number of Decimal Places
27	UPPOP	☐	HSME_OPUPP	HSMD_OPUPP	CHAR	5	0	Operator for Upper Limit of Interval
28	UPPVAL	☐	HSME_UPPVAL	HSMD_NUMVAL	FLTP	16	16	Upper Limit of Interval
29	UPPVALFLG	☐	HSME_FLGVAL	ESDBOOLE	CHAR	1	0	Value Exists
30	UPPDEC	☐	HSME_NUMDEC	INT4	INT4	10	0	Number of Decimal Places
31	UNIT	☐	HSME_UNIT	MEINS	UNIT	3	0	Unit of Measure	T006

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HSMT_DN	AENNR	AENR	AENNR	REF	1	CN
2	HSMT_DN	MANDT	T000	MANDT		1	CN
3	HSMT_DN	NUMTYPE	HSMC_019	NUMTYPE	REF	1	CN
4	HSMT_DN	SRSID	TCG56	SRSID	REF	1	CN
5	HSMT_DN	UNIT	T006	MSEHI	REF	1	CN

History

Last changed by/on	SAP	20110908
SAP Release Created in	700