SAP table TFKCOD (FI-CA: CO Account Assignment Key/Allocation)
SAP table TFKCOD has 6 primary key fields being MANDT,COKEY,BUKRS,GSBER,SEGMENT,PRCTR_IN.
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 | |
| COKEY | CO Account Assignment Key | CHAR | 10 | 0 | TFKCOK | COKEY_KK2 | |
| BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| GSBER | Business Area | CHAR | 4 | 0 | TGSB | GSBER | |
| SEGMENT | Segment for Segmental Reporting | CHAR | 10 | 0 | FAGL_SEGM | SEGMT_KK | |
| PRCTR_IN | Profit Center | CHAR | 10 | 0 | * | PRCTR | |
| KOSTL | Cost Center | CHAR | 10 | 0 | CSKS | KOSTL | |
| AUFNR | Order Number | CHAR | 12 | 0 | AUFK | AUFNR | |
| PRCTR | Profit Center | CHAR | 10 | 0 | CEPC | PRCTR | |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | NUMC | 8 | 0 | PRPS | PS_PSP_PNR | |
| PROJK | Individual Structural Element (WBS Element) in Ext. Format | CHAR | 24 | 0 | PROJK_EXT | ||
| COPAK | Derive Account Assignment from Profitability Segment | CHAR | 1 | 0 | COPAK_KK |
TFKCOD foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TFKCOD | AUFNR | AUFK | Order master data | AUFNR |
| 1 TFKCOD | BUKRS | T001 | Company Codes | BUKRS |
| 0 TFKCOD | COKEY | TFKCOK | FI-CA: CO Account Assignment Key | MANDT |
| 0 TFKCOD | COKEY | TFKCOK | FI-CA: CO Account Assignment Key | COKEY |
| 1 TFKCOD | GSBER | TGSB | Business Areas | MANDT |
| 1 TFKCOD | GSBER | TGSB | Business Areas | GSBER |
| 0 TFKCOD | KOSTL | CSKS | Cost Center Master Record | MANDT |
| 0 TFKCOD | KOSTL | CSKS | Cost Center Master Record | KOKRS |
| 0 TFKCOD | KOSTL | CSKS | Cost Center Master Record | KOSTL |
| 0 TFKCOD | KOSTL | CSKS | Cost Center Master Record | DATBI |
| 1 TFKCOD | PRCTR | CEPC | Profit Center Master Data Table | PRCTR |
| 1 TFKCOD | PRCTR | CEPC | Profit Center Master Data Table | DATBI |
| 1 TFKCOD | PRCTR | CEPC | Profit Center Master Data Table | KOKRS |
| 0 TFKCOD | PS_PSP_PNR | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT |
| 0 TFKCOD | PS_PSP_PNR | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
| 1 TFKCOD | SEGMENT | FAGL_SEGM | Master Data for Segments | SEGMENT |