SAP ABAP Table CCIHS_ERQTSEL (EHS: Data Structure, Sel. Screen (Initial) Agent Info System)

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_ERQTSEL	Table Relationship Diagram
Short Description	EHS: Data Structure, Sel. Screen (Initial) Agent Info System

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: Data Structure, Sel. Screen (Initial) Exposure Log
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	WAID	☐	CCIHE_WAID	CCIHD_WAID	CHAR	20	0	Work Area or Pattern
4	WAVERS	☐	CCIHE_WAVERS	CHAR5	CHAR	5	0	Work Area Version
5	WATYPE	☐	CCIHE_WATYPE	CCIHD_WATYPE	CHAR	2	0	Work Area or Pattern Type	CCIHC_WA01
6	WATYPENAM	☐	CCIHE_WATYPENAM	TEXT20	CHAR	20	0	Description of Work Area Type
7	WANAM	☐	CCIHE_WANAM	TEXT60	CHAR	60	0	Language-Dependent Description of Work Area/Pattern
8	EPTYPE	☐	CCIHE_EPTYPE	ESDSUBCAT	CHAR	10	0	Agent Type	*
9	EPTYPENAM	☐	CCIHE_EPTYPENAM	TEXT40	CHAR	40	0	Description of Agent Type
10	EPID	☐	CCIHE_EPID	CCIHD_EPID	CHAR	20	0	Agent
11	EPNAM	☐	CCIHE_EPNAM	TEXT60	CHAR	60	0	Description of Agent
12	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	*
13	VALDAT	☐	ESEDIAGVD	DATUM	DATS	8	0	Key Date
14	STATBUTTON	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
15	STATFLG1	☐	CCIHE_ERFLGRQ	ESDFLAG	CHAR	1	0	Selection via Agent Release Requests
16	STATFLG2	☐	CCIHE_ERFLGRL	ESDFLAG	CHAR	1	0	Selection of Released Agents
17	STATFLG3	☐	CCIHE_ERFLGAL	ESDFLAG	CHAR	1	0	Selection via Selected Status
18	OPCOND	☐	CCIHE_OPCOND	CCIHD_OPCOND	CHAR	3	0	Operation Status of Work Area/Pattern	CCIHC_OC01
19	OPCONDTXT	☐	CCIHE_OPCONDTXT	TEXT30	CHAR	30	0	Description of Operation Status
20	RAFLGNONE	☐	CCIHE_RAFLGNONE	ESDFLAG	CHAR	1	0	Selection Risk Assessments Without Value Assignments
21	RAFLGHIGH	☐	CCIHE_RAFLGHIGH	ESDFLAG	CHAR	1	0	Selection High Risk (Traffic Light Red)
22	RAFLGMED	☐	CCIHE_RAFLGMED	ESDFLAG	CHAR	1	0	Selection Medium Risk (Traffic Light Yellow)
23	RAFLGLOW	☐	CCIHE_RAFLGLOW	ESDFLAG	CHAR	1	0	Selection No Risk (Traffic Light Green)
24	MAINRATING	☐	CCIHE_MAINRATING	CCIHD_RATING	CHAR	3	0	Main Rating for Exposure	*
25	MAINRATTXT	☐	CCIHE_MAINRATTXT	TEXT20	CHAR	20	0	Description of Main Rating
26	PATTERNFLG	☐	CCIHE_PATTERNFLG	FLAG	CHAR	1	0	Pattern
27	VALFRMAIN	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
28	VALTOMAIN	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
29	SEARCHMODEMAIN	☐	ESESEARCHMODE	ESDSEARCHMODE	CHAR	1	0	Search mode to find historical data
30	RAR	☐	CCIHE_RAR	CCIHD_RAR	CHAR	3	0	Reason for Risk Assessment	CCIHC_RAR
31	RARTXT	☐	CCIHE_RARTXT	TEXT40	CHAR	40	0	Description of Reason for Risk Assessment
32	EPQUANTTYPE	☐	CCIHE_EPQUANTTYPE	CCIHD_EPQUANTTYP	CHAR	3	0	Amount Category	CCIHC_QT01
33	EPQUANTNAM	☐	CCIHE_EPQUANTNAM	TEXT26	CHAR	26	0	Description of Amount Category
34	LTTYPE	☐	CCIHE_LTTYPE	CCIHD_LTTYPE	CHAR	3	0	Measured Value/Reference Value Category	*
35	LTTYPENAM	☐	CCIHE_LTTYPENAM	TEXT26	CHAR	26	0	Description of Measured Value Category
36	EPQUANTSET	☐	CCIHE_EPQUANTSET	CCIHD_SETNUMBER	NUMC	8	0	Measurement Number
37	EPQUANTVAL	☐	CCIHE_EPQUANTVAL	CCIHD_EPQUANTVAL	DEC	10	4	Measurement Value of Physical Variable
38	MSRORDNR	☐	CCIHE_MSRORDNR	CCIHD_MSRORDNR	CHAR	20	0	Measurement Job Number
39	MSRNAM	☐	CCIHE_MSRNAM	USNAM	CHAR	12	0	Person Acting or Responsible
40	MSRBGNDATEV	☐	CCIHE_MSRBGNDATE	DATUM	DATS	8	0	Date of Start of Measurement
41	MSRBGNDATEB	☐	CCIHE_MSRBGNDATE	DATUM	DATS	8	0	Date of Start of Measurement
42	MSRENDDATEV	☐	CCIHE_MSRENDDATE	DATUM	DATS	8	0	Date of End of Measurement
43	MSRENDDATEB	☐	CCIHE_MSRENDDATE	DATUM	DATS	8	0	Date of End of Measurement
44	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
45	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
46	SEARCHMODE	☐	ESESEARCHMODE	ESDSEARCHMODE	CHAR	1	0	Search mode to find historical data

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CCIHS_ERQTSEL	EPQUANTTYPE	CCIHC_QT01	EPQUANTTYPE	REF	1	CN
2	CCIHS_ERQTSEL	OPCOND	CCIHC_OC01	OPCOND	REF	1	CN
3	CCIHS_ERQTSEL	RAR	CCIHC_RAR	RAR	REF	1	CN
4	CCIHS_ERQTSEL	WATYPE	CCIHC_WA01	WATYPE	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in