SAP table COKL (CO Object: Control Data for Activity Types)

SAP table COKL has 5 primary key fields being MANDT,LEDNR,OBJNR,GJAHR,VERSN.

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
LEDNR Ledger for Controlling Objects CHAR 2 0 LEDNR
00 Standard ledger
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
GJAHR Fiscal Year NUMC 4 0 GJAHR
VERSN Version CHAR 3 0 TKA09 VERSN
TARKZ Price Indicator: Calculate Allocation Price CHAR 3 0 TKA10 TARKZ
VKSTA Allocation Cost Element CHAR 10 0 CSKA VKSTA
AUFKZ Indicator for Allocation of Activity-Independent Costs CHAR 1 0 AUFKZ
AEQUI Equivalence Numbers DEC 3 0 AEQUI
WSLST Valuation Type for Planned Activity CHAR 1 0 WSLPL
WSKAP Valuation Type for Capacity CHAR 1 0 WSKAP
WSAUS Valuation Type for Output CHAR 1 0 WSPML
WSTKG Value determination type Fixed and variable price CHAR 1 0 WSTKG
WSTKF Value determination type Fixed price CHAR 1 0 WSTKF
FMLST Formula number planned activity CHAR 3 0 FMLPL
FMKAP Formula no. capacity CHAR 3 0 FMKAP
FMAUS Formula number Output CHAR 3 0 FMPML
FMTKG Formula number Fixed+variable price CHAR 3 0 FMTKG
FMTKF Formula number Fixed price CHAR 3 0 FMTKF
FCLST Distribution Key: Plan Activity CHAR 4 0 T821S FCLST
FCKAP Distribution Key: Capacity CHAR 4 0 T821S FCKPZ
FCAUS Distribution Key Output CHAR 4 0 T821S FCAUS
FCAEQ Distribution key CHAR 4 0 T821S CO_FCXXX
FCTKF Distribution Key: Fixed Price CHAR 4 0 T821S FCTKF
FCTKV Distribution key CHAR 4 0 T821S CO_FCXXX
FCTKG Distribution key total price CHAR 4 0 T821S FCTKG
FCTOF Distribution key CHAR 4 0 T821S CO_FCXXX
FCTOV Distribution key CHAR 4 0 T821S CO_FCXXX
FCTOG Distribution key CHAR 4 0 T821S CO_FCXXX
FCTXF Distribution key CHAR 4 0 T821S CO_FCXXX
FCTXV Distribution key CHAR 4 0 T821S CO_FCXXX
FCTXG Distribution key CHAR 4 0 T821S CO_FCXXX
KKART Costing Variant CHAR 4 0 CO_KKART
KALNR Cost Estimate Number NUMC 12 0 CO_KALNR
TXFLG Text Indicator CHAR 1 0 TXFLG
KVEWE Usage of the condition table CHAR 1 0 T681V KVEWE
KAPPL Application CHAR 2 0 T681A KAPPL
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) CHAR 6 0 T683 KALSM_D
PFSCHL Pricing Key CHAR 6 0 PFSCHL
ABWCHKZ Indicator for Charging of Variances CHAR 1 0 ABWCHKZ
LLSTAR Ind.: Activity type is control activity type? CHAR 1 0 LLSTAR
KLSTAR Ind.: Activity type is used in dependency for dep. costs? CHAR 1 0 KLSTAR
RZLSTAR Activity Type CHAR 6 0 CSLA LSTAR
RZLST Dep. Activity Qty. per Unit of Activity QUAN 15 3 RZLPL
RZKAP Recipe Capacity per Unit of Activity QUAN 15 3 RZKAP
RZAUS Dep. Output Quantity per Unit of Activity QUAN 15 3 RZPML
RZFKT Recipe Factor DEC 9 2 RZFKT
RZPRZ Depend.Percentage DEC 9 2 RZPRZ
YRATE Price Calculation with Period-Based Average Prices CHAR 1 0 CO_YRATE
FIXVO Predistribution of fixed costs for acty type/bus. process CHAR 1 0 CO_FIXVO
TARKZ_I Indicator: Actual Allocation Price CHAR 3 0 TKA10 CO_TARKZ_I
LATYP Activity Type Category CHAR 1 0 LATYP
1 Manual entry, manual allocation
2 Indirect determination, indirect allocation
3 Manual entry, indirect allocation
4 Manual entry, no allocation
LATYPI Variant Activity Type Category for Actual Postings CHAR 1 0 LATYPI
As in planning
1 Manual entry, manual allocation
2 Indirect determination, indirect allocation
3 Manual entry, indirect allocation
4 Manual entry, no allocation
5 Taget=actual allocation
SWSMH Cost component splitting switching structure CHAR 3 0 TKA12 CO_SWSMH
CI_KLVAR Costing Variant for Cost Component Splitting CHAR 4 0 COI_KLVAR
CI_KALNR Cost Estimate Number - Cost Component Splitting NUMC 12 0 COI_KALNR
MANIST Indicator: Confirm quantity manually in actual CHAR 1 0 CO_MANIST
MANPLAN Indicator: Plan quantity manually set. CHAR 1 0 CO_MANPLAN

COKL foreign key relationships

Table Field Check Table Check Field
0 COKL FCAEQ T821S Distribution keys MANDT
0 COKL FCAEQ T821S Distribution keys SPRED
1 COKL FCAUS T821S Distribution keys MANDT
1 COKL FCAUS T821S Distribution keys SPRED
0 COKL FCKAP T821S Distribution keys MANDT
0 COKL FCKAP T821S Distribution keys SPRED
1 COKL FCLST T821S Distribution keys MANDT
1 COKL FCLST T821S Distribution keys SPRED
0 COKL FCTKF T821S Distribution keys MANDT
0 COKL FCTKF T821S Distribution keys SPRED
1 COKL FCTKG T821S Distribution keys MANDT
1 COKL FCTKG T821S Distribution keys SPRED
0 COKL FCTKV T821S Distribution keys MANDT
0 COKL FCTKV T821S Distribution keys SPRED
1 COKL FCTOF T821S Distribution keys MANDT
1 COKL FCTOF T821S Distribution keys SPRED
0 COKL FCTOG T821S Distribution keys MANDT
0 COKL FCTOG T821S Distribution keys SPRED
1 COKL FCTOV T821S Distribution keys MANDT
1 COKL FCTOV T821S Distribution keys SPRED
0 COKL FCTXF T821S Distribution keys MANDT
0 COKL FCTXF T821S Distribution keys SPRED
1 COKL FCTXG T821S Distribution keys MANDT
1 COKL FCTXG T821S Distribution keys SPRED
0 COKL FCTXV T821S Distribution keys MANDT
0 COKL FCTXV T821S Distribution keys SPRED
1 COKL KALSM T683 Pricing procedures KAPPL
1 COKL KALSM T683 Pricing procedures KALSM
0 COKL KAPPL T681A Conditions: Applications KAPPL
1 COKL KVEWE T681V Conditions: Usages KVEWE
0 COKL MANDT T000 Clients MANDT
1 COKL OBJNR ONR00 General Object Number MANDT
0 COKL RZLSTAR CSLA Activity master MANDT
0 COKL RZLSTAR CSLA Activity master KOKRS
0 COKL RZLSTAR CSLA Activity master DATBI
1 COKL SWSMH TKA12 Switching Structure for Cost Component Splitting MANDT
0 COKL TARKZ TKA10 Master Data Table, Price Indicators MANDT
0 COKL TARKZ TKA10 Master Data Table, Price Indicators TARKZ
1 COKL TARKZ_I TKA10 Master Data Table, Price Indicators MANDT
1 COKL TARKZ_I TKA10 Master Data Table, Price Indicators TARKZ
0 COKL VERSN TKA09 Basic Settings for Versions MANDT
0 COKL VERSN TKA09 Basic Settings for Versions KOKRS
0 COKL VERSN TKA09 Basic Settings for Versions VERSN
1 COKL VKSTA CSKA Cost Elements (Data Dependent on Chart of Accounts) MANDT
1 COKL VKSTA CSKA Cost Elements (Data Dependent on Chart of Accounts) KTOPL