SAP ABAP Table EHSKS_KPI_ER (Structure for Key Figure on Risk Assessment)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS-BD (Application Component) Basic Data and Tools
     ⤷ CBKPI (Package) EHS Key Figures

Basic Data

Table Category	INTTAB	Structure
Structure	EHSKS_KPI_ER	Table Relationship Diagram
Short Description	Structure for Key Figure on Risk Assessment

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	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
2	RISKASSETNUM	☐	CCIHE_RISKASSETNUM	CCIHD_SETNUMBER	NUMC	8	0	Sequential Number of Risk Assessment
3	EPID	☐	CCIHE_EPID	CCIHD_EPID	CHAR	20	0	Agent
4	EPNAM	☐	CCIHE_EPNAM	TEXT60	CHAR	60	0	Description of Agent
5	EPTYPE	☐	CCIHE_EPTYPE	ESDSUBCAT	CHAR	10	0	Agent Type	TCG31
6	EPTYPENAM	☐	CCIHE_EPTYPENAM	TEXT40	CHAR	40	0	Description of Agent Type
7	MAINRATING	☐	CCIHE_MAINRATING	CCIHD_RATING	CHAR	3	0	Main Rating for Exposure	CCIHC_IH07
8	MAINRATTXT	☐	CCIHE_MAINRATTXT	TEXT20	CHAR	20	0	Description of Main Rating
9	RAINVRESULT	☐	CCIHE_RAINVRESULT	TEXT60	CHAR	60	0	Result of Risk Assessment
10	RAR	☐	CCIHE_RAR	CCIHD_RAR	CHAR	3	0	Reason for Risk Assessment	CCIHC_RAR
11	RARTXT	☐	CCIHE_RARTXT	TEXT40	CHAR	40	0	Description of Reason for Risk Assessment
12	REM	☐	ESEREM	TEXT60	CHAR	60	0	Note
13	ASSETSTAT	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
14	STATUS	☐	EHSBE_STATUS	J_STATUS	CHAR	5	0	Status
15	STATUSNAM	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
16	INITSTATUS	☐	CCIHE_INITSTATUS	J_STATUS	CHAR	5	0	Initial Status of an Object
17	INITSTATUSNAM	☐	CCIHE_INSTATNAM	TEXT30	CHAR	30	0	Description of Initial Status of an Object
18	NEXTRADAT	☐	CCIHE_NEXTRADAT	DATUM	DATS	8	0	Date of Next Risk Assessment
19	OVDUEFLG	☐	CCIHE_OVDUEFLG	ESDFLAG	CHAR	1	0	Risk Assessments Overdue
20	SEVERE	☐	CCIHE_SEVERE	CCIHD_SEVERE	CHAR	3	0	Severity of Risk	*
21	SEVERETXT	☐	CCIHE_SEVERETXT	TEXT40	CHAR	40	0	Description of Severity of Risk
22	PROBLTY	☐	CCIHE_PROBLTY	CCIHD_PROBLTY	CHAR	3	0	Probability of Risk	*
23	PROBLTYTXT	☐	CCIHE_PROBLTYTXT	TEXT40	CHAR	40	0	Description of Probability of Risk
24	ASSCONTRVAL	☐	CCIHE_ASSCONTRVAL	CCIHD_MAINVAL	DEC	1	0	Value Assignment After Check
25	QUALPROTECT	☐	CCIHE_QUALPROTECT	CHAR3	CHAR	3	0	Quality of Protection Level
26	QUALPROTECTXT	☐	CCIHE_QUALPROTECTXT	TEXT40	CHAR	40	0	Description of Quality of Protection Level
27	CHKRATING	☐	CCIHE_CHKRATING	CCIHD_RATING	CHAR	3	0	Rating After Check	CCIHC_IH07
28	ASSCONTRSTAT	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
29	ASSCONTRDAT	☐	CCIHE_ASSCONTRDAT	DATUM	DATS	8	0	Date of Rating After Check
30	WAPLANT	☐	CCIHE_WAPLANT	WERKS	CHAR	4	0	Plant	T001W
31	WAPLANTNAM	☐	CCIHE_WAPLANTNAM	TEXT30	CHAR	30	0	Plant Description
32	WAID	☐	CCIHE_WAID	CCIHD_WAID	CHAR	20	0	Work Area or Pattern
33	WANAM	☐	CCIHE_WANAM	TEXT60	CHAR	60	0	Language-Dependent Description of Work Area/Pattern
34	WATYPE	☐	CCIHE_WATYPE	CCIHD_WATYPE	CHAR	2	0	Work Area or Pattern Type	CCIHC_WA01
35	WATYPENAM	☐	CCIHE_WATYPENAM	TEXT20	CHAR	20	0	Description of Work Area Type
36	OPCOND	☐	CCIHE_OPCOND	CCIHD_OPCOND	CHAR	3	0	Operation Status of Work Area/Pattern	CCIHC_OC01
37	OPCONDTXT	☐	CCIHE_OPCONDTXT	TEXT30	CHAR	30	0	Description of Operation Status
38	RESP_PERSON	☐	EHSKE_RESP_PERNR	CCIHD_PERSON	CHAR	10	0	Personnel Number for Person Responsible
39	RESP_PERSGRP	☐	EHSKE_RESP_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group of Person Responsible
40	RESP_PERSGRP_TXT	☐	EHSKE_RESP_PERSGRP_TXT	DDTEXT	CHAR	60	0	Description: Person Group of Person Responsible
41	RESP_VORNA	☐	EHSKE_RESP_VORNA	PAD_VORNM	CHAR	40	0	First Name of Person Responsible
42	RESP_NACHN	☐	EHSKE_RESP_NACHN	PAD_NACHN	CHAR	40	0	Last Name of Person Responsible
43	RESP_CNAME	☐	EHSKE_RESP_CNAME	TEXT80	CHAR	80	0	Full Name of Person Responsible

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EHSKS_KPI_ER	CHKRATING	CCIHC_IH07	RATING
2	EHSKS_KPI_ER	EPTYPE	TCG31	SUBCAT
3	EHSKS_KPI_ER	MAINRATING	CCIHC_IH07	RATING		1	CN
4	EHSKS_KPI_ER	OPCOND	CCIHC_OC01	OPCOND
5	EHSKS_KPI_ER	RAR	CCIHC_RAR	RAR
6	EHSKS_KPI_ER	WAPLANT	T001W	WERKS
7	EHSKS_KPI_ER	WATYPE	CCIHC_WA01	WATYPE

History

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