SAP Table
COKEY CO key sub-numbers
SAP table COKEY has 2 primary key fields being MANDT,HRKFT.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
COKEY columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | MANDT | ||
| KeyHRKFT | 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 |
/ Relationships
COKEY foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| COKEY | CBART | CBAR | Type of business process | MANDT |
| COKEY | CBAT | CBAT | Business Process Attribute | CBAT |
| COKEY | CBRKE | CBRK | Value-Added Ranking for Business Processes | MANDT |
| COKEY | CBRKI | CBRK | Value-Added Ranking for Business Processes | MANDT |
| COKEY | DRVTP | CBDT | Allocation type for business processes | MANDT |
| COKEY | RECIND | T8JJ | Recovery Indicator | MANDT |
| COKEY | RECIND | T8JJ | Recovery Indicator | BUKRS |