SAP WCAHE WCM: Work Clearance Document (Header) Table
Overview
WCAHE is a standard SAP S/4HANA table that stores WCM: Work Clearance Document (Header) data. There are total 81 fields in the WCAHE table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WCAHE belongs to Work Clearance Management (PM-WCM) module and is located in the package WCM: Work Clearance Management (WCM).
In addition, following links provide an overview of foreign key relationships, if any, that link WCAHE to other SAP tables and standard CDS views available based on WCAHE table in S/4HANA 2020.
Techincal Settings of WCAHE
Below are technical details of the table WCAHE
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WCAHE Fields
The following table gives you an overview of the fields available in WCAHE
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| WCNR | Work Clearance Document | WCEWCNR | CHAR | 12 | |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| WCTYP | Type of WCM Object | WCETYP | CHAR | 1 | |
| WCUSE | Usage of WCM Object | WCEUSAGE | WCCU | CHAR | 3 |
| STXT | Descriptive Short Text | WCESTXT | CHAR | 40 | |
| LFLG | Long Text Exists | WCELTXTFLG | CHAR | 1 | |
| DELFLG | Delete | WCEDELFLG | CHAR | 1 | |
| UNTGFLG | Untagging Text Exists | WCEUNLTXTFLG | CHAR | 1 | |
| TGFLG | Tagging Text Exists | WCETGLTXTFLG | CHAR | 1 | |
| CATFLG1 | Catalog Exists | WCECATFLG | CHAR | 1 | |
| CATFLG2 | Catalog Exists | WCECATFLG | CHAR | 1 | |
| INGRP | Planner Group for Customer Service and Plant Maintenance | INGRP | T024I | CHAR | 3 |
| IWERK | Maintenance Planning Plant | IWERK | T399I | CHAR | 4 |
| WKCRTYP | Object types of the CIM resource | CR_OBJTY | CRID | CHAR | 2 |
| WKCRID | Object ID of the resource | CR_OBJID | CRID | NUMC | 8 |
| BEGRU | Technical object authorization group | IAUTG | T370B | CHAR | 4 |
| DATEFR | Valid-From Date for WCM Object | WCEDATEFR | DATS | 8 | |
| TIMEFR | Valid-From Time for WCM Object | WCETIMEFR | TIMS | 6 | |
| DATETO | Valid-To Date for WCM Object | WCEDATETO | DATS | 8 | |
| TIMETO | Valid-To Time for WCM Object | WCETIMETO | TIMS | 6 | |
| ANLZU | Overall Condition of Technical System | WCEANLZU | WCCG | CHAR | 2 |
| RCTIME | Recall Time | WCERECTIME | QUAN | 5 | |
| RCUNIT | Unit of Recall Time | WCERECUNIT | T006 | UNIT | 3 |
| PRIOK | Priority | PRIOK | T356 | CHAR | 1 |
| TPLNR | Functional Location | TPLNR | IFLOT | CHAR | 30 |
| EQUNR | Equipment Number | EQUNR | EQUI | CHAR | 18 |
| LNKFLG | Object List Exists | WCELNKFLG | CHAR | 1 | |
| TRAIN | Train | WCETRAIN | WCCH | CHAR | 3 |
| CRNAME | Created by | WCECRNAME | CHAR | 12 | |
| CRDATE | Date on Which the Object Was Created | WCECRDATE | DATS | 8 | |
| CRTIME | Time at Which Object was Created | WCECRTIME | TIMS | 6 | |
| CHNAME | Last Changed By | WCECHNAME | CHAR | 12 | |
| CHDATE | Date on Which Object was Last Changed | WCECHDATE | DATS | 8 | |
| CHTIME | Time at Which Object was Last Changed | WCECHTIME | TIMS | 6 | |
| PSPEL | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PRPS | NUMC | 8 |
| AUFNT | Number of superior network | CO_TEILNET | AUFK | CHAR | 12 |
| VORNR | Activity number replaced by sub-network | CN_VORNRT | CHAR | 4 | |
| BDATE | Basic start date | CO_GSTRP | DATS | 8 | |
| BTIME | Basic Start (Time) | CO_GSUZP | TIMS | 6 | |
| EDATE | Basic finish date | CO_GLTRP | DATS | 8 | |
| ETIME | Basic Finish (Time) | CO_GLUZP | TIMS | 6 | |
| TSDATE | Scheduled start | CO_GSTRS | DATS | 8 | |
| TSTIME | Scheduled Start (Time) | CO_GSUZS | TIMS | 6 | |
| TFDATE | Scheduled finish | CO_GLTRS | DATS | 8 | |
| TFTIME | Scheduled finish time | CO_GLUZS | TIMS | 6 | |
| ESDATE | Date | WCEDATE | DATS | 8 | |
| ESTIME | Time | WCETIME | TIMS | 6 | |
| EFDATE | Date | WCEDATE | DATS | 8 | |
| EFTIME | Time | WCETIME | TIMS | 6 | |
| LSDATE | Date | WCEDATE | DATS | 8 | |
| LSTIME | Time | WCETIME | TIMS | 6 | |
| LFDATE | Date | WCEDATE | DATS | 8 | |
| LFTIME | Time | WCETIME | TIMS | 6 | |
| PSDATE | Date | WCEDATE | DATS | 8 | |
| PSTIME | Time | WCETIME | TIMS | 6 | |
| PFDATE | Date | WCEDATE | DATS | 8 | |
| PFTIME | Time | WCETIME | TIMS | 6 | |
| ASDATE | Actual start date | CO_GSTRI | DATS | 8 | |
| ASTIME | Actual start time | CO_GSUZI | TIMS | 6 | |
| AFDATE | Actual finish date | CO_GLTRI | DATS | 8 | |
| AFTIME | Actual End Date (Time) | WCEAFTIME | TIMS | 6 | |
| ETAPE | Revision Phase | WCEETAPE | WCCF | CHAR | 20 |
| DOCFLG | Linked to Document | WCEDOCFLG | CHAR | 1 | |
| WCSTSMA | Status Profile | J_STSMA | TJ20 | CHAR | 8 |
| WCITMSTSMA | Status Profile | J_STSMA | TJ20 | CHAR | 8 |
| REFOBJ | Template (Object Number) | WCEREFOBJ | * | CHAR | 22 |
| REMARKFLG1 | Remarks (Maintenance) Exist | WCEREMARKFLG1 | CHAR | 1 | |
| REMARKFLG2 | Remarks (Operation) Exist | WCEREMARKFLG2 | CHAR | 1 | |
| WT_NO | Operation Card Number | TTSE_WT_NO | CHAR | 30 | |
| WT_DESC | Description of work ticket. | TTSE_WT_DESC | CHAR | 100 | |
| SHIFT_CHIEF | Shift Chief | TTSE_APPROVED_BY | CHAR | 10 | |
| GUARDIAN | Guardian for Operation Ticket | TTSE_MONITORED_BY | CHAR | 10 | |
| OPERATOR | Operator for Operation Ticket | TTSE_OPERATED_BY | CHAR | 10 | |
| ON_DUTY | On Duty Responsible for Operation Ticket | TTSE_VERIFIED_BY | CHAR | 10 | |
| START_DATE | Operation Ticket Start on | TTSE_DATE_START | DATS | 8 | |
| START_TIME | OT: Operation start time | TTSE_TIME_START | TIMS | 6 | |
| END_DATE | Operation Ticket End on | TTSE_DATE_END | DATS | 8 | |
| END_TIME | OT: Operation end time | TTSE_TIME_END | TIMS | 6 | |
| APPROVE_DATE | Operation Ticket Approved on | TTSE_APPROVE_DATE | DATS | 8 | |
| APPROVE_TIME | Approved time for OT | TTSE_APPROVE_TIME | TIMS | 6 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WCAHE
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WCAHE | ANLZU | : | WCCG |
| WCAHE | AUFNT | : | AUFK |
| WCAHE | BEGRU | : | T370B |
| WCAHE | EQUNR | : | EQUI |
| WCAHE | ETAPE | : | WCCF |
| WCAHE | INGRP | : | T024I |
| WCAHE | IWERK | : | T399I |
| WCAHE | MANDT | : | T000 |
| WCAHE | OBJNR | : | ONR00 |
| WCAHE | PRIOK | : | T356 |
| WCAHE | PSPEL | : | PRPS |
| WCAHE | RCUNIT | : | T006 |
| WCAHE | TPLNR | : | IFLOT |
| WCAHE | TRAIN | : | WCCH |
| WCAHE | WCITMSTSMA | : | TJ20 |
| WCAHE | WCSTSMA | : | TJ20 |
| WCAHE | WCUSE | : | WCCU |
| WCAHE | WKCRID | : | CRID |
| WCAHE | WKCRTYP | : | CRID |