SAP table COKEY (CO key sub-numbers)
SAP table COKEY has 2 primary key fields being MANDT,HRKFT.
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 | MANDT | ||
| HRKFT | CO key subnumber | CHAR | 14 | 0 | CO_SUBKEY | ||
| WERKS | Plant | CHAR | 4 | 0 | WERKS_D | ||
| MATNR | Material Number | CHAR | 40 | 0 | MATNR | ||
| HKGRP | Origin Group as Subdivision of Cost Element | CHAR | 4 | 0 | * | HRKFT | |
| PCVER | COPC Area of Responsibility | CHAR | 14 | 0 | CO_VERANB | ||
| CBRKE | External Value Added Ranking (CO-OM-ABC) | NUMC | 2 | 0 | CBRK | CO_CBRKE | |
| CBRKI | Internal Value Added Ranking (CO-OM-ABC) | NUMC | 2 | 0 | CBRK | CO_CBRKI | |
| CBART | Business Process Attribute: Category | CHAR | 2 | 0 | CBAR | CO_CBART | |
| DRVTP | Business Process Attribute: Allocation Category (CO-OM-ABC) | CHAR | 3 | 0 | CBDT | CO_DRVTP | |
| CBAT | Business Process Attribute: Additional Attribute (CO-OM-ABC) | CHAR | 10 | 0 | CBAT | CO_CBAT | |
| RECIND | Recovery Indicator | CHAR | 2 | 0 | T8JJ | JV_RECIND | |
| BEMOT | Accounting Indicator | CHAR | 2 | 0 | * | BEMOT | |
| PERNR | Personnel Number | NUMC | 8 | 0 | PERNR_D | ||
| RSRCE | Resource | CHAR | 10 | 0 | * | CO_RESSOURCE | |
| SUBKEY2 | Exclusively Reserved Sub-Number for Encoding Public Charact. | NUMC | 10 | 0 | EAPS_SUBNR |
COKEY foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 COKEY | CBART | CBAR | Type of business process | MANDT |
| 1 COKEY | CBAT | CBAT | Business Process Attribute | CBAT |
| 0 COKEY | CBRKE | CBRK | Value-Added Ranking for Business Processes | MANDT |
| 1 COKEY | CBRKI | CBRK | Value-Added Ranking for Business Processes | MANDT |
| 0 COKEY | DRVTP | CBDT | Allocation type for business processes | MANDT |
| 1 COKEY | RECIND | T8JJ | Recovery Indicator | MANDT |
| 1 COKEY | RECIND | T8JJ | Recovery Indicator | BUKRS |