SAP WCAMI WCM: Log of Operational Lists (Items) Table
Overview
WCAMI is a standard SAP S/4HANA table that stores WCM: Log of Operational Lists (Items) data. There are total 52 fields in the WCAMI table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WCAMI 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 WCAMI to other SAP tables and standard CDS views available based on WCAMI table in S/4HANA 2020.
Techincal Settings of WCAMI
Below are technical details of the table WCAMI
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WCAMI Fields
The following table gives you an overview of the fields available in WCAMI
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| WCNR | Work Clearance Document | WCEWCNR | CHAR | 12 | |
| LSTID | Operational List | WCELSTID | NUMC | 6 | |
| WCITM | Item | WCEITM | NUMC | 6 | |
| OBJNR | Object number | J_OBJNR | * | 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 | |
| CCOBJNR | Object number | J_OBJNR | * | CHAR | 22 |
| STXT | Descriptive Short Text | WCESTXT | CHAR | 40 | |
| TGGRP | Operational Group | WCETGGRP | WCCA | CHAR | 1 |
| TGSTEP | Operational Step for Tagging | WCETGSTEP | 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 | 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 | |
| SYSST | Display lines for system status | ILOM_STTXS | CHAR | 40 | |
| USRST | Display lines for user status | ILOM_STTXU | CHAR | 40 | |
| ACTSTEP | Operational Step | WCEACTSTEP | CHAR | 3 | |
| ACTPROC | Operational Condition | WCEACTPROC | * | CHAR | 10 |
| ACTTYP | Operational Type | WCEACTTYP | CHAR | 3 | |
| DISPFLG | Display | WCEDISPFLG | CHAR | 1 | |
| UPDFLG | Change | WCEUPDFLG | CHAR | 1 | |
| CTRLFLG1 | Indicator | WCEFLG | CHAR | 1 | |
| CTRLFLG2 | Indicator | WCEFLG | CHAR | 1 | |
| CTRLFLG3 | Indicator | WCEFLG | CHAR | 1 | |
| STATUS | Status | WCESTATUS | CHAR | 1 | |
| STEP | Process Step | WCESTEP | CHAR | 1 | |
| FEEDBACK | Comment of the Technician On Site | WCEFEEDBACK | CHAR | 40 | |
| 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 WCAMI
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WCAMI | MANDT | : | T000 |
| WCAMI | PHBLTYP | : | WCCV |
| WCAMI | TGFORM | : | WCCL |
| WCAMI | TGGRP | : | WCCA |
| WCAMI | TGPROC | : | WCCA |
| WCAMI | TGTYP | : | WCCC |
| WCAMI | UNFORM | : | WCCL |
| WCAMI | UNPROC | : | WCCA |
| WCAMI | UNTYP | : | WCCC |