SAP table TKA01 (Controlling Areas)

SAP table TKA01 has 2 primary key fields being MANDT,KOKRS.

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
KOKRS Controlling Area CHAR 4 0 KOKRS
BEZEI Name of the controlling area CHAR 25 0 BEZEI
WAERS Currency Key CUKY 5 0 TCURC WAERS
KTOPL Chart of Accounts CHAR 4 0 T004 KTOPL
LMONA Fiscal Year Variant CHAR 2 0 T009 PERIV
KOKFI Allocation Indicator CHAR 1 0 KOKFI
1 Controlling area same as company code
2 Cross-company-code cost accounting
LOGSYSTEM Logical System CHAR 10 0 TBDLS LOGSYSTEM
ALEMT Cost center distribution method using ALE CHAR 2 0 CO_ALEMT
No distribution to other systems
01 All cost centers centralized
02 Cost centers decentralized or centralized
MD_LOGSYSTEM Logical system for master data maintenance CHAR 10 0 TBDLS MASTERDATA_LOGSYSTEM
KHINR Standard Hierarchy for Cost Centers CHAR 12 0 KSTHI
KOMP1 Indicator: Revenue must be converted CHAR 1 0 KOMP1
KOMP0 Productive indicator for controlling area CHAR 1 0 KOMP0
KOMP2 Indicator: reserve (not used at present) CHAR 1 0 KOMP2
ERKRS Operating concern CHAR 4 0 TKEB ERKRS
DPRCT Dummy Profit Center CHAR 10 0 CEPC DPRCT
PHINR Profit center area CHAR 12 0 PHINR
PCLDG Profit center ledger CHAR 2 0 T881 PCLDG
PCBEL Elimination of internal bus. volume for Profit Center Acctg CHAR 1 0 PCBEL
XWBUK Indicator: Different Company Code Currency is Allowed CHAR 1 0 XWBUK
BPHINR Standard Hierarchy Area CHAR 12 0 CO_BPHINR
XBPALE Indicator: ALE for active business process (process costs) CHAR 1 0 XBPALE
KSTAR_FIN Cost element for vendor downpayments w/o purchase ord. ref. CHAR 10 0 CSKA KSTAR_FIN
KSTAR_FID Revenue type for debitor downpayments without sales ord. ref CHAR 10 0 CSKA KSTAR_FID
PCACUR Local Currency for Profit Center Accounting CUKY 5 0 TCURC PCACUR
PCACURTP Currency type of the profit center report currency CHAR 2 0 CURTPPC
PCATRCUR Store transaction currency in EC-PCA CHAR 1 0 PCATRCUR
CTYP Currency Type for Controlling Area CHAR 2 0 CO_CTYP
RCLAC Reconciliation Ledger Active CHAR 1 0 RCLACTIV
BLART Document Type for Reconcil. Postings From Reconcil. Ledger CHAR 2 0 T003 RCL_BLART
FIKRS Financial Management Area CHAR 4 0 FM01 FIKRS
RCL_PRIMAC Reconciliation Ledger: Acct Determination for Primary CElms CHAR 1 0 RCL_PRIMAC
PCA_ALEMT Method for Distributing Profit Centers Using ALE CHAR 2 0 PCA_ALEMT
No distribution to other systems
01 Centralized Profit Center Accounting
02 Profit center decentralized or local
PCA_VALU Valuation View NUMC 1 0 VALUTYP
0 Legal Valuation
1 Group Valuation
2 Profit Center Valuation
CVPROF Currency and Valuation Profile CHAR 4 0 TCVPROF CVPROF
CVACT Ind.: Currency and Valuation Profile Active CHAR 1 0 CVACT
VNAME Person Responsible for the Controlling Area CHAR 12 0 USR02 CO_VNAME
PCA_ACC_DIFF Account control when transferring valuation differences CHAR 1 0 PCA_ACCOUNT_VAL_DIFF
General ledger account
1 Adjustment account
TP_VALOHB Valuation View for Calculation Base NUMC 1 0 VALUTYP_OH_BASE
DEFPRCTR Default Profit Center for Nonassigned Processes CHAR 10 0 CEPC FAGL_DEFPRCTR
F_OBSOLETE Hide Entry in Value Help CHAR 1 0 CO_OBSOLETE_F4
LEADING_FSV Leading Controlling Financial Statement Version CHAR 42 0 * FCO_LEADING_FSV
AUTH_USE_NO_STD Do Not Use Standard Hierarchy for Authorizations CHAR 1 0 AUTH_USE_NO_STD
AUTH_USE_ADD1 Use First Alternative Hierarchy for Authorizations CHAR 1 0 AUTH_USE_ADD1
AUTH_USE_ADD2 Use Second Alternative Hierarchy for Authorizations CHAR 1 0 AUTH_USE_ADD2
AUTH_KE_NO_STD Do Not Use Standard Hierarchy for Authorizations CHAR 1 0 AUTH_USE_NO_STD
AUTH_KE_USE_ADD1 Use First Alternative Hierarchy for Authorizations CHAR 1 0 AUTH_USE_ADD1
AUTH_KE_USE_ADD2 Use Second Alternative Hierarchy for Authorizations CHAR 1 0 AUTH_USE_ADD2
OBJCUR_USE Alternative Use of Object Currency in GL CHAR 4 0 OBJCURUSE
No Alternative Use
0001 Project currency
0101 Project Currency & Service Contract Currency
OBJCUR_KURST Exchange Rate Type CHAR 4 0 * KURST
OBJCUR_CURDT Type of translation date CHAR 1 0 OBJCURCURDT
1 Document Date
2 Posting Date
3 Currency Translation Date
OBJCUR_SRCCT Source Currency Type CHAR 2 0 * FINS_SOURCE_CURTYPE
OBJCUR_SRCAL Alternative Source Currency: Equal Currency Preferred CHAR 1 0 OBJCURSRCALT

TKA01 foreign key relationships

Table Field Check Table Check Field
0 TKA01 BLART T003 Document Types MANDT
1 TKA01 CVPROF TCVPROF Currency and Valuation Profiles MANDT
1 TKA01 CVPROF TCVPROF Currency and Valuation Profiles CVPROF
0 TKA01 DEFPRCTR CEPC Profit Center Master Data Table PRCTR
0 TKA01 DEFPRCTR CEPC Profit Center Master Data Table DATBI
0 TKA01 DEFPRCTR CEPC Profit Center Master Data Table KOKRS
1 TKA01 DPRCT CEPC Profit Center Master Data Table PRCTR
1 TKA01 DPRCT CEPC Profit Center Master Data Table DATBI
1 TKA01 DPRCT CEPC Profit Center Master Data Table KOKRS
0 TKA01 ERKRS TKEB Management for Operating Concerns (Client-Specific) MANDT
0 TKA01 ERKRS TKEB Management for Operating Concerns (Client-Specific) ERKRS
1 TKA01 FIKRS FM01 Financial Management Areas FIKRS
0 TKA01 KSTAR_FID CSKA Cost Elements (Data Dependent on Chart of Accounts) MANDT
0 TKA01 KSTAR_FID CSKA Cost Elements (Data Dependent on Chart of Accounts) KTOPL
1 TKA01 KSTAR_FIN CSKA Cost Elements (Data Dependent on Chart of Accounts) MANDT
1 TKA01 KSTAR_FIN CSKA Cost Elements (Data Dependent on Chart of Accounts) KTOPL
0 TKA01 KTOPL T004 Directory of Charts of Accounts MANDT
1 TKA01 LMONA T009 Fiscal Year Variants MANDT
1 TKA01 LMONA T009 Fiscal Year Variants PERIV
0 TKA01 LOGSYSTEM TBDLS Logical system LOGSYS
1 TKA01 MD_LOGSYSTEM TBDLS Logical system LOGSYS
0 TKA01 PCACUR TCURC Currency Codes MANDT
0 TKA01 PCACUR TCURC Currency Codes WAERS
1 TKA01 PCLDG T881 Ledger Master MANDT
0 TKA01 VNAME USR02 Logon Data (Kernel-Side Use) BNAME
1 TKA01 WAERS TCURC Currency Codes MANDT
1 TKA01 WAERS TCURC Currency Codes WAERS