SAP ABAP Table WCSALV42 (WCM: Work Permits)
Hierarchy
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   PM-WCM (Application Component) Work Clearance Management
     WCM (Package) WCM: Work Clearance Management
Basic Data
Table Category INTTAB    Structure 
Structure WCSALV42   Table Relationship Diagram
Short Description WCM: Work Permits    
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 AUFNR AUFNR AUFNR CHAR 12   0   Order Number *
2 WAPINR WCEWAPINR WCDNO CHAR 12   0   Application  
3 WAPITYP WCETYP WCDTYP CHAR 1   0   Type of WCM Object  
4 STXT WCESTXT TEXT40 CHAR 40   0   Descriptive Short Text  
5 SYSST ILOM_STTXS TEXT40 CHAR 40   0   Display lines for system status  
6 USRST ILOM_STTXU TEXT40 CHAR 40   0   Display lines for user status  
7 WAPIUSE WCEUSAGE WCDUSAGE CHAR 3   0   Usage of WCM Object  
8 VALIDICON WCEVALIDICON GUI_INFO CHAR 60   0   Validity  
9 .INCLUDE       0   0   WCM: Valid From/Valid To  
10 DATEFR WCEDATEFR SYDATS DATS 8   0   Valid-From Date for WCM Object  
11 TIMEFR WCETIMEFR SYTIME TIMS 6   0   Valid-From Time for WCM Object  
12 DATETO WCEDATETO SYDATS DATS 8   0   Valid-To Date for WCM Object  
13 TIMETO WCETIMETO SYTIME TIMS 6   0   Valid-To Time for WCM Object  
14 EXTPERIOD WCEEXTTOTPERIOD WCDOBJVAL INT4 10   0   Total Extension of Validity in Hours  
15 PRIOK PRIOK PRIOK CHAR 1   0   Priority T356
16 RCTIME WCERECTIME WCDRECTIME QUAN 5   0   Recall Time  
17 RCUNIT WCERECUNIT MEINS UNIT 3   0   Unit of Recall Time T006
18 ANLZU WCEANLZU CHAR2 CHAR 2   0   Overall Condition of Technical System WCCG
19 ETAPE WCEETAPE CHAR20 CHAR 20   0   Revision Phase WCCF
20 TPLNR TPLNR TPLNR CHAR 30   0   Functional Location IFLOT
21 EQUNR EQUNR EQUNR CHAR 18   0   Equipment Number EQUI
22 TRAIN WCETRAIN CHAR3 CHAR 3   0   Train WCCH
23 INGRP INGRP INGRP CHAR 3   0   Planner Group for Customer Service and Plant Maintenance T024I
24 IWERK IWERK WERKS CHAR 4   0   Maintenance Planning Plant WCCO
25 WKCR WCEWKCR ARBPL CHAR 8   0   Work Center in WCM  
26 PLANT WCEPLANT WERKS CHAR 4   0   Plant for Work Center in WCM T001W
27 BEGRU IAUTG IAUTG CHAR 4   0   Authorization Group for Technical Object T370B
28 REFKEY WCEREFKEY WCDNO CHAR 12   0   Template  
29 .INCLUDE       0   0   WCM: Symbols  
30 PHASEICON WCELCPHASEICON GUI_INFO CHAR 60   0   Life-Cycle Phase  
31 APRVICON WCEAPRVICON GUI_INFO CHAR 60   0   Approvals  
32 DOCMGNICON WCEDOCMGNICON GUI_INFO CHAR 60   0   Documents  
33 LTXTICON WCELTXTICON GUI_INFO CHAR 60   0   Long Text  
34 TGTXTICON WCETGTXTICON GUI_INFO CHAR 60   0   Tagging Text  
35 UNTGTXTICON WCEUNTGTXTICON GUI_INFO CHAR 60   0   Untagging Text  
36 REQTXTICON WCEREQTXTICON GUI_INFO CHAR 60   0   Requalification Text  
37 OBJLSTICON WCEOBJLSTICON GUI_INFO CHAR 60   0   Object List  
38 PARTNERICON WCEPARTNERICON GUI_INFO CHAR 60   0   Partner  
39 DIALOGICON WCEDIALOGICON GUI_INFO CHAR 60   0   Maintenance Screen  
40 PROCESSICON WCEPROCESSICON GUI_INFO CHAR 60   0   Switching Screen  
41 UPASGNICON WCEASGNICON GUI_INFO CHAR 60   0   Assignments  
42 DNASGNICON WCEASGNICON GUI_INFO CHAR 60   0   Assignments  
43 CATICON1 WCECATALOGICON GUI_INFO CHAR 60   0   Catalog  
44 CATICON2 WCECATALOGICON GUI_INFO CHAR 60   0   Catalog  
45 OPLSTICON WCEOPLSTICON GUI_INFO CHAR 60   0   Operational Lists  
46 OPSTEPICON WCEOPSTEPICON GUI_INFO CHAR 60   0   Operational Steps  
47 .INCLUDE       0   0   WCM: I/O Administrative Info  
48 .INCLUDE       0   0   WCM: I/O Administration Data (Create)  
49 CRNAME WCECRNAME USNAM CHAR 12   0   Created by  
50 CRDATE WCECRDATE DATUM DATS 8   0   Date on Which the Object Was Created  
51 CRTIME WCECRTIME UZEIT TIMS 6   0   Time at Which Object was Created  
52 .INCLUDE       0   0   WCM: I/O Administration Info (Change)  
53 CHNAME WCECHNAME USNAM CHAR 12   0   Last Changed By  
54 CHDATE WCECHDATE DATUM DATS 8   0   Date on Which Object was Last Changed  
55 CHTIME WCECHTIME UZEIT TIMS 6   0   Time at Which Object was Last Changed  
56 .INCLUDE       0   0   WCM: I/O Basic Date  
57 BDATE CO_GSTRP DATUM DATS 8   0   Basic start date  
58 BTIME CO_GSUZP UHRZT TIMS 6   0   Basic start time  
59 EDATE CO_GLTRP DATUM DATS 8   0   Basic finish date  
60 ETIME CO_GLUZP UHRZT TIMS 6   0   Basic finish (time)  
61 .INCLUDE       0   0   WCM: I/O Scheduled  
62 TSDATE CO_GSTRS DATUM DATS 8   0   Scheduled start  
63 TSTIME CO_GSUZS ATIME TIMS 6   0   Scheduled Start (Time)  
64 TFDATE CO_GLTRS DATUM DATS 8   0   Scheduled finish  
65 TFTIME CO_GLUZS UHRZT TIMS 6   0   Scheduled finish time  
66 .INCLUDE       0   0   WCM: I/O Actual Date  
67 ASDATE CO_GSTRI DATUM DATS 8   0   Actual start date  
68 ASTIME CO_GSUZI UHRZT TIMS 6   0   Actual start time  
69 AFDATE CO_GLTRI DATUM DATS 8   0   Actual finish date  
70 AFTIME WCEAFTIME UZEIT TIMS 6   0   Actual End Date (Time)  
71 .INCLUDE       0   0   WCM: Work and Requirements  
72 .INCLUDE       0   0   WCM: Work  
73 WK01 WCEWK01 WCDWK CHAR 1   0   Hot Work A  
74 WK02 WCEWK02 WCDWK CHAR 1   0   Hot Work B in Classified Areas  
75 WK03 WCEWK03 WCDWK CHAR 1   0   Entry to Confined Spaces  
76 WK04 WCEWK04 WCDWK CHAR 1   0   Isolation and Testing or Bypassing of Safety Systems  
77 WK05 WCEWK05 WCDWK CHAR 1   0   Work on Hydrocarbon Systems (CmHn)  
78 WK06 WCEWK06 WCDWK CHAR 1   0   Pressure Testing  
79 WK07 WCEWK07 WCDWK CHAR 1   0   Work over Open Sea  
80 WK08 WCEWK08 WCDWK CHAR 1   0   Work with Hazardous Substances  
81 WK09 WCEWK09 WCDWK CHAR 1   0   Work with Radioactive Materials  
82 WK10 WCEWK10 WCDWK CHAR 1   0   Well Operation/Well Intervention  
83 WK11 WCEWK11 WCDWK CHAR 1   0   Work with Explosives  
84 WK12 WCEWK12 WCDWK CHAR 1   0   Critical Lifting Operations  
85 WK13 WCEWK13 WCDWK CHAR 1   0   Other Activities/Critical Operations  
86 WK14 WCEWK14 WCDWK CHAR 1   0   Nightwork  
87 WK15 WCEWK15 WCDWK CHAR 1   0   Work at Height  
88 WK16 WCEWK16 WCDWK CHAR 1   0   Overhead Work  
89 WK17 WCEWK17 WCDWK CHAR 1   0   Replacing Lamps  
90 WK18 WCEWK18 WCDWK CHAR 1   0   Work in Manholes  
91 WK19 WCEWK19 WCDWK CHAR 1   0   Cleaning Work  
92 WK20 WCEWK20 WCDWK CHAR 1   0   Demolition Work  
93 WK21 WCEWK21 WCDWK CHAR 1   0   Work on Ventilation  
94 WK22 WCEWK22 WCDWK CHAR 1   0   Work on Water Supply  
95 WK23 WCEWK23 WCDWK CHAR 1   0   Work on Gas Plant  
96 WK24 WCEWK24 WCDWK CHAR 1   0   Simultaneous Works  
97 WK25 WCEWK25 WCDWK CHAR 1   0   Restructuring Work  
98 WK26 WCEWK26 WCDWK CHAR 1   0   Painting Work  
99 WK27 WCEWK27 WCDWK CHAR 1   0   Checking  
100 WK28 WCEWK28 WCDWK CHAR 1   0   More Work  
101 .INCLUDE       0   0   WCM: Requirements  
102 NEED01 WCENEED01 WCDNEED CHAR 1   0   Depressurization  
103 NEED02 WCENEED02 WCDNEED CHAR 1   0   Draining/Emptying  
104 NEED03 WCENEED03 WCDNEED CHAR 1   0   Cleaning/Hydrocarbon Freeing  
105 NEED04 WCENEED04 WCDNEED CHAR 1   0   Venting/Installation of Extra Ventilation  
106 NEED05 WCENEED05 WCDNEED CHAR 1   0   Prevent Release of Oil and Gas in the Work Area  
107 NEED06 WCENEED06 WCDNEED CHAR 1   0   Measures Against Radioactive Radiation  
108 NEED07 WCENEED07 WCDNEED CHAR 1   0   Regular Inspection of the Work Area  
109 NEED08 WCENEED08 WCDNEED CHAR 1   0   Gas Measurements Prior to/During Working Period  
110 NEED09 WCENEED09 WCDNEED CHAR 1   0   Fire Prevention  
111 NEED10 WCENEED10 WCDNEED CHAR 1   0   Continuous Guard/Radio  
112 NEED11 WCENEED11 WCDNEED CHAR 1   0   Drains Blocked/Covered  
113 NEED12 WCENEED12 WCDNEED CHAR 1   0   Set Up Barriers and Safety Signs  
114 NEED13 WCENEED13 WCDNEED CHAR 1   0   PA Announcements  
115 NEED14 WCENEED14 WCDNEED CHAR 1   0   Welding Machine Safely Located and Earthed  
116 NEED15 WCENEED15 WCDNEED CHAR 1   0   Follow Requirements for Work on Open Sea  
117 NEED16 WCENEED16 WCDNEED CHAR 1   0   Follow Requirements for Work At Height  
118 NEED17 WCENEED17 WCDNEED CHAR 1   0   HSE Datasheet Known and Available  
119 NEED18 WCENEED18 WCDNEED CHAR 1   0   Job Safety Analysis (JSA)  
120 NEED19 WCENEED19 WCDNEED CHAR 1   0   Lockout/Tagout  
121 NEED20 WCENEED20 WCDNEED CHAR 1   0   Provide Extinguishing Media  
122 NEED21 WCENEED21 WCDNEED CHAR 1   0   Set Up Fire Watch  
123 NEED22 WCENEED22 WCDNEED CHAR 1   0   Inform External Bodies  
124 NEED23 WCENEED23 WCDNEED CHAR 1   0   On-Site Instruction  
125 NEED24 WCENEED24 WCDNEED CHAR 1   0   Additional Protective Equipment  
126 NEED25 WCENEED25 WCDNEED CHAR 1   0   Maintain Initial List  
127 NEED26 WCENEED26 WCDNEED CHAR 1   0   Safety Staff  
128 NEED27 WCENEED27 WCDNEED CHAR 1   0   More Measures  
129 NEED28 WCENEED28 WCDNEED CHAR 1   0   Secure Installations  
130 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 WCSALV42 ANLZU WCCG ANLZU    
2 WCSALV42 BEGRU T370B BEGRU    
3 WCSALV42 EQUNR EQUI EQUNR    
4 WCSALV42 ETAPE WCCF ETAPE    
5 WCSALV42 INGRP T024I INGRP 1 CN
6 WCSALV42 IWERK WCCO IWERK    
7 WCSALV42 PLANT T001W WERKS    
8 WCSALV42 PRIOK T356 PRIOK    
9 WCSALV42 RCUNIT T006 MSEHI    
10 WCSALV42 TPLNR IFLOT TPLNR    
11 WCSALV42 TRAIN WCCH TRAIN    
History
Last changed by/on SAP  20130529 
SAP Release Created in 605