SAP WCAIT WCM: Work Clearance Document (Item) Table
Overview
WCAIT is a standard SAP S/4HANA table that stores WCM: Work Clearance Document (Item) data. There are total 35 fields in the WCAIT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WCAIT 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 WCAIT to other SAP tables and standard CDS views available based on WCAIT table in S/4HANA 2020.
Techincal Settings of WCAIT
Below are technical details of the table WCAIT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WCAIT Fields
The following table gives you an overview of the fields available in WCAIT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| WCNR | Work Clearance Document | WCEWCNR | WCAHE | CHAR | 12 |
| WCITM | Item | WCEITM | NUMC | 6 | |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| ITMTYP | Item Category | WCEITMTYP | CHAR | 1 | |
| SEQ | Item | WCEITMSEQ | NUMC | 6 | |
| PRED | Predecessor | WCEPREDITM | NUMC | 6 | |
| SUCC | Successor | WCESUCCITM | NUMC | 6 | |
| CCOBJ | Technical Object | WCECCOBJ | CHAR | 40 | |
| CCTYP | Item Category | WCECCTYP | CHAR | 1 | |
| STXT | Descriptive Short Text | WCESTXT | CHAR | 40 | |
| TGGRP | Operational Group | WCETGGRP | WCCA | CHAR | 1 |
| TGSTEP | Operational Step for Tagging | WCETGSTEP | WCCMS | CHAR | 3 |
| TGPROC | Tagging Condition | WCETGPROC | WCCA | CHAR | 10 |
| TGTYP | Tagging Type | WCETGTYP | WCCC | CHAR | 3 |
| TGSEQ | Sequence for Tagging | WCETGSEQ | NUMC | 5 | |
| TGTXT | Comment Line for Tagging | WCETGCOMMENT | CHAR | 40 | |
| UNSTEP | Operational Step for Untagging | WCEUNSTEP | WCCMS | CHAR | 3 |
| UNPROC | Untagging Condition | WCEUNPROC | WCCA | CHAR | 10 |
| UNTYP | Untagging Type | WCEUNTYP | WCCC | CHAR | 3 |
| UNSEQ | Sequence for Untagging | WCEUNSEQ | NUMC | 5 | |
| UNTXT | Comment Line for Untagging | WCEUNCOMMENT | CHAR | 40 | |
| PHBLFLG | Physical Blocking Required | WCEPHBLFLG | CHAR | 1 | |
| PHBLTYP | Physical Blocking Type | WCEPHBLTYP | WCCV | CHAR | 1 |
| PHBLNR | Lock | WCEPHBLNR | CHAR | 5 | |
| TGFLG | Tag Required | WCETAGFLG | CHAR | 1 | |
| TGFORM | Print Format for Tag | WCETGFORM | WCCL | CHAR | 4 |
| TGNR | Tag | WCETGNR | CHAR | 12 | |
| UNFORM | Print Format for Test Tag | WCEUNFORM | WCCL | CHAR | 4 |
| UNNR | Test Tag | WCEUNNR | CHAR | 12 | |
| CONTROL | Switching Location | WCECTRL | CHAR | 40 | |
| LOCATION | Location | WCELOC | CHAR | 40 | |
| LFLG | Long Text Exists | WCELTXTFLG | CHAR | 1 | |
| DOCFLG | Linked to Document | WCEDOCFLG | CHAR | 1 | |
| REFOBJ | Template (Object Number) | WCEREFOBJ | * | CHAR | 22 |
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 WCAIT
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WCAIT | MANDT | : | T000 |
| WCAIT | OBJNR | : | ONR00 |
| WCAIT | PHBLTYP | : | WCCV |
| WCAIT | TGFORM | : | WCCL |
| WCAIT | TGGRP | : | WCCA |
| WCAIT | TGPROC | : | WCCA |
| WCAIT | TGSTEP | : | WCCMS |
| WCAIT | TGTYP | : | WCCC |
| WCAIT | UNFORM | : | WCCL |
| WCAIT | UNPROC | : | WCCA |
| WCAIT | UNSTEP | : | WCCMS |
| WCAIT | UNTYP | : | WCCC |
| WCAIT | WCNR | : | WCAHE |