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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
WAPINRApplicationWCEWAPINRCHAR12
OBJNRObject numberJ_OBJNRONR00CHAR22
WAPITYPType of WCM ObjectWCETYPCHAR1
WAPIUSEUsage of WCM ObjectWCEUSAGEWCCYCHAR3
STXTDescriptive Short TextWCESTXTCHAR40
LFLGLong Text ExistsWCELTXTFLGCHAR1
DELFLGDeleteWCEDELFLGCHAR1
REQUALFLGRequalification Text ExistsWCEREQULTXTFLGCHAR1
CATFLG1Catalog ExistsWCECATFLGCHAR1
CATFLG2Catalog ExistsWCECATFLGCHAR1
INGRPPlanner Group for Customer Service and Plant MaintenanceINGRPT024ICHAR3
IWERKMaintenance Planning PlantIWERKT399ICHAR4
WKCRTYPObject types of the CIM resourceCR_OBJTYCRIDCHAR2
WKCRIDObject ID of the resourceCR_OBJIDCRIDNUMC8
BEGRUTechnical object authorization groupIAUTGT370BCHAR4
DATEFRValid-From Date for WCM ObjectWCEDATEFRDATS8
TIMEFRValid-From Time for WCM ObjectWCETIMEFRTIMS6
DATETOValid-To Date for WCM ObjectWCEDATETODATS8
TIMETOValid-To Time for WCM ObjectWCETIMETOTIMS6
EXTPERIODTotal Extension of Validity in HoursWCEEXTTOTPERIODINT410
ANLZUOverall Condition of Technical SystemWCEANLZUWCCGCHAR2
RCTIMERecall TimeWCERECTIMEQUAN5
RCUNITUnit of Recall TimeWCERECUNITT006UNIT3
PRIOKPriorityPRIOKT356CHAR1
TPLNRFunctional LocationTPLNRIFLOTCHAR30
EQUNREquipment NumberEQUNREQUICHAR18
LNKFLGObject List ExistsWCELNKFLGCHAR1
TRAINTrainWCETRAINWCCHCHAR3
CRNAMECreated byWCECRNAMECHAR12
CRDATEDate on Which the Object Was CreatedWCECRDATEDATS8
CRTIMETime at Which Object was CreatedWCECRTIMETIMS6
CHNAMELast Changed ByWCECHNAMECHAR12
CHDATEDate on Which Object was Last ChangedWCECHDATEDATS8
CHTIMETime at Which Object was Last ChangedWCECHTIMETIMS6
PSPELWork Breakdown Structure Element (WBS Element)PS_PSP_PNRPRPSNUMC8
AUFNTNumber of superior networkCO_TEILNETAUFKCHAR12
VORNRActivity number replaced by sub-networkCN_VORNRTCHAR4
BDATEBasic start dateCO_GSTRPDATS8
BTIMEBasic Start (Time)CO_GSUZPTIMS6
EDATEBasic finish dateCO_GLTRPDATS8
ETIMEBasic Finish (Time)CO_GLUZPTIMS6
TSDATEScheduled startCO_GSTRSDATS8
TSTIMEScheduled Start (Time)CO_GSUZSTIMS6
TFDATEScheduled finishCO_GLTRSDATS8
TFTIMEScheduled finish timeCO_GLUZSTIMS6
ESDATEDateWCEDATEDATS8
ESTIMETimeWCETIMETIMS6
EFDATEDateWCEDATEDATS8
EFTIMETimeWCETIMETIMS6
LSDATEDateWCEDATEDATS8
LSTIMETimeWCETIMETIMS6
LFDATEDateWCEDATEDATS8
LFTIMETimeWCETIMETIMS6
PSDATEDateWCEDATEDATS8
PSTIMETimeWCETIMETIMS6
PFDATEDateWCEDATEDATS8
PFTIMETimeWCETIMETIMS6
ASDATEActual start dateCO_GSTRIDATS8
ASTIMEActual start timeCO_GSUZITIMS6
AFDATEActual finish dateCO_GLTRIDATS8
AFTIMEActual End Date (Time)WCEAFTIMETIMS6
ETAPERevision PhaseWCEETAPEWCCFCHAR20
DOCFLGLinked to DocumentWCEDOCFLGCHAR1
WAPISTSMAStatus ProfileJ_STSMATJ20CHAR8
REFOBJTemplate (Object Number)WCEREFOBJ*CHAR22
REMARKFLG1Remarks (Maintenance) ExistWCEREMARKFLG1CHAR1
REMARKFLG2Remarks (Operation) ExistWCEREMARKFLG2CHAR1
IDATEIssuedTTSE_ISDATEDATS8
ITIMEIssue TimeTTSE_ISTIMETIMS6
RDATEReceivedTTSE_RCDATEDATS8
RTIMEReceive TimeTTSE_RCTIMETIMS6
PDATESPermit StartTTSE_PEDATEDATS8
PTIMESPermit Start TimeTTSE_PETIMETIMS6
PDATEEPermit EndTTSE_PEDATE_EDATS8
PTIMEEPermit End TimeTTSE_PETIME_ETIMS6
CDATECompletedTTSE_CMDATEDATS8
CTIMEComplete TimeTTSE_CMTIMETIMS6
PLDATESPlanned StartTTSE_PLDATEDATS8
PLTIMESPlan Start TimeTTSE_PLTIMETIMS6
PLDATEEPlanned EndTTSE_PLDATE_EDATS8
PLTIMEEPlan End TimeTTSE_PLTIME_ETIMS6
POWER_OFFPower off statusTTSE_POWER_OFFCHAR1
NEWRESPChange Work ResponsibleTTSE_NEWRESPCHAR10
ISSUEDBYWork Ticket IssuerTTSE_ISSUEDBYCHAR10
RCHGDATEChange Approved onTTSE_RCHGDATEDATS8
RCHGTIMEissue timeTTSE_RCHGTIMETIMS6
PTDATEExtension Date and TimeTTSE_PTDATEDATS8
PTTIMEWork Ticket Extended totime(extension)TTSE_PTTIMETIMS6
EXTRESPWork ResponsibleTTSE_EXTRESPCHAR10
PERRESPWork Permit ResponsibleTTSE_PERRESPCHAR10
PRESPWork Permit ResponsibleTTSE_PRESPCHAR10
PRDATEChange Approved onTTSE_PRDATEDATS8
PREDATEExtension Approved onTTSE_PREDATEDATS8
PRTIMEWT Permit Resp. TimeTTSE_PRTIMETIMS6
PRETIMEWT Permit Resp. Time(extension)TTSE_PRETIMETIMS6
EXTRTIMEWT Resp. Time(extension)TTSE_EXTTIMETIMS6
EXTRDATEExtension Approved onTTSE_EXTDATEDATS8
SHTCHFShift ChiefTTSE_SHTCHFCHAR10
SHCDATEExtension Approved onTTSE_SHCDATEDATS8
SHCTIMEShift Chief Time(extension)TTSE_SHCTIMETIMS6
SHIFTCrew IDTTSE_SFTNCHAR20
PERSONNEL_NOWork ResponsibleTTSE_PERSONNELCHAR10
TTS_FLAGInclude Work ResponsibleTTSE_FLAGCHAR1
THERM_APPR1Thermal Control Work Ticket's ApproverTTSE_THERM_APPR1CHAR12
THERM_EXEC1Thermal Control Work Ticket's Protection disabled ExecutorTTSE_THERM_EXEC1CHAR12
THERM_EXEC2Thermal Control Measure ExecutorTTSE_THERM_EXEC2CHAR12
THERM_EXEC3Operation Measure ExecutorTTSE_THERM_EXEC3CHAR12
THERM_STDATEDateDATUMDATS8
THERM_STTIMETimeUZEITTIMS6
THERM_OP_SPRVThermal Control Work Ticket's Operation SupervisorTTSS_THERM_SUPECHAR12
THERM_WORK_RESPThermal Control Work Ticket's Work ResponsibleTTSS_THERM_RESPCHAR12
THERM_WORK_PERRESPThermal Control Work Ticket's Work Permit ResponsibleTTSS_THERM_PERMCHAR12
PLANT_SIGN_WT7Plant SupervisorTTSE_HOT_RESP1CHAR12
SECU_SIGN_WT7Security OfficerTTSE_HOT_RESP2CHAR12
FIRE_SIGN_WT7Fire Protection OfficerTTSE_HOT_RESP3CHAR12
FIRE_MSR_WT7Fire Protection GuardianTTSE_HOT_GRD1CHAR12
PLANT_BGN_WT7Plant SupervisorTTSE_HOT_RESP1CHAR12
SECU_BGN_WT7Security OfficerTTSE_HOT_RESP2CHAR12
FIRE_BGN_WT7Fire Protection OfficerTTSE_HOT_RESP3CHAR12
EXEC_BGN_WT7Hot Work Ticket's ExecutorTTSE_HOT_EXECCHAR12
FIRE_END_WT7Fire Protection GuardianTTSE_HOT_GRD1CHAR12
EXEC_END_WT7Hot Work Ticket's ExecutorTTSE_HOT_EXECCHAR12
LOC_MSR_WT7Measurement LocationTTSE_HOT_LOCCHAR30
EQUIP_MSR_WT7Measurement EquipmentTTSE_HOT_EQUIPCHAR30
ITEM_MSR_WT7Measurement ItemTTSE_HOT_ITEMCHAR30
ZP_WAPINRApplicationWCEWAPINRCHAR12

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 NameFieldCardinalityCheck Table
WCAAPANLZU:WCCG
WCAAPAUFNT:AUFK
WCAAPBEGRU:T370B
WCAAPEQUNR:EQUI
WCAAPETAPE:WCCF
WCAAPINGRP:T024I
WCAAPIWERK:T399I
WCAAPMANDT:T000
WCAAPOBJNR:ONR00
WCAAPPRIOK:T356
WCAAPPSPEL:PRPS
WCAAPRCUNIT:T006
WCAAPTPLNR:IFLOT
WCAAPTRAIN:WCCH
WCAAPWAPISTSMA:TJ20
WCAAPWAPIUSE:WCCY
WCAAPWKCRID:CRID
WCAAPWKCRTYP:CRID

Other References