SAP ABAP Table CCIHT_ERH (EHS: Risk Assessment - Header)

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	TRANSP	Transparent table
Transparent table	CCIHT_ERH	Table Relationship Diagram
Short Description	EHS: Risk Assessment - Header

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☑				0	0	EHS: Structure for key info of master data
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
3	RECN	☑	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
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	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
18	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
19	RECNTWAH	☐	CCIHE_RECNTWAH	ESDRECN	NUMC	20	0	Reference to Work Area
20	EPTYPE	☐	CCIHE_EPTYPE	ESDSUBCAT	CHAR	10	0	Agent Type	CCIHV_HAZTYPE
21	EPID	☐	CCIHE_EPID	CCIHD_EPID	CHAR	20	0	Agent
22	ERSTATUS	☐	EHSBE_STATUS	J_STATUS	CHAR	5	0	Status
23	ERINITSTATUS	☐	CCIHE_INITSTATUS	J_STATUS	CHAR	5	0	Initial Status of an Object
24	REM	☐	ESEREM	TEXT60	CHAR	60	0	Note
25	RISKASSETNUM	☐	CCIHE_RISKASSETNUM	CCIHD_SETNUMBER	NUMC	8	0	Sequential Number of Risk Assessment
26	OPCOND	☐	CCIHE_OPCOND	CCIHD_OPCOND	CHAR	3	0	Operation Status of Work Area/Pattern	CCIHC_OC01
27	RATINGCAT	☐	CCIHE_RATINGCAT	CCIHD_RATINGCAT	CHAR	3	0	Exposure Rating Category	CCIHC_IH06
28	MAINRATING	☐	CCIHE_MAINRATING	CCIHD_RATING	CHAR	3	0	Main Rating for Exposure	CCIHC_IH07
29	RAINVRESULT	☐	CCIHE_RAINVRESULT	TEXT60	CHAR	60	0	Result of Risk Assessment
30	LTXTFLG	☐	ESELTXTFLG	ESDFLAG	CHAR	1	0	Long Text
31	ASSCONTRVAL	☐	CCIHE_ASSCONTRVAL	CCIHD_MAINVAL	DEC	1	0	Value Assignment After Check
32	ASSCONTRDAT	☐	CCIHE_ASSCONTRDAT	DATUM	DATS	8	0	Date of Rating After Check
33	ASSCTRPER	☐	CCIHE_ASSCTRPER	CCIHD_PERSON	CHAR	10	0	Person Responsible for Checking Risk Assessment
34	ASSCTRPEREXFLG	☐	CCIHE_PERSFLAG	CCIHD_PERSFLAG	CHAR	1	0	Internal/External Person
35	ASSCTRPERGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
36	RAR	☐	CCIHE_RAR	CCIHD_RAR	CHAR	3	0	Reason for Risk Assessment	CCIHC_RAR
37	NEXTRADAT	☐	CCIHE_NEXTRADAT	DATUM	DATS	8	0	Date of Next Risk Assessment
38	SEVERE	☐	CCIHE_SEVERE	CCIHD_SEVERE	CHAR	3	0	Severity of Risk	*
39	PROBLTY	☐	CCIHE_PROBLTY	CCIHD_PROBLTY	CHAR	3	0	Probability of Risk	*
40	SOID	☐	CCIHE_SOID	CHAR40	CHAR	40	0	Source Object Identifier
41	SOTYPE	☐	CCIHE_SOTYPE	CHAR20	CHAR	20	0	Source Object Type
42	SOPART	☐	CCIHE_SOPART	CHAR20	CHAR	20	0	Part of Source Object
43	SOTXT	☐	CCIHE_SOTXT	CHAR120	CHAR	120	0	Source Object Text
44	PLANBEGDAT	☐	CCIHE_ERPLBEGDAT	DATUM	DATS	8	0	Planned Risk Assessment Start Date
45	PLANENDDAT	☐	CCIHE_ERPLENDDAT	DATUM	DATS	8	0	Planned Risk Assessment End Date
46	ACTBEGDAT	☐	CCIHE_ERACTBEGDAT	DATUM	DATS	8	0	Actual Risk Assessment End Date
47	ACTENDDAT	☐	CCIHE_ERACTENDDAT	DATUM	DATS	8	0	Actual Risk Assessment End Date
48	QUALPROTECT	☐	CCIHE_QUALPROTECT	CHAR3	CHAR	3	0	Quality of Protection Level	CCIHC_QUALPROT
49	CHKRATING	☐	CCIHE_CHKRATING	CCIHD_RATING	CHAR	3	0	Rating After Check	CCIHC_IH07

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CCIHT_ERH	AENNR	AENR	AENNR	REF	1	CN
2	CCIHT_ERH	CHKRATING	CCIHC_IH07	RATING	REF	1	CN
3	CCIHT_ERH	EPTYPE	CCIHV_HAZTYPE	SUBCAT	REF	1	CN
4	CCIHT_ERH	MAINRATING	CCIHC_IH07	RATING	REF	1	CN
5	CCIHT_ERH	MANDT	T000	MANDT
6	CCIHT_ERH	OPCOND	CCIHC_OC01	OPCOND	REF	1	CN
7	CCIHT_ERH	QUALPROTECT	CCIHC_QUALPROT	QUALPROTECT	REF	C	CN
8	CCIHT_ERH	RAR	CCIHC_RAR	RAR	REF	1	CN
9	CCIHT_ERH	RATINGCAT	CCIHC_IH06	RATINGCAT	REF	1	CN
10	CCIHT_ERH	SRSID	TCG56	SRSID	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in