SAP table WCCP (WCM: WCM Object <-> Approvals)
SAP table WCCP has 5 primary key fields being MANDT,IWERK,OBJART,OBJTYP,PMSOG.
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 | WCCO | WCEOBJART | |
| OBJTYP | Type of WCM Object | CHAR | 1 | 0 | WCCO | WCETYP | |
| PMSOG | Permit Key | CHAR | 10 | 0 | T357G | PMSOG | |
| HILVL | Hierarchy Level | INT1 | 3 | 0 | WCEHILVL | ||
| PROCFLG | Approval is Relevant to Process | CHAR | 1 | 0 | WCEPROCFLG | ||
| DIRECTION | Direction According to Architecture | CHAR | 2 | 0 | WCEWAY | ||
| COPYFLG | Copy Approval Automatically | CHAR | 1 | 0 | WCEFLGCOPY | ||
| MANDFLG | Approval is Mandatory | CHAR | 1 | 0 | WCEFLGMAND | ||
| DEACFLG | Revoke Approval Automatically | CHAR | 1 | 0 | WCEFLGDEAC | ||
| TLFLG | Display Approval Status as Traffic Light | CHAR | 1 | 0 | WCEFLGTL | ||
| STATUS | Controlled System Status for Issuing Approvals | CHAR | 5 | 0 | WCESTAT | ||
| ASGNFLG | Assignment Required | CHAR | 1 | 0 | WCEFLGASGN | ||
| AUTOFLG | Issue Approvals Automatically | CHAR | 1 | 0 | WCEFLGAUTO | ||
| AGENT | Agent | CHAR | 14 | 0 | SWP_AGENT | ||
| USER_STATUS | Controlled User Status for Issuing Approval | CHAR | 5 | 0 | TJ30 | WCEBLUSRST | |
| REJSTGRP | Status Group for Revoking Approvals | CHAR | 5 | 0 | WCCTA | WCEREJSTGRP | |
| TOCOPYFLG | Copy Approvals Automatically from Reference Object | CHAR | 1 | 0 | WCETOCOPYFLG | ||
| VALFLG | Validity Required | CHAR | 1 | 0 | WCEBLVALFLG | ||
| WCMUSE | Usage of WCM Object | CHAR | 3 | 0 | WCEUSAGE | ||
| USECTRL | Usage Type | CHAR | 1 | 0 | WCEUSECTRL |
WCCP foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 WCCP | IWERK | T399I | Planning plant parameters | MANDT |
| 1 WCCP | MANDT | T000 | Clients | MANDT |
| 0 WCCP | OBJART | WCCO | WCM: WCM Object | MANDT |
| 0 WCCP | OBJART | WCCO | WCM: WCM Object | OBJART |
| 0 WCCP | OBJART | WCCO | WCM: WCM Object | OBJTYP |
| 1 WCCP | OBJTYP | WCCO | WCM: WCM Object | MANDT |
| 1 WCCP | OBJTYP | WCCO | WCM: WCM Object | OBJART |
| 1 WCCP | OBJTYP | WCCO | WCM: WCM Object | OBJTYP |
| 0 WCCP | PMSOG | T357G | Permits | MANDT |
| 0 WCCP | PMSOG | T357G | Permits | SOGEN |
| 1 WCCP | REJSTGRP | WCCTA | WCM: Grouping (Status) | MANDT |
| 1 WCCP | REJSTGRP | WCCTA | WCM: Grouping (Status) | STGRP |
| 1 WCCP | REJSTGRP | WCCTA | WCM: Grouping (Status) | STATUS |
| 0 WCCP | USER_STATUS | TJ30 | User Status | MANDT |