SAP WCAJ WCM: Lineup Table
Overview
WCAJ is a standard SAP S/4HANA table that stores WCM: Lineup data. There are total 32 fields in the WCAJ table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WCAJ 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 WCAJ to other SAP tables and standard CDS views available based on WCAJ table in S/4HANA 2020.
Techincal Settings of WCAJ
Below are technical details of the table WCAJ
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WCAJ Fields
The following table gives you an overview of the fields available in WCAJ
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| LUNR | Lineup | WCELUNR | CHAR | 12 | |
| OBJNR | Object number | J_OBJNR | * | CHAR | 22 |
| STXT | Descriptive Short Text | WCESTXT | CHAR | 40 | |
| LUTYP | Lineup Type | WCELUTYP | CHAR | 1 | |
| LUUSE | Lineup Usage | WCELUUSE | CHAR | 3 | |
| IWERK | Maintenance Planning Plant | IWERK | T399I | CHAR | 4 |
| INGRP | Planner Group for Customer Service and Plant Maintenance | INGRP | T024I | CHAR | 3 |
| WKCRTYP | Object types of the CIM resource | CR_OBJTY | CRID | CHAR | 2 |
| WKCRID | Object ID of the resource | CR_OBJID | CRID | NUMC | 8 |
| BEGRU | Authorization Group in Work Clearance Management | WCEBEGRU | T370B | CHAR | 4 |
| ANLZU | Overall Condition of Technical System | WCEANLZU | WCCG | CHAR | 2 |
| TGGRP | Operational Group | WCETGGRP | CHAR | 1 | |
| TPLNR | Functional Location | TPLNR | IFLOT | CHAR | 30 |
| EQUNR | Equipment Number | EQUNR | EQUI | CHAR | 18 |
| TRAIN | Train | WCETRAIN | WCCH | CHAR | 3 |
| LUPVERLVL | Number of Required Checks | WCELUPVERLVL | NUMC | 2 | |
| LUCVERLVL | Number of Current Check | WCELUCVERLVL | NUMC | 2 | |
| LFLG | Long Text Exists | WCELTXTFLG | CHAR | 1 | |
| REJCFLG | Rejection Exists | WCEREJCLTXTFLG | CHAR | 1 | |
| DELFLG | Delete | WCEDELFLG | CHAR | 1 | |
| REFOBJ | Template (Object Number) | WCEREFOBJ | * | CHAR | 22 |
| 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 | |
| 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 |
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 WCAJ
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WCAJ | ANLZU | : | WCCG |
| WCAJ | BEGRU | : | T370B |
| WCAJ | EQUNR | : | EQUI |
| WCAJ | INGRP | : | T024I |
| WCAJ | IWERK | : | T399I |
| WCAJ | TPLNR | : | IFLOT |
| WCAJ | TRAIN | : | WCCH |
| WCAJ | WKCRID | : | CRID |
| WCAJ | WKCRTYP | : | CRID |