SAP WCAW WCM: Work Approval Table
Overview
WCAW is a standard SAP S/4HANA table that stores WCM: Work Approval data. There are total 66 fields in the WCAW table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WCAW 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 WCAW to other SAP tables and standard CDS views available based on WCAW table in S/4HANA 2020.
Techincal Settings of WCAW
Below are technical details of the table WCAW
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WCAW Fields
The following table gives you an overview of the fields available in WCAW
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| WAPNR | Work Approval | WCEWAPNR | CHAR | 12 | |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| WAPUSE | Usage of WCM Object | WCEUSAGE | WCCX | CHAR | 3 |
| STXT | Descriptive Short Text | WCESTXT | CHAR | 40 | |
| LFLG | Long Text Exists | WCELTXTFLG | CHAR | 1 | |
| DELFLG | Delete | WCEDELFLG | CHAR | 1 | |
| REQUALFLG | Requalification Text Exists | WCEREQULTXTFLG | 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 | |
| WAPSTSMA | 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 |
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 WCAW
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WCAW | ANLZU | : | WCCG |
| WCAW | AUFNT | : | AUFK |
| WCAW | BEGRU | : | T370B |
| WCAW | EQUNR | : | EQUI |
| WCAW | ETAPE | : | WCCF |
| WCAW | INGRP | : | T024I |
| WCAW | IWERK | : | T399I |
| WCAW | MANDT | : | T000 |
| WCAW | OBJNR | : | ONR00 |
| WCAW | PRIOK | : | T356 |
| WCAW | PSPEL | : | PRPS |
| WCAW | RCUNIT | : | T006 |
| WCAW | TPLNR | : | IFLOT |
| WCAW | TRAIN | : | WCCH |
| WCAW | WAPSTSMA | : | TJ20 |
| WCAW | WAPUSE | : | WCCX |
| WCAW | WKCRID | : | CRID |
| WCAW | WKCRTYP | : | CRID |