SAP ABAP Table CCIHS_ERQTWSSEL (EHS: Data Structure, Selec. Screen (Initial) Worklist)
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_ERQTWSSEL   Table Relationship Diagram
Short Description EHS: Data Structure, Selec. Screen (Initial) Worklist    
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: Data Structure, Sel. Screen (Initial) Exposure Log  
2 MANDT MANDT MANDT CLNT 3   0   Client *
3 WAID CCIHE_WAID CCIHD_WAID CHAR 20   0   Work Area or Pattern  
4 WAVERS CCIHE_WAVERS CHAR5 CHAR 5   0   Work Area Version  
5 WATYPE CCIHE_WATYPE CCIHD_WATYPE CHAR 2   0   Work Area or Pattern Type CCIHC_WA01
6 WATYPENAM CCIHE_WATYPENAM TEXT20 CHAR 20   0   Description of Work Area Type  
7 WANAM CCIHE_WANAM TEXT60 CHAR 60   0   Language-Dependent Description of Work Area/Pattern  
8 EPTYPE CCIHE_EPTYPE ESDSUBCAT CHAR 10   0   Agent Type *
9 EPTYPENAM CCIHE_EPTYPENAM TEXT40 CHAR 40   0   Description of Agent Type  
10 EPID CCIHE_EPID CCIHD_EPID CHAR 20   0   Agent  
11 EPNAM CCIHE_EPNAM TEXT60 CHAR 60   0   Description of Agent  
12 AENNR AENNR AENNR CHAR 12   0   Change Number *
13 VALDAT ESEDIAGVD DATUM DATS 8   0   Key Date  
14 STATBUTTON ICON_TEXT SYCHAR132 CHAR 132   0   Carrier field for icons  
15 STATFLG1 CCIHE_ERFLGRQ ESDFLAG CHAR 1   0   Selection via Agent Release Requests  
16 STATFLG2 CCIHE_ERFLGRL ESDFLAG CHAR 1   0   Selection of Released Agents  
17 STATFLG3 CCIHE_ERFLGAL ESDFLAG CHAR 1   0   Selection via Selected Status  
18 OPCOND CCIHE_OPCOND CCIHD_OPCOND CHAR 3   0   Operation Status of Work Area/Pattern CCIHC_OC01
19 OPCONDTXT CCIHE_OPCONDTXT TEXT30 CHAR 30   0   Description of Operation Status  
20 RAFLGNONE CCIHE_RAFLGNONE ESDFLAG CHAR 1   0   Selection Risk Assessments Without Value Assignments  
21 RAFLGHIGH CCIHE_RAFLGHIGH ESDFLAG CHAR 1   0   Selection High Risk (Traffic Light Red)  
22 RAFLGMED CCIHE_RAFLGMED ESDFLAG CHAR 1   0   Selection Medium Risk (Traffic Light Yellow)  
23 RAFLGLOW CCIHE_RAFLGLOW ESDFLAG CHAR 1   0   Selection No Risk (Traffic Light Green)  
24 MAINRATING CCIHE_MAINRATING CCIHD_RATING CHAR 3   0   Main Rating for Exposure *
25 MAINRATTXT CCIHE_MAINRATTXT TEXT20 CHAR 20   0   Description of Main Rating  
26 PATTERNFLG CCIHE_PATTERNFLG FLAG CHAR 1   0   Pattern  
27 VALFRMAIN ESEVALFR DATUM DATS 8   0   Valid-From Date  
28 VALTOMAIN ESEVALTO DATUM DATS 8   0   Valid-To Date  
29 SEARCHMODEMAIN ESESEARCHMODE ESDSEARCHMODE CHAR 1   0   Search mode to find historical data  
30 RAR CCIHE_RAR CCIHD_RAR CHAR 3   0   Reason for Risk Assessment CCIHC_RAR
31 RARTXT CCIHE_RARTXT TEXT40 CHAR 40   0   Description of Reason for Risk Assessment  
32 WAPLANT CCIHE_WAPLANT WERKS CHAR 4   0   Plant T001W
33 WAPLANTNAM CCIHE_WAPLANTNAM TEXT30 CHAR 30   0   Plant Description  
34 LGORT LGORT_D LGORT CHAR 4   0   Storage location *
35 LGOBE LGOBE TEXT16 CHAR 16   0   Description of Storage Location  
36 EPQUANTTYPE CCIHE_EPQUANTTYPE CCIHD_EPQUANTTYP CHAR 3   0   Amount Category CCIHC_QT01
37 EPQUANTNAM CCIHE_EPQUANTNAM TEXT26 CHAR 26   0   Description of Amount Category  
38 LTTYPE CCIHE_LTTYPE CCIHD_LTTYPE CHAR 3   0   Measured Value/Reference Value Category CCIHV_LT01
39 LTTYPENAM CCIHE_LTTYPENAM TEXT26 CHAR 26   0   Description of Measured Value Category  
40 VALFR CK_VALIDFR CK_KADAT DATS 8   0   Valid from  
41 VALTO CK_VALIDTO CK_KADAT DATS 8   0   Valid to  
42 MULSELWABUT ICON_TEXT SYCHAR132 CHAR 132   0   Carrier field for icons  
43 MULSELEXBUT ICON_TEXT SYCHAR132 CHAR 132   0   Carrier field for icons  
44 MULSELQTBUT ICON_TEXT SYCHAR132 CHAR 132   0   Carrier field for icons  
45 MULSELPLBUT ICON_TEXT SYCHAR132 CHAR 132   0   Carrier field for icons  
46 MULSELSLBUT ICON_TEXT SYCHAR132 CHAR 132   0   Carrier field for icons  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CCIHS_ERQTWSSEL EPQUANTTYPE CCIHC_QT01 EPQUANTTYPE REF 1 CN
2 CCIHS_ERQTWSSEL LTTYPE CCIHV_LT01 LTTYPE    
3 CCIHS_ERQTWSSEL OPCOND CCIHC_OC01 OPCOND REF 1 CN
4 CCIHS_ERQTWSSEL RAR CCIHC_RAR RAR REF 1 CN
5 CCIHS_ERQTWSSEL WAPLANT T001W WERKS 1 CN
6 CCIHS_ERQTWSSEL WATYPE CCIHC_WA01 WATYPE REF 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in