SAP ABAP Table CCIHS_PERS_WAH (Person for Work Area)
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_PERS_WAH   Table Relationship Diagram
Short Description Person for Work Area    
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 PERNR PERNR_D PERNR NUMC 8   0   Personnel Number  
2 TIMEFRAME RCGDATERANGE   STRU 0   0    
3 VALFR ESEDIAGVF DATUM DATS 8   0   From-Date for Specification Search Over Time Period  
4 VALTO ESEDIAGVT DATUM DATS 8   0   To-Date for Specification Search Over Time Period  
5 PROZT PROZT DEC3_2 DEC 5   2   Weighting Percentage  
6 .INCLUDE       0   0   EHS: IOTAB for Work Areas (CCIHT_WAH)  
7 .INCLUDE       0   0   EHS: Standard fields for IOTABs (step loop library)  
8 MARKFLG ESEMARKFLG ESDFLAG CHAR 1   0   Row Is Selected  
9 SELEFLG ESESELEFLG ESDFLAG CHAR 1   0   Step Loop Line Selected  
10 LINENO ESECOUNTER NUMC10 NUMC 10   0   General Auxiliary Counter  
11 LINEMOD ESELINEMOD CHAR1 CHAR 1   0   Processing status or mode of a record/step loop line  
12 CHCOFLG ESECHCOFLG ESDFLAG CHAR 1   0   Indicator: Change number collision  
13 LOCKMOD ESELOCKMOD CHAR1 CHAR 1   0   Lock Mode (Shared, Exclusive)  
14 INTRFLG ESEINTRFLG ESDFLAG CHAR 1   0   Flag for Internal Use  
15 .INCLUDE       0   0   EHS: Work Area - Header  
16 .INCLUDE       0   0   EHS: Structure for key info of master data  
17 MANDT MANDT MANDT CLNT 3   0   Client T000
18 RECN ESERECN ESDRECN NUMC 20   0   Sequential Number of Data Record  
19 ACTN ESEACTN ESDACTN NUMC 20   0   Sequential Number of the Change State  
20 .INCLUDE       0   0   EHS: Structure for General Administration Information  
21 VALFR ESEVALFR DATUM DATS 8   0   Valid-From Date  
22 VALTO ESEVALTO DATUM DATS 8   0   Valid-To Date  
23 AENNR ESEAENNR AENNR CHAR 12   0   Change Number AENR
24 DELFLG ESEDELFLG ESDFLAG CHAR 1   0   Deletion Indicator  
25 PARKFLG ESEPARKFLG ESDFLAG CHAR 1   0   Data Record Is Inactive  
26 CRDAT ESECRDAT DATUM DATS 8   0   Created On  
27 CRNAM ESECRNAM USNAM CHAR 12   0   Created By  
28 UPDDAT ESEUPDDAT DATUM DATS 8   0   Changed On  
29 UPDNAM ESEUPDNAM USNAM CHAR 12   0   Last Changed By  
30 SRSID ESESRSID ESDSRSID CHAR 10   0   Source of Data TCG56
31 OWNID ESEVENDRID AD_ADDRNUM CHAR 10   0   Data Provider *
32 RECNROOT ESERECN ESDRECN NUMC 20   0   Sequential Number of Data Record  
33 OBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number *
34 WAID CCIHE_WAID CCIHD_WAID CHAR 20   0   Work Area or Pattern  
35 WATYPE CCIHE_WATYPE CCIHD_WATYPE CHAR 2   0   Work Area or Pattern Type CCIHC_WA01
36 WASTAT EHSBE_STATUS J_STATUS CHAR 5   0   Status  
37 WAINITSTAT CCIHE_INITSTATUS J_STATUS CHAR 5   0   Initial Status of an Object  
38 WAVERS CCIHE_WAVERS CHAR5 CHAR 5   0   Work Area Version  
39 AUTHGRP CCIHE_WAAUTHGRP CCIHD_WAAUTHGRP CHAR 10   0   Authorization Group for Work Area or Pattern CCIHC_WA11
40 RVLID ESERVLID ESDRVLID CHAR 10   0   Validity Area TCG91
41 MTNLANGU CCIHE_MTNLANGU SPRAS LANG 1   0   Language of Entry T002
42 RECNTWAH CCIHE_RECNTWAH ESDRECN NUMC 20   0   Reference to Work Area  
43 WAPLANT CCIHE_WAPLANT WERKS CHAR 4   0   Plant T001W
44 WACOORD CCIHE_WACOORD TEXT20 CHAR 20   0   Work Area Coordinates  
45 WACOSTAC1 CCIHE_WACOSTAC KOSTL CHAR 10   0   Cost Center of Work Area *
46 WACTRAREA CCIHE_WACTRAREA CACCD CHAR 4   0   Controlling Area for Work Area *
47 WACOCODE CCIHE_WACOCODE BUKRS CHAR 4   0   Company Code for Work Area *
48 PTUSAGEFLG CCIHE_PTUSAGEFLG ESDBOOLE CHAR 1   0   Usage Indicator for Pattern  
49 OVERALLRAT CCIHE_OVERALLRAT CCIHD_RATING CHAR 3   0   Overall Rating of Exposure Situation in Work Area *
50 RECEIVEDRAT CCIHE_RECEIVEDRAT CCIHD_RATING CHAR 3   0   Received Rating in Work Area *
51 WANAM CCIHE_WANAM TEXT60 CHAR 60   0   Language-Dependent Description of Work Area/Pattern  
52 WATYPENAM CCIHE_WATYPENAM TEXT20 CHAR 20   0   Description of Work Area Type  
53 AUTHNAM CCIHE_WAAUTHNAM TEXT40 CHAR 40   0   Description of Authorization Group  
54 WASPID CCIHE_WASPID CCIHD_WAID CHAR 20   0   Higher-Level Work Area  
55 WASPNAM CCIHE_WANAM TEXT60 CHAR 60   0   Language-Dependent Description of Work Area/Pattern  
56 WASPTYPE CCIHE_WATYPE CCIHD_WATYPE CHAR 2   0   Work Area or Pattern Type *
57 WASPTYPENAM CCIHE_WATYPENAM TEXT20 CHAR 20   0   Description of Work Area Type  
58 WASHSTATNAM CCIHE_WASHSTATNAM TEXT4 CHAR 4   0   Status  
59 WASTATNAM J_TXT30 TEXT30 CHAR 30   0   Object status  
60 WAINITSHSTATNAM CCIHE_INSHSTANAM TEXT4 CHAR 4   0   Initial Status of Object  
61 WAINITSTATNAM CCIHE_INSTATNAM TEXT30 CHAR 30   0   Description of Initial Status of an Object  
62 WAPLANTNAM CCIHE_WAPLANTNAM TEXT30 CHAR 30   0   Plant Description  
63 COSTCNAM CCIHE_COSTCNAM CHAR20 CHAR 20   0   Description of Cost Center  
64 RVLNAM ESERVLNAM TEXT40 CHAR 40   0   Description for Validity Area  
65 RVLTYPE ESERVLTYPE ESDRVLTYPE CHAR 10   0   Validity Area Category TCG89
66 RVLTYPENAM ESERVLTYPENAM TEXT40 CHAR 40   0   Language-Dependent Description for Validity Area Category  
67 EXCLUDEFLG CCIHE_EXCLUDEFLG ESDFLAG CHAR 1   0   Exclude Value  
68 KEYDRAWNFLG CCIHE_KEYDRAWN ESDFLAG CHAR 1   0   Key Assigned Automatically  
69 MTNLANGUTXT SPTXT SPTXT16 CHAR 16   0   Name of Language  
70 OVERALLRATTXT CCIHE_RATINGTXT TEXT20 CHAR 20   0   Description of an Exposure/Risk Rating  
71 RECEIVEDRATTXT CCIHE_RATINGTXT TEXT20 CHAR 20   0   Description of an Exposure/Risk Rating  
72 OVERALLRATICON ICON_TEXT SYCHAR132 CHAR 132   0   Carrier field for icons  
73 RECEIVEDRATICON 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_PERS_WAH AENNR AENR AENNR REF 1 CN
2 CCIHS_PERS_WAH AUTHGRP CCIHC_WA11 AUTHGRP 1 CN
3 CCIHS_PERS_WAH MANDT T000 MANDT    
4 CCIHS_PERS_WAH MTNLANGU T002 SPRAS REF 1 CN
5 CCIHS_PERS_WAH RVLID TCG91 RVLID 1 CN
6 CCIHS_PERS_WAH RVLTYPE TCG89 RVLTYPE REF 1 CN
7 CCIHS_PERS_WAH SRSID TCG56 SRSID REF 1 CN
8 CCIHS_PERS_WAH WAPLANT T001W WERKS 1 CN
9 CCIHS_PERS_WAH WATYPE CCIHC_WA01 WATYPE REF 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in 700