SAP Table WCAHE
WCM: Work Clearance Document (Header)
WCAHE (WCM: Work Clearance Document (Header)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link WCAHE to other SAP tables.
WCAHE table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| WCNR | Work Clearance Document | WCEWCNR | CHAR | 12 | 0 | |||||||
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 | 0 | ||||||
| WCTYP | Type of WCM Object | WCETYP | CHAR | 1 | 0 | |||||||
| WCUSE | Usage of WCM Object | WCEUSAGE | WCCU | CHAR | 3 | 0 | ||||||
| STXT | Descriptive Short Text | WCESTXT | CHAR | 40 | 0 | |||||||
| LFLG | Long Text Exists | WCELTXTFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| DELFLG | Delete | WCEDELFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| UNTGFLG | Untagging Text Exists | WCEUNLTXTFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| TGFLG | Tagging Text Exists | WCETGLTXTFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| CATFLG1 | Catalog Exists | WCECATFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| CATFLG2 | Catalog Exists | WCECATFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| INGRP | Planner Group for Customer Service and Plant Maintenance | INGRP | T024I | CHAR | 3 | 0 | ||||||
| IWERK | Maintenance Planning Plant | IWERK | T399I | CHAR | 4 | 0 | ||||||
| WKCRTYP | Object types of the CIM resource | CR_OBJTY | CRID | CHAR | 2 | 0 | ||||||
| WKCRID | Object ID of the resource | CR_OBJID | CRID | NUMC | 8 | 0 | ||||||
| BEGRU | Technical object authorization group | IAUTG | T370B | CHAR | 4 | 0 | ||||||
| DATEFR | Valid-From Date for WCM Object | WCEDATEFR | DATS | 8 | 0 | |||||||
| TIMEFR | Valid-From Time for WCM Object | WCETIMEFR | TIMS | 6 | 0 | |||||||
| DATETO | Valid-To Date for WCM Object | WCEDATETO | DATS | 8 | 0 | |||||||
| TIMETO | Valid-To Time for WCM Object | WCETIMETO | TIMS | 6 | 0 | |||||||
| ANLZU | Overall Condition of Technical System | WCEANLZU | WCCG | CHAR | 2 | 0 | ||||||
| RCTIME | Recall Time | WCERECTIME | QUAN | 5 | 0 | |||||||
| RCUNIT | Unit of Recall Time | WCERECUNIT | T006 | UNIT | 3 | 0 | ||||||
| PRIOK | Priority | PRIOK | T356 | CHAR | 1 | 0 | ||||||
| TPLNR | Functional Location | TPLNR | IFLOT | CHAR | 30 | 0 | ||||||
| EQUNR | Equipment Number | EQUNR | EQUI | CHAR | 18 | 0 | ||||||
| LNKFLG | Object List Exists | WCELNKFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| TRAIN | Train | WCETRAIN | WCCH | CHAR | 3 | 0 | ||||||
| CRNAME | Created by | WCECRNAME | CHAR | 12 | 0 | |||||||
| CRDATE | Date on Which the Object Was Created | WCECRDATE | DATS | 8 | 0 | |||||||
| CRTIME | Time at Which Object was Created | WCECRTIME | TIMS | 6 | 0 | |||||||
| CHNAME | Last Changed By | WCECHNAME | CHAR | 12 | 0 | |||||||
| CHDATE | Date on Which Object was Last Changed | WCECHDATE | DATS | 8 | 0 | |||||||
| CHTIME | Time at Which Object was Last Changed | WCECHTIME | TIMS | 6 | 0 | |||||||
| PSPEL | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PRPS | NUMC | 8 | 0 | ||||||
| AUFNT | Number of superior network | CO_TEILNET | AUFK | CHAR | 12 | 0 | ||||||
| VORNR | Activity number replaced by sub-network | CN_VORNRT | CHAR | 4 | 0 | |||||||
| BDATE | Basic start date | CO_GSTRP | DATS | 8 | 0 | |||||||
| BTIME | Basic start time | CO_GSUZP | TIMS | 6 | 0 | |||||||
| EDATE | Basic finish date | CO_GLTRP | DATS | 8 | 0 | |||||||
| ETIME | Basic finish (time) | CO_GLUZP | TIMS | 6 | 0 | |||||||
| TSDATE | Scheduled start | CO_GSTRS | DATS | 8 | 0 | |||||||
| TSTIME | Scheduled Start (Time) | CO_GSUZS | TIMS | 6 | 0 | |||||||
| TFDATE | Scheduled finish | CO_GLTRS | DATS | 8 | 0 | |||||||
| TFTIME | Scheduled finish time | CO_GLUZS | TIMS | 6 | 0 | |||||||
| ESDATE | Date | WCEDATE | DATS | 8 | 0 | |||||||
| ESTIME | Time | WCETIME | TIMS | 6 | 0 | |||||||
| EFDATE | Date | WCEDATE | DATS | 8 | 0 | |||||||
| EFTIME | Time | WCETIME | TIMS | 6 | 0 | |||||||
| LSDATE | Date | WCEDATE | DATS | 8 | 0 | |||||||
| LSTIME | Time | WCETIME | TIMS | 6 | 0 | |||||||
| LFDATE | Date | WCEDATE | DATS | 8 | 0 | |||||||
| LFTIME | Time | WCETIME | TIMS | 6 | 0 | |||||||
| PSDATE | Date | WCEDATE | DATS | 8 | 0 | |||||||
| PSTIME | Time | WCETIME | TIMS | 6 | 0 | |||||||
| PFDATE | Date | WCEDATE | DATS | 8 | 0 | |||||||
| PFTIME | Time | WCETIME | TIMS | 6 | 0 | |||||||
| ASDATE | Actual start date | CO_GSTRI | DATS | 8 | 0 | |||||||
| ASTIME | Actual start time | CO_GSUZI | TIMS | 6 | 0 | |||||||
| AFDATE | Actual finish date | CO_GLTRI | DATS | 8 | 0 | |||||||
| AFTIME | Actual End Date (Time) | WCEAFTIME | TIMS | 6 | 0 | |||||||
| ETAPE | Revision Phase | WCEETAPE | WCCF | CHAR | 20 | 0 | ||||||
| DOCFLG | Linked to Document | WCEDOCFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| WCSTSMA | Status Profile | J_STSMA | TJ20 | CHAR | 8 | 0 | ||||||
| WCITMSTSMA | Status Profile | J_STSMA | TJ20 | CHAR | 8 | 0 | ||||||
| REFOBJ | Template (Object Number) | WCEREFOBJ | CHAR | 22 | 0 | |||||||
| REMARKFLG1 | Remarks (Maintenance) Exist | WCEREMARKFLG1 | CHAR | 1 | 0 |
Possible values
|
||||||
| REMARKFLG2 | Remarks (Operation) Exist | WCEREMARKFLG2 | CHAR | 1 | 0 |
Possible values
|
||||||
WCAHE foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| WCAHE | ANLZU | WCAHE | MANDT | WCCG | WCM: Overall Conditions of Technical System | MANDT |
| WCAHE | ANLZU | WCAHE | IWERK | WCCG | WCM: Overall Conditions of Technical System | IWERK |
| WCAHE | ANLZU | WCAHE | ANLZU | WCCG | WCM: Overall Conditions of Technical System | ANLZU |
| WCAHE | AUFNT | * | AUFK | Order master data | MANDT | |
| WCAHE | AUFNT | WCAHE | AUFNT | AUFK | Order master data | AUFNR |
| WCAHE | BEGRU | WCAHE | BEGRU | T370B | Technical object authorization group | BEGRU |
| WCAHE | BEGRU | WCAHE | MANDT | T370B | Technical object authorization group | MANDT |
| WCAHE | EQUNR | WCAHE | MANDT | EQUI | Equipment master data | MANDT |
| WCAHE | EQUNR | WCAHE | EQUNR | EQUI | Equipment master data | EQUNR |
| WCAHE | ETAPE | WCAHE | MANDT | WCCF | WCM: Revision Phase | MANDT |
| WCAHE | ETAPE | WCAHE | IWERK | WCCF | WCM: Revision Phase | IWERK |
| WCAHE | ETAPE | WCAHE | ETAPE | WCCF | WCM: Revision Phase | ETAPE |
| WCAHE | INGRP | WCAHE | IWERK | T024I | Maintenance planner groups | IWERK |
| WCAHE | INGRP | WCAHE | INGRP | T024I | Maintenance planner groups | INGRP |
| WCAHE | INGRP | WCAHE | MANDT | T024I | Maintenance planner groups | MANDT |
| WCAHE | IWERK | WCAHE | MANDT | T399I | Planning plant parameters | MANDT |
| WCAHE | IWERK | WCAHE | IWERK | T399I | Planning plant parameters | IWERK |
| WCAHE | MANDT | WCAHE | MANDT | T000 | Clients | MANDT |
| WCAHE | OBJNR | WCAHE | MANDT | ONR00 | General Object Number | MANDT |
| WCAHE | OBJNR | WCAHE | OBJNR | ONR00 | General Object Number | OBJNR |
| WCAHE | PRIOK | WCAHE | MANDT | T356 | Priorities | MANDT |
| WCAHE | PRIOK | * | T356 | Priorities | ARTPR | |
| WCAHE | PRIOK | WCAHE | PRIOK | T356 | Priorities | PRIOK |
| WCAHE | PSPEL | WCAHE | PSPEL | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
| WCAHE | PSPEL | * | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT | |
| WCAHE | RCUNIT | WCAHE | MANDT | T006 | Units of Measurement | MANDT |
| WCAHE | RCUNIT | WCAHE | RCUNIT | T006 | Units of Measurement | MSEHI |
| WCAHE | TPLNR | WCAHE | MANDT | IFLOT | Functional Location (Table) | MANDT |
| WCAHE | TPLNR | WCAHE | TPLNR | IFLOT | Functional Location (Table) | TPLNR |
| WCAHE | TRAIN | WCAHE | MANDT | WCCH | WCM: Train | MANDT |
| WCAHE | TRAIN | WCAHE | IWERK | WCCH | WCM: Train | IWERK |
| WCAHE | TRAIN | WCAHE | TRAIN | WCCH | WCM: Train | TRAIN |
| WCAHE | WCITMSTSMA | WCAHE | MANDT | TJ20 | Status profiles | MANDT |
| WCAHE | WCITMSTSMA | WCAHE | WCITMSTSMA | TJ20 | Status profiles | STSMA |
| WCAHE | WCSTSMA | WCAHE | MANDT | TJ20 | Status profiles | MANDT |
| WCAHE | WCSTSMA | WCAHE | WCSTSMA | TJ20 | Status profiles | STSMA |
| WCAHE | WCUSE | WCAHE | MANDT | WCCU | WCM: Use of Work Clearance Document | MANDT |
| WCAHE | WCUSE | WCAHE | IWERK | WCCU | WCM: Use of Work Clearance Document | IWERK |
| WCAHE | WCUSE | WCAHE | WCUSE | WCCU | WCM: Use of Work Clearance Document | WCUSE |
| WCAHE | WKCRID | WCAHE | WKCRID | CRID | CIM Resource - Entities | OBJID |
| WCAHE | WKCRID | WCAHE | MANDT | CRID | CIM Resource - Entities | MANDT |
| WCAHE | WKCRID | WCAHE | WKCRTYP | CRID | CIM Resource - Entities | OBJTY |
| WCAHE | WKCRTYP | WCAHE | MANDT | CRID | CIM Resource - Entities | MANDT |
| WCAHE | WKCRTYP | WCAHE | WKCRTYP | CRID | CIM Resource - Entities | OBJTY |
| WCAHE | WKCRTYP | WCAHE | WKCRID | CRID | CIM Resource - Entities | OBJID |
