SAP Table WCACG
WCM: WCM Object <-> Catalog
WCACG (WCM: WCM Object <-> Catalog) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link WCACG to other SAP tables.
WCACG table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 | 0 | ||||||||
| COUNTER | Counter for differentiation 6-digit | I_COUNT | NUMC | 6 | 0 | |||||||||
| SFIELD | Object list sort field | OBSORT | CHAR | 20 | 0 | |||||||||
| CATTYP | Catalog | QKATART | TQ15 | CHAR | 1 | 0 | ||||||||
| CODEGRP | Code Group | QCODEGRP | QPGR | CHAR | 8 | 0 | ||||||||
| CODE | Code | QCODE | QPCD | CHAR | 4 | 0 | ||||||||
| STXT | Descriptive Short Text | WCESTXT | CHAR | 40 | 0 | |||||||||
| LTXTFLG | Long Text Exists | WCELTXTFLG | CHAR | 1 | 0 |
Possible values
|
||||||||
| CHKBOX | Checkbox | WCECHECKBOX | CHAR | 1 | 0 | |||||||||
| SIGN | Signature | WCESIGN | CHAR | 12 | 0 | |||||||||
| VAL | Valuation | WCEVAL | CHAR | 1 | 0 |
Possible values
|
||||||||
| CRNAME | Created by | WCECRNAME | CHAR | 12 | 0 | |||||||||
| CRDATE | Date on Which the Object Was Created | WCECRDATE | DATS | 8 | 0 | |||||||||
| CRTIME | Time at Which Object was Created | WCECRTIME | TIMS | 6 | 0 | |||||||||
WCACG foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| WCACG | CATTYP | WCACG | MANDT | TQ15 | Inspection catalog type index | MANDT |
| WCACG | CATTYP | WCACG | CATTYP | TQ15 | Inspection catalog type index | KATALOGART |
| WCACG | CODE | * | QPCD | Inspection catalog codes | VERSION | |
| WCACG | CODE | WCACG | MANDT | QPCD | Inspection catalog codes | MANDT |
| WCACG | CODE | WCACG | CATTYP | QPCD | Inspection catalog codes | KATALOGART |
| WCACG | CODE | WCACG | CODEGRP | QPCD | Inspection catalog codes | CODEGRUPPE |
| WCACG | CODE | WCACG | CODE | QPCD | Inspection catalog codes | CODE |
| WCACG | CODEGRP | WCACG | MANDT | QPGR | Inspection catalog code groups | MANDT |
| WCACG | CODEGRP | WCACG | CATTYP | QPGR | Inspection catalog code groups | KATALOGART |
| WCACG | CODEGRP | WCACG | CODEGRP | QPGR | Inspection catalog code groups | CODEGRUPPE |
| WCACG | MANDT | WCACG | MANDT | T000 | Clients | MANDT |
| WCACG | OBJNR | WCACG | MANDT | ONR00 | General Object Number | MANDT |
| WCACG | OBJNR | WCACG | OBJNR | ONR00 | General Object Number | OBJNR |
