SAP ABAP Table CCIHS_MJSEL (EHS: Data Structure for Value Help - Measurement)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS-IHS (Application Component) Industrial Hygiene and Safety
     ⤷ CBIH (Package) EH&S: Industrial Hygiene and Safety

Basic Data

Table Category	INTTAB	Structure
Structure	CCIHS_MJSEL	Table Relationship Diagram
Short Description	EHS: Data Structure for Value Help - Measurement

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	MJID	☐	CCIHE_MJID	CCIHD_MJID	CHAR	30	0	Measurement Number
3	MJSTAT	☐	EHSBE_STATUS	J_STATUS	CHAR	5	0	Status
4	MSHSTANAM	☐	J_TXT04	TEXT4	CHAR	4	0	Individual status of an object (short form)
5	MSTATNAM	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
6	MJCAT	☐	CCIHE_MJCAT	CCIHD_MJCAT	CHAR	3	0	Sampling Type	CCIHC_MJCAT
7	MJCATTXT	☐	CCIHE_MJCATTXT	TEXT60	CHAR	60	0	Description of Sampling Type
8	MSOURCEID	☐	CCIHE_MSOURCEID	CCIHD_MSOURCEID	CHAR	3	0	Sampling Location	CCIHC_MSOURCE
9	MSOURCE	☐	CCIHE_MSOURCE	CCIHD_MSOURCE	CHAR	120	0	Description of Sampling Location
10	MSOURCENOTE	☐	CCIHE_MSOURCENOTE	CCIHD_MSOURCENOTE	CHAR	255	0	Description for Sampling Location
11	MPH_WAID	☐	CCIHE_WAID	CCIHD_WAID	CHAR	20	0	Work Area or Pattern
12	MPH_WANAM	☐	CCIHE_WANAM	TEXT60	CHAR	60	0	Language-Dependent Description of Work Area/Pattern
13	MPH_RECNTWAH	☐	CCIHE_RECNTWAH	ESDRECN	NUMC	20	0	Reference to Work Area
14	MPW_WAID	☐	CCIHE_WAID	CCIHD_WAID	CHAR	20	0	Work Area or Pattern
15	MPW_WANAM	☐	CCIHE_WANAM	TEXT60	CHAR	60	0	Language-Dependent Description of Work Area/Pattern
16	MPW_RECNTWAH	☐	CCIHE_RECNTWAH	ESDRECN	NUMC	20	0	Reference to Work Area
17	MSRBGNDATE	☐	CCIHE_MSRBGNDATE	DATUM	DATS	8	0	Date of Start of Measurement
18	METHOD	☐	CCIHE_METHOD	CCIHD_METHOD	CHAR	5	0	Measurement Method	CCIHC_METHOD
19	METHODTXT	☐	CCIHE_METHODTXT	TEXT60	CHAR	60	0	Description of Measurement Method
20	MPERSON	☐	CCIHE_MJPERSON	CCIHD_MJPERSON	CHAR	10	0	Test Person
21	MPERSONGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
22	MPERSONNAME	☐	CCIHE_FULLNAME	TEXT80	CHAR	80	0	Full Name of Person
23	STMFLG	☐	CCIHE_STMFLG	ESDFLAG	CHAR	1	0	Short-Term Sample
24	VALDAT	☐	ESEDIAGVD	DATUM	DATS	8	0	Key Date
25	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	*
26	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
27	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
28	SEARCHMODE	☐	ESESEARCHMODE	ESDSEARCHMODE	CHAR	1	0	Search mode to find historical data
29	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
30	RECNTMPWA	☐	CCIHE_RECNTMPWA	ESDRECN	NUMC	20	0	Reference to Assigned Work Area
31	MPID	☐	CCIHE_MPID	CCIHD_MPID	CHAR	30	0	Measurement Project

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CCIHS_MJSEL	METHOD	CCIHC_METHOD	METHOD
2	CCIHS_MJSEL	MJCAT	CCIHC_MJCAT	MJCAT
3	CCIHS_MJSEL	MSOURCEID	CCIHC_MSOURCE	MSOURCEID

History

Last changed by/on	SAP	20100310
SAP Release Created in