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