WCAHE SAP (WCM: Work Clearance Document (Header)) Table details
Dictionary Type: Table
Description: WCM: Work Clearance Document (Header)
Description: WCM: Work Clearance Document (Header)
Table field list including key, data, relationships and ABAP select examples
WCAHE is a standard SAP Table which is used to store WCM: Work Clearance Document (Header) data and is available within R/3 SAP systems depending on the version and release level.
The WCAHE table consists of various fields, each holding specific information or linking keys about WCM: Work Clearance Document (Header) data available in SAP. These include WCNR (Work Clearance Document), OBJNR (Object number), WCTYP (Type of WCM Object), WCUSE (Usage of WCM Object).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP WCAHE table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
WCNR | Work Clearance Document | WCEWCNR | CHAR | 12 | ALPHA | WCDNO | WC3 | WCMA | |
OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
WCTYP | Type of WCM Object | WCETYP | CHAR | 1 | WCDTYP | ||||
WCUSE | Usage of WCM Object | WCEUSAGE | CHAR | 3 | WCCU | WCDUSAGE | |||
STXT | Descriptive Short Text | WCESTXT | CHAR | 40 | TEXT40 | ||||
LFLG | Long Text Exists | WCELTXTFLG | CHAR | 1 | WCDFLG | ||||
DELFLG | Delete | WCEDELFLG | CHAR | 1 | WCDFLG | ||||
UNTGFLG | Untagging Text Exists | WCEUNLTXTFLG | CHAR | 1 | WCDFLG | ||||
TGFLG | Tagging Text Exists | WCETGLTXTFLG | CHAR | 1 | WCDFLG | ||||
CATFLG1 | Catalog Exists | WCECATFLG | CHAR | 1 | WCDFLG | ||||
CATFLG2 | Catalog Exists | WCECATFLG | CHAR | 1 | WCDFLG | ||||
INGRP | Planner Group for Customer Service and Plant Maintenance | INGRP | CHAR | 3 | T024I | INGRP | IHG | ||
IWERK | Maintenance Planning Plant | IWERK | CHAR | 4 | T399I | WERKS | IWK | ||
WKCRTYP | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CRID | CR_OBJTY | |||
WKCRID | Object ID of the resource | CR_OBJID | NUMC | 8 | CRID | CR_OBJID | |||
BEGRU | Technical object authorization group | IAUTG | CHAR | 4 | T370B | IAUTG | |||
DATEFR | Valid-From Date for WCM Object | WCEDATEFR | DATS | 8 | SYDATS | ||||
TIMEFR | Valid-From Time for WCM Object | WCETIMEFR | TIMS | 6 | SYTIME | ||||
DATETO | Valid-To Date for WCM Object | WCEDATETO | DATS | 8 | SYDATS | ||||
TIMETO | Valid-To Time for WCM Object | WCETIMETO | TIMS | 6 | SYTIME | ||||
ANLZU | Overall Condition of Technical System | WCEANLZU | CHAR | 2 | WCCG | CHAR2 | |||
RCTIME | Recall Time | WCERECTIME | QUAN | 5 | WCDRECTIME | ||||
RCUNIT | Unit of Recall Time | WCERECUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
PRIOK | Priority | PRIOK | CHAR | 1 | T356 | PRIOK | PRIOK | ||
TPLNR | Functional Location | TPLNR | CHAR | 30 | IFLOT | TPLNR | TPLNR | IFL | IFLM |
EQUNR | Equipment Number | EQUNR | CHAR | 18 | EQUI | ALPHA | EQUNR | EQN | EQUI |
LNKFLG | Object List Exists | WCELNKFLG | CHAR | 1 | WCDFLG | ||||
TRAIN | Train | WCETRAIN | CHAR | 3 | WCCH | CHAR3 | |||
CRNAME | Created by | WCECRNAME | CHAR | 12 | USNAM | ||||
CRDATE | Date on Which the Object Was Created | WCECRDATE | DATS | 8 | DATUM | ||||
CRTIME | Time at Which Object was Created | WCECRTIME | TIMS | 6 | UZEIT | ||||
CHNAME | Last Changed By | WCECHNAME | CHAR | 12 | USNAM | ||||
CHDATE | Date on Which Object was Last Changed | WCECHDATE | DATS | 8 | DATUM | ||||
CHTIME | Time at Which Object was Last Changed | WCECHTIME | TIMS | 6 | UZEIT | ||||
PSPEL | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
AUFNT | Number of superior network | CO_TEILNET | CHAR | 12 | AUFK | ALPHA | AUFNR | ||
VORNR | Activity number replaced by sub-network | CN_VORNRT | CHAR | 4 | NUMCV | VORNR | |||
BDATE | Basic start date | CO_GSTRP | DATS | 8 | DATUM | ||||
BTIME | Basic start time | CO_GSUZP | TIMS | 6 | UHRZT | ||||
EDATE | Basic finish date | CO_GLTRP | DATS | 8 | DATUM | ||||
ETIME | Basic finish (time) | CO_GLUZP | TIMS | 6 | UHRZT | ||||
TSDATE | Scheduled start | CO_GSTRS | DATS | 8 | DATUM | ||||
TSTIME | Scheduled Start (Time) | CO_GSUZS | TIMS | 6 | ATIME | ||||
TFDATE | Scheduled finish | CO_GLTRS | DATS | 8 | DATUM | ||||
TFTIME | Scheduled finish time | CO_GLUZS | TIMS | 6 | UHRZT | ||||
ESDATE | Date | WCEDATE | DATS | 8 | DATUM | ||||
ESTIME | Time | WCETIME | TIMS | 6 | UZEIT | ||||
EFDATE | Date | WCEDATE | DATS | 8 | DATUM | ||||
EFTIME | Time | WCETIME | TIMS | 6 | UZEIT | ||||
LSDATE | Date | WCEDATE | DATS | 8 | DATUM | ||||
LSTIME | Time | WCETIME | TIMS | 6 | UZEIT | ||||
LFDATE | Date | WCEDATE | DATS | 8 | DATUM | ||||
LFTIME | Time | WCETIME | TIMS | 6 | UZEIT | ||||
PSDATE | Date | WCEDATE | DATS | 8 | DATUM | ||||
PSTIME | Time | WCETIME | TIMS | 6 | UZEIT | ||||
PFDATE | Date | WCEDATE | DATS | 8 | DATUM | ||||
PFTIME | Time | WCETIME | TIMS | 6 | UZEIT | ||||
ASDATE | Actual start date | CO_GSTRI | DATS | 8 | DATUM | ||||
ASTIME | Actual start time | CO_GSUZI | TIMS | 6 | UHRZT | ||||
AFDATE | Actual finish date | CO_GLTRI | DATS | 8 | DATUM | ||||
AFTIME | Actual End Date (Time) | WCEAFTIME | TIMS | 6 | UZEIT | ||||
ETAPE | Revision Phase | WCEETAPE | CHAR | 20 | WCCF | CHAR20 | |||
DOCFLG | Linked to Document | WCEDOCFLG | CHAR | 1 | WCDFLG | ||||
WCSTSMA | Status Profile | J_STSMA | CHAR | 8 | TJ20 | J_STSMA | |||
WCITMSTSMA | Status Profile | J_STSMA | CHAR | 8 | TJ20 | J_STSMA | |||
REFOBJ | Template (Object Number) | WCEREFOBJ | CHAR | 22 | Assigned to domain | J_OBJNR | |||
REMARKFLG1 | Remarks (Maintenance) Exist | WCEREMARKFLG1 | CHAR | 1 | WCDFLG | ||||
REMARKFLG2 | Remarks (Operation) Exist | WCEREMARKFLG2 | CHAR | 1 | WCDFLG |
Key field | Non-key field |
How do I retrieve data from SAP table WCAHE using ABAP code
The following ABAP code Example will allow you to do a basic selection on WCAHE to SELECT all data from the tableDATA: WA_WCAHE TYPE WCAHE.
SELECT SINGLE *
FROM WCAHE
INTO CORRESPONDING FIELDS OF WA_WCAHE
WHERE...
How to access SAP table WCAHE
Within an ECC or HANA version of SAP you can also view further information about WCAHE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects