SAP ABAP Table HSMS_DNIO (EHS: I/O Hazardous Substance Addit. Data 2 (Numeric Type))

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_DNIO	Table Relationship Diagram
Short Description	EHS: I/O Hazardous Substance Addit. Data 2 (Numeric Type)

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 Addit. Data 2 (Numeric Type)
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: Data Structure for Haz. Subs. Addit. Data 2 (Num. Type)
28	NUMTYPE	☐	HSME_NUMTYPE	HSMD_NUMTYPE	CHAR	6	0	Numeric Value Type	HSMC_019
29	AVGVAL	☐	HSME_AVGVAL	HSMD_NUMVAL	FLTP	16	16	Target Value
30	AVGVALFLG	☐	HSME_FLGVAL	ESDBOOLE	CHAR	1	0	Value Exists
31	AVGDEC	☐	HSME_NUMDEC	INT4	INT4	10	0	Number of Decimal Places
32	LOWOP	☐	HSME_OPLOW	HSMD_OPLOW	CHAR	5	0	Operator for Lower Limit of Interval
33	LOWVAL	☐	HSME_LOWVAL	HSMD_NUMVAL	FLTP	16	16	Lower Limit of Interval
34	LOWVALFLG	☐	HSME_FLGVAL	ESDBOOLE	CHAR	1	0	Value Exists
35	LOWDEC	☐	HSME_NUMDEC	INT4	INT4	10	0	Number of Decimal Places
36	UPPOP	☐	HSME_OPUPP	HSMD_OPUPP	CHAR	5	0	Operator for Upper Limit of Interval
37	UPPVAL	☐	HSME_UPPVAL	HSMD_NUMVAL	FLTP	16	16	Upper Limit of Interval
38	UPPVALFLG	☐	HSME_FLGVAL	ESDBOOLE	CHAR	1	0	Value Exists
39	UPPDEC	☐	HSME_NUMDEC	INT4	INT4	10	0	Number of Decimal Places
40	UNIT	☐	HSME_UNIT	MEINS	UNIT	3	0	Unit of Measure	T006
41	AVGVALTXT	☐	HSME_AVGVALTXT	HSMD_VALTXT	CHAR	30	0	Exact Target Value
42	LOWVALTXT	☐	HSME_LOWVALTXT	HSMD_VALTXT	CHAR	30	0	Lower Limit of Interval
43	UPPVALTXT	☐	HSME_UPPVALTXT	HSMD_VALTXT	CHAR	30	0	Upper Limit of Interval
44	DIM	☐	DIMID	DIMID	CHAR	6	0	Dimension key	*
45	ID	☐	DOKU_ID	DOKU_ID	CHAR	2	0	Document class	DOKIL
46	OBJECT	☐	DOKU_OBJ	DOKU_OBJ	CHAR	60	0	Documentation Object
47	NUMTYPETXT	☐	HSME_NUMTYPETXT	TEXT60	CHAR	60	0	Description of Numeric Value Type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HSMS_DNIO	AENNR	AENR	AENNR	KEY	1	CN
2	HSMS_DNIO	ID	DOKIL	ID	KEY	1	CN
3	HSMS_DNIO	MANDT	T000	MANDT
4	HSMS_DNIO	NUMTYPE	HSMC_019	NUMTYPE		1	N
5	HSMS_DNIO	SRSID	TCG56	SRSID	KEY	1	CN
6	HSMS_DNIO	UNIT	T006	MSEHI		1	N

History

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