SAP table WCCO (WCM: WCM Object)
SAP table WCCO has 4 primary key fields being MANDT,IWERK,OBJART,OBJTYP.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| IWERK | Maintenance Planning Plant | CHAR | 4 | 0 | T399I | IWERK | |
| OBJART | Object Type | CHAR | 2 | 0 | WCEOBJART | ||
| OBJTYP | Type of WCM Object | CHAR | 1 | 0 | WCETYP | ||
| CROBJFLG | Object can be Created | CHAR | 1 | 0 | WCECRFLG | ||
| CHOBJFLG | Object can be Changed | CHAR | 1 | 0 | WCECHFLG | ||
| ASGNFLG | Change Mode Restricted for Assigned Object | CHAR | 1 | 0 | WCEASGNFLG | ||
| DIRECTION | Direction According to Architecture | CHAR | 2 | 0 | WCEWAY | ||
| CRTCODE | Transaction Code for Creating Object | CHAR | 20 | 0 | TSTC | WCECRTCODE | |
| CHTCODE | Transaction Code for Changing Object | CHAR | 20 | 0 | TSTC | WCECHTCODE | |
| DPTCODE | Transaction Code for Displaying Object | CHAR | 20 | 0 | TSTC | WCEDPTCODE | |
| SETCODE | Transaction Code for Choosing an Object | CHAR | 20 | 0 | TSTC | WCESETCODE | |
| PRIOTYP | Priority Type | CHAR | 2 | 0 | T356A | ARTPR | |
| NR_OBJECT | Number Range Object | CHAR | 10 | 0 | TNRO | NROBJ | |
| INT_RANGE | Number Range for Internal Number Assignment | CHAR | 2 | 0 | WCEINT_RANGE | ||
| EXT_RANGE | Number Range for External Number Assignment | CHAR | 2 | 0 | WCEEXT_RANGE | ||
| PARGR | Partner Determination Procedure | CHAR | 4 | 0 | TVPG | PARGR | |
| STSMA | Status Profile | CHAR | 8 | 0 | TJ20 | J_STSMA | |
| CATTYP1 | Catalog | CHAR | 1 | 0 | TQ15 | QKATART | |
| CATLST1 | List Type | CHAR | 1 | 0 | WCECATLST | ||
| CATTYP2 | Catalog | CHAR | 1 | 0 | TQ15 | QKATART | |
| CATLST2 | List Type | CHAR | 1 | 0 | WCECATLST | ||
| CATPROFILE | Catalog Profile | CHAR | 9 | 0 | T352B | WCECATPROFILE | |
| BOR_OBJTYP | Object Type | CHAR | 10 | 0 | TOJTB | SWO_OBJTYP | |
| POPUPFLG | Display Dialog Box | CHAR | 1 | 0 | WCEDIALOGFLG | ||
| WCMUSE | Usage of WCM Object | CHAR | 3 | 0 | WCEUSAGE | ||
| REFBLSTGRP | Blocking Status Group for Creation with Template | CHAR | 5 | 0 | WCCTA | WCEREFBLSTGRP | |
| REFBLTLGRP | Blocking Approval Status Group for Creation with Template | CHAR | 5 | 0 | WCCTB | WCEREFBLTLGRP | |
| GENREFART | Template (Object Type) | CHAR | 2 | 0 | WCEGENREFART | ||
| GENREFTYP | Template (Subobject Type) | CHAR | 1 | 0 | WCEGENREFTYP |
WCCO foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 WCCO | BOR_OBJTYP | TOJTB | Business object repository: Basic data | NAME |
| 1 WCCO | CATPROFILE | T352B | Technical report | MANDT |
| 0 WCCO | CATTYP1 | TQ15 | Inspection catalog type index | KATALOGART |
| 1 WCCO | CATTYP2 | TQ15 | Inspection catalog type index | KATALOGART |
| 0 WCCO | CHTCODE | TSTC | SAP Transaction Codes | TCODE |
| 1 WCCO | CRTCODE | TSTC | SAP Transaction Codes | TCODE |
| 0 WCCO | DPTCODE | TSTC | SAP Transaction Codes | TCODE |
| 1 WCCO | IWERK | T399I | Planning plant parameters | MANDT |
| 0 WCCO | MANDT | T000 | Clients | MANDT |
| 1 WCCO | NR_OBJECT | TNRO | Definition of number range objects | OBJECT |
| 0 WCCO | PARGR | TVPG | Partner Function Groups | PARGR |
| 1 WCCO | PRIOTYP | T356A | Priority type table | MANDT |
| 1 WCCO | PRIOTYP | T356A | Priority type table | ARTPR |
| 0 WCCO | REFBLSTGRP | WCCTA | WCM: Grouping (Status) | MANDT |
| 0 WCCO | REFBLSTGRP | WCCTA | WCM: Grouping (Status) | STGRP |
| 0 WCCO | REFBLSTGRP | WCCTA | WCM: Grouping (Status) | STATUS |
| 1 WCCO | REFBLTLGRP | WCCTB | WCM: Grouping (Approval Status) | MANDT |
| 1 WCCO | REFBLTLGRP | WCCTB | WCM: Grouping (Approval Status) | TLGRP |
| 1 WCCO | REFBLTLGRP | WCCTB | WCM: Grouping (Approval Status) | TL |
| 0 WCCO | SETCODE | TSTC | SAP Transaction Codes | TCODE |
| 1 WCCO | STSMA | TJ20 | Status profiles | MANDT |
| 1 WCCO | STSMA | TJ20 | Status profiles | STSMA |