SAP ABAP Table CCIHS_PEXPLOG_EXPQTY (EHS: Agents and Amounts in Personal Exposure Log)

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_PEXPLOG_EXPQTY	Table Relationship Diagram
Short Description	EHS: Agents and Amounts in Personal Exposure Log

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: IOTAB for Exposure Log (CCIHS_ERH)
2	.INCLUDE	☐				0	0	EHS: Standard fields for IOTABs (step loop library)
3	MARKFLG	☐	ESEMARKFLG	ESDFLAG	CHAR	1	0	Row Is Selected
4	SELEFLG	☐	ESESELEFLG	ESDFLAG	CHAR	1	0	Step Loop Line Selected
5	LINENO	☐	ESECOUNTER	NUMC10	NUMC	10	0	General Auxiliary Counter
6	LINEMOD	☐	ESELINEMOD	CHAR1	CHAR	1	0	Processing status or mode of a record/step loop line
7	CHCOFLG	☐	ESECHCOFLG	ESDFLAG	CHAR	1	0	Indicator: Change number collision
8	LOCKMOD	☐	ESELOCKMOD	CHAR1	CHAR	1	0	Lock Mode (Shared, Exclusive)
9	INTRFLG	☐	ESEINTRFLG	ESDFLAG	CHAR	1	0	Flag for Internal Use
10	.INCLUDE	☐				0	0	EHS: Risk Assessment - Header
11	.INCLUDE	☐				0	0	EHS: Structure for key info of master data
12	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
13	RECN	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
14	ACTN	☐	ESEACTN	ESDACTN	NUMC	20	0	Sequential Number of the Change State
15	.INCLUDE	☐				0	0	EHS: Structure for General Administration Information
16	VALFR	☐	ESEVALFR	DATUM	DATS	8	0	Valid-From Date
17	VALTO	☐	ESEVALTO	DATUM	DATS	8	0	Valid-To Date
18	AENNR	☐	ESEAENNR	AENNR	CHAR	12	0	Change Number	AENR
19	DELFLG	☐	ESEDELFLG	ESDFLAG	CHAR	1	0	Deletion Indicator
20	PARKFLG	☐	ESEPARKFLG	ESDFLAG	CHAR	1	0	Data Record Is Inactive
21	CRDAT	☐	ESECRDAT	DATUM	DATS	8	0	Created On
22	CRNAM	☐	ESECRNAM	USNAM	CHAR	12	0	Created By
23	UPDDAT	☐	ESEUPDDAT	DATUM	DATS	8	0	Changed On
24	UPDNAM	☐	ESEUPDNAM	USNAM	CHAR	12	0	Last Changed By
25	SRSID	☐	ESESRSID	ESDSRSID	CHAR	10	0	Source of Data	TCG56
26	OWNID	☐	ESEVENDRID	AD_ADDRNUM	CHAR	10	0	Data Provider	*
27	RECNROOT	☐	ESERECN	ESDRECN	NUMC	20	0	Sequential Number of Data Record
28	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
29	RECNTWAH	☐	CCIHE_RECNTWAH	ESDRECN	NUMC	20	0	Reference to Work Area
30	EPTYPE	☐	CCIHE_EPTYPE	ESDSUBCAT	CHAR	10	0	Agent Type	CCIHV_HAZTYPE
31	EPID	☐	CCIHE_EPID	CCIHD_EPID	CHAR	20	0	Agent
32	ERSTATUS	☐	EHSBE_STATUS	J_STATUS	CHAR	5	0	Status
33	ERINITSTATUS	☐	CCIHE_INITSTATUS	J_STATUS	CHAR	5	0	Initial Status of an Object
34	REM	☐	ESEREM	TEXT60	CHAR	60	0	Note
35	RISKASSETNUM	☐	CCIHE_RISKASSETNUM	CCIHD_SETNUMBER	NUMC	8	0	Sequential Number of Risk Assessment
36	OPCOND	☐	CCIHE_OPCOND	CCIHD_OPCOND	CHAR	3	0	Operation Status of Work Area/Pattern	CCIHC_OC01
37	RATINGCAT	☐	CCIHE_RATINGCAT	CCIHD_RATINGCAT	CHAR	3	0	Exposure Rating Category	CCIHC_IH06
38	MAINRATING	☐	CCIHE_MAINRATING	CCIHD_RATING	CHAR	3	0	Main Rating for Exposure	CCIHC_IH07
39	RAINVRESULT	☐	CCIHE_RAINVRESULT	TEXT60	CHAR	60	0	Result of Risk Assessment
40	LTXTFLG	☐	ESELTXTFLG	ESDFLAG	CHAR	1	0	Long Text
41	ASSCONTRVAL	☐	CCIHE_ASSCONTRVAL	CCIHD_MAINVAL	DEC	1	0	Value Assignment After Check
42	ASSCONTRDAT	☐	CCIHE_ASSCONTRDAT	DATUM	DATS	8	0	Date of Rating After Check
43	ASSCTRPER	☐	CCIHE_ASSCTRPER	CCIHD_PERSON	CHAR	10	0	Person Responsible for Checking Risk Assessment
44	ASSCTRPEREXFLG	☐	CCIHE_PERSFLAG	CCIHD_PERSFLAG	CHAR	1	0	Internal/External Person
45	ASSCTRPERGRP	☐	CCIHE_PERSGRP	CCIHD_PERSGRP	CHAR	1	0	Person Group
46	RAR	☐	CCIHE_RAR	CCIHD_RAR	CHAR	3	0	Reason for Risk Assessment	CCIHC_RAR
47	NEXTRADAT	☐	CCIHE_NEXTRADAT	DATUM	DATS	8	0	Date of Next Risk Assessment
48	SEVERE	☐	CCIHE_SEVERE	CCIHD_SEVERE	CHAR	3	0	Severity of Risk	*
49	PROBLTY	☐	CCIHE_PROBLTY	CCIHD_PROBLTY	CHAR	3	0	Probability of Risk	*
50	SOID	☐	CCIHE_SOID	CHAR40	CHAR	40	0	Source Object Identifier
51	SOTYPE	☐	CCIHE_SOTYPE	CHAR20	CHAR	20	0	Source Object Type
52	SOPART	☐	CCIHE_SOPART	CHAR20	CHAR	20	0	Part of Source Object
53	SOTXT	☐	CCIHE_SOTXT	CHAR120	CHAR	120	0	Source Object Text
54	PLANBEGDAT	☐	CCIHE_ERPLBEGDAT	DATUM	DATS	8	0	Planned Risk Assessment Start Date
55	PLANENDDAT	☐	CCIHE_ERPLENDDAT	DATUM	DATS	8	0	Planned Risk Assessment End Date
56	ACTBEGDAT	☐	CCIHE_ERACTBEGDAT	DATUM	DATS	8	0	Actual Risk Assessment End Date
57	ACTENDDAT	☐	CCIHE_ERACTENDDAT	DATUM	DATS	8	0	Actual Risk Assessment End Date
58	QUALPROTECT	☐	CCIHE_QUALPROTECT	CHAR3	CHAR	3	0	Quality of Protection Level	CCIHC_QUALPROT
59	CHKRATING	☐	CCIHE_CHKRATING	CCIHD_RATING	CHAR	3	0	Rating After Check	CCIHC_IH07
60	EPTYPENAM	☐	CCIHE_EPTYPENAM	TEXT40	CHAR	40	0	Description of Agent Type
61	EPNAM	☐	CCIHE_EPNAM	TEXT60	CHAR	60	0	Description of Agent
62	ERSHSTATNAM	☐	CCIHE_ERSHSTATNAM	TEXT4	CHAR	4	0	Status of Exposure Assignment
63	ERSTATNAM	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
64	ERINITSHSTATNAM	☐	CCIHE_INSHSTANAM	TEXT4	CHAR	4	0	Initial Status of Object
65	ERINITSTATNAM	☐	CCIHE_INSTATNAM	TEXT30	CHAR	30	0	Description of Initial Status of an Object
66	WAID	☐	CCIHE_WAID	CCIHD_WAID	CHAR	20	0	Work Area or Pattern
67	WANAM	☐	CCIHE_WANAM	TEXT60	CHAR	60	0	Language-Dependent Description of Work Area/Pattern
68	WATYPE	☐	CCIHE_WATYPE	CCIHD_WATYPE	CHAR	2	0	Work Area or Pattern Type	*
69	PATTERNFLG	☐	CCIHE_PATTERNFLG	FLAG	CHAR	1	0	Pattern
70	APATTERNFLG	☐	CCIHE_APATTERNFLG	FLAG	CHAR	1	0	Collective Pattern
71	WAPLANT	☐	CCIHE_WAPLANT	WERKS	CHAR	4	0	Plant	*
72	WAPLANTNAM	☐	CCIHE_WAPLANTNAM	TEXT30	CHAR	30	0	Plant Description
73	EXCLUDEFLG	☐	CCIHE_EXCLUDEFLG	ESDFLAG	CHAR	1	0	Exclude Value
74	OPCONDTXT	☐	CCIHE_OPCONDTXT	TEXT30	CHAR	30	0	Description of Operation Status
75	ASSETSTAT	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
76	ASSCONTRSTAT	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
77	MAINRATTXT	☐	CCIHE_MAINRATTXT	TEXT20	CHAR	20	0	Description of Main Rating
78	CONTRFULLNAME	☐	CCIHE_FULLNAME	TEXT80	CHAR	80	0	Full Name of Person
79	SPLITTFLG	☐	CCIHE_SPLITTFLG	FLAG	CHAR	1	0	Record Split
80	PATTERNREAD	☐	CCIHE_PATTERNFLG	FLAG	CHAR	1	0	Pattern
81	ASSCTRPERGRPTXT	☐	CCIHE_PERSGRPTXT	TEXT30	CHAR	30	0	Person Group Description
82	RARTXT	☐	CCIHE_RARTXT	TEXT40	CHAR	40	0	Description of Reason for Risk Assessment
83	SEVERETXT	☐	CCIHE_SEVERETXT	TEXT40	CHAR	40	0	Description of Severity of Risk
84	PROBLTYTXT	☐	CCIHE_PROBLTYTXT	TEXT40	CHAR	40	0	Description of Probability of Risk
85	SONAM	☐	CCIHE_SONAM	TEXT60	CHAR	60	0	Source Object Name
86	SOICON	☐	ICON_TEXT	SYCHAR132	CHAR	132	0	Carrier field for icons
87	QUALPROTECTXT	☐	CCIHE_QUALPROTECTXT	TEXT40	CHAR	40	0	Description of Quality of Protection Level
88	CHKRATINGTXT	☐	CCIHE_CHKRATINGTXT	TEXT20	CHAR	20	0	Description of Rating After Check
89	TIMEFRAME	☐	CCIHE_TIMEFRAME		CHAR	23	0	Period
90	QUANTVAL1	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
91	QUANTVAL2	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
92	QUANTVAL3	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
93	QUANTVAL4	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
94	QUANTVAL5	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
95	QUANTVAL6	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
96	QUANTVAL7	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
97	QUANTVAL8	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
98	QUANTVAL9	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
99	QUANTVAL10	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
100	QUANTVAL11	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
101	QUANTVAL12	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
102	QUANTVAL13	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
103	QUANTVAL14	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
104	QUANTVAL15	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
105	QUANTVAL16	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
106	QUANTVAL17	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
107	QUANTVAL18	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
108	QUANTVAL19	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25
109	QUANTVAL20	☐	TEXT25	TEXT25	CHAR	25	0	Text length 25

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in	200