SAP WCACGQ WCM: Log (WCM Object <-> Catalog) Table
Overview
WCACGQ is a standard SAP S/4HANA table that stores WCM: Log (WCM Object <-> Catalog) data. There are total 20 fields in the WCACGQ table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WCACGQ 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 WCACGQ to other SAP tables and standard CDS views available based on WCACGQ table in S/4HANA 2020.
Techincal Settings of WCACGQ
Below are technical details of the table WCACGQ
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WCACGQ Fields
The following table gives you an overview of the fields available in WCACGQ
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| COUNTER | Counter for differentiation 6-digit | I_COUNT | NUMC | 6 | |
| CNT | Counter for differentiation 6-digit | I_COUNT | NUMC | 6 | |
| SFIELD | Object list sort field | OBSORT | CHAR | 20 | |
| CATTYP | Catalog | QKATART | TQ15 | CHAR | 1 |
| CODEGRP | Code Group | QCODEGRP | QPGR | CHAR | 8 |
| CODE | Code | QCODE | QPCD | CHAR | 4 |
| STXT | Descriptive Short Text | WCESTXT | CHAR | 40 | |
| LTXTFLG | Long Text Exists | WCELTXTFLG | CHAR | 1 | |
| CHKBOX | Checkbox | WCECHECKBOX | CHAR | 1 | |
| SIGN | Signature | WCESIGN | * | CHAR | 12 |
| VAL | Valuation | WCEVAL | CHAR | 1 | |
| 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 | |
| ACTION | Database Action | WCEACTION | CHAR | 1 |
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 WCACGQ
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WCACGQ | CATTYP | : | TQ15 |
| WCACGQ | CODE | : | QPCD |
| WCACGQ | CODEGRP | : | QPGR |
| WCACGQ | MANDT | : | T000 |
| WCACGQ | OBJNR | : | ONR00 |