SAP WCAAP WCM: Application Table
Overview
WCAAP is a standard SAP S/4HANA table that stores WCM: Application data. There are total 127 fields in the WCAAP table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WCAAP 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 WCAAP to other SAP tables and standard CDS views available based on WCAAP table in S/4HANA 2020.
Techincal Settings of WCAAP
Below are technical details of the table WCAAP
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WCAAP Fields
The following table gives you an overview of the fields available in WCAAP
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| WAPINR | Application | WCEWAPINR | CHAR | 12 | |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| WAPITYP | Type of WCM Object | WCETYP | CHAR | 1 | |
| WAPIUSE | Usage of WCM Object | WCEUSAGE | WCCY | 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 | |
| EXTPERIOD | Total Extension of Validity in Hours | WCEEXTTOTPERIOD | INT4 | 10 | |
| 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 | |
| WAPISTSMA | 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 | |
| IDATE | Issued | TTSE_ISDATE | DATS | 8 | |
| ITIME | Issue Time | TTSE_ISTIME | TIMS | 6 | |
| RDATE | Received | TTSE_RCDATE | DATS | 8 | |
| RTIME | Receive Time | TTSE_RCTIME | TIMS | 6 | |
| PDATES | Permit Start | TTSE_PEDATE | DATS | 8 | |
| PTIMES | Permit Start Time | TTSE_PETIME | TIMS | 6 | |
| PDATEE | Permit End | TTSE_PEDATE_E | DATS | 8 | |
| PTIMEE | Permit End Time | TTSE_PETIME_E | TIMS | 6 | |
| CDATE | Completed | TTSE_CMDATE | DATS | 8 | |
| CTIME | Complete Time | TTSE_CMTIME | TIMS | 6 | |
| PLDATES | Planned Start | TTSE_PLDATE | DATS | 8 | |
| PLTIMES | Plan Start Time | TTSE_PLTIME | TIMS | 6 | |
| PLDATEE | Planned End | TTSE_PLDATE_E | DATS | 8 | |
| PLTIMEE | Plan End Time | TTSE_PLTIME_E | TIMS | 6 | |
| POWER_OFF | Power off status | TTSE_POWER_OFF | CHAR | 1 | |
| NEWRESP | Change Work Responsible | TTSE_NEWRESP | CHAR | 10 | |
| ISSUEDBY | Work Ticket Issuer | TTSE_ISSUEDBY | CHAR | 10 | |
| RCHGDATE | Change Approved on | TTSE_RCHGDATE | DATS | 8 | |
| RCHGTIME | issue time | TTSE_RCHGTIME | TIMS | 6 | |
| PTDATE | Extension Date and Time | TTSE_PTDATE | DATS | 8 | |
| PTTIME | Work Ticket Extended totime(extension) | TTSE_PTTIME | TIMS | 6 | |
| EXTRESP | Work Responsible | TTSE_EXTRESP | CHAR | 10 | |
| PERRESP | Work Permit Responsible | TTSE_PERRESP | CHAR | 10 | |
| PRESP | Work Permit Responsible | TTSE_PRESP | CHAR | 10 | |
| PRDATE | Change Approved on | TTSE_PRDATE | DATS | 8 | |
| PREDATE | Extension Approved on | TTSE_PREDATE | DATS | 8 | |
| PRTIME | WT Permit Resp. Time | TTSE_PRTIME | TIMS | 6 | |
| PRETIME | WT Permit Resp. Time(extension) | TTSE_PRETIME | TIMS | 6 | |
| EXTRTIME | WT Resp. Time(extension) | TTSE_EXTTIME | TIMS | 6 | |
| EXTRDATE | Extension Approved on | TTSE_EXTDATE | DATS | 8 | |
| SHTCHF | Shift Chief | TTSE_SHTCHF | CHAR | 10 | |
| SHCDATE | Extension Approved on | TTSE_SHCDATE | DATS | 8 | |
| SHCTIME | Shift Chief Time(extension) | TTSE_SHCTIME | TIMS | 6 | |
| SHIFT | Crew ID | TTSE_SFTN | CHAR | 20 | |
| PERSONNEL_NO | Work Responsible | TTSE_PERSONNEL | CHAR | 10 | |
| TTS_FLAG | Include Work Responsible | TTSE_FLAG | CHAR | 1 | |
| THERM_APPR1 | Thermal Control Work Ticket's Approver | TTSE_THERM_APPR1 | CHAR | 12 | |
| THERM_EXEC1 | Thermal Control Work Ticket's Protection disabled Executor | TTSE_THERM_EXEC1 | CHAR | 12 | |
| THERM_EXEC2 | Thermal Control Measure Executor | TTSE_THERM_EXEC2 | CHAR | 12 | |
| THERM_EXEC3 | Operation Measure Executor | TTSE_THERM_EXEC3 | CHAR | 12 | |
| THERM_STDATE | Date | DATUM | DATS | 8 | |
| THERM_STTIME | Time | UZEIT | TIMS | 6 | |
| THERM_OP_SPRV | Thermal Control Work Ticket's Operation Supervisor | TTSS_THERM_SUPE | CHAR | 12 | |
| THERM_WORK_RESP | Thermal Control Work Ticket's Work Responsible | TTSS_THERM_RESP | CHAR | 12 | |
| THERM_WORK_PERRESP | Thermal Control Work Ticket's Work Permit Responsible | TTSS_THERM_PERM | CHAR | 12 | |
| PLANT_SIGN_WT7 | Plant Supervisor | TTSE_HOT_RESP1 | CHAR | 12 | |
| SECU_SIGN_WT7 | Security Officer | TTSE_HOT_RESP2 | CHAR | 12 | |
| FIRE_SIGN_WT7 | Fire Protection Officer | TTSE_HOT_RESP3 | CHAR | 12 | |
| FIRE_MSR_WT7 | Fire Protection Guardian | TTSE_HOT_GRD1 | CHAR | 12 | |
| PLANT_BGN_WT7 | Plant Supervisor | TTSE_HOT_RESP1 | CHAR | 12 | |
| SECU_BGN_WT7 | Security Officer | TTSE_HOT_RESP2 | CHAR | 12 | |
| FIRE_BGN_WT7 | Fire Protection Officer | TTSE_HOT_RESP3 | CHAR | 12 | |
| EXEC_BGN_WT7 | Hot Work Ticket's Executor | TTSE_HOT_EXEC | CHAR | 12 | |
| FIRE_END_WT7 | Fire Protection Guardian | TTSE_HOT_GRD1 | CHAR | 12 | |
| EXEC_END_WT7 | Hot Work Ticket's Executor | TTSE_HOT_EXEC | CHAR | 12 | |
| LOC_MSR_WT7 | Measurement Location | TTSE_HOT_LOC | CHAR | 30 | |
| EQUIP_MSR_WT7 | Measurement Equipment | TTSE_HOT_EQUIP | CHAR | 30 | |
| ITEM_MSR_WT7 | Measurement Item | TTSE_HOT_ITEM | CHAR | 30 | |
| ZP_WAPINR | Application | WCEWAPINR | CHAR | 12 |
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 WCAAP
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WCAAP | ANLZU | : | WCCG |
| WCAAP | AUFNT | : | AUFK |
| WCAAP | BEGRU | : | T370B |
| WCAAP | EQUNR | : | EQUI |
| WCAAP | ETAPE | : | WCCF |
| WCAAP | INGRP | : | T024I |
| WCAAP | IWERK | : | T399I |
| WCAAP | MANDT | : | T000 |
| WCAAP | OBJNR | : | ONR00 |
| WCAAP | PRIOK | : | T356 |
| WCAAP | PSPEL | : | PRPS |
| WCAAP | RCUNIT | : | T006 |
| WCAAP | TPLNR | : | IFLOT |
| WCAAP | TRAIN | : | WCCH |
| WCAAP | WAPISTSMA | : | TJ20 |
| WCAAP | WAPIUSE | : | WCCY |
| WCAAP | WKCRID | : | CRID |
| WCAAP | WKCRTYP | : | CRID |