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
⤷ 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 |