SAP Table

TKA01 Controlling Areas

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

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

TKA01 columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyKOKRS 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
LOGSYSTEM Logical System CHAR 10 0 TBDLS LOGSYSTEM
ALEMT Cost center distribution method using ALE CHAR 2 0 CO_ALEMT
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
PCA_VALU Valuation View NUMC 1 0 VALUTYP
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
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
OBJCUR_KURST Exchange Rate Type CHAR 4 0 * KURST
OBJCUR_CURDT Type of translation date CHAR 1 0 OBJCURCURDT
OBJCUR_SRCCT Source Currency Type CHAR 2 0 * FINS_SOURCE_CURTYPE
OBJCUR_SRCAL Alternative Source Currency: Equal Currency Preferred CHAR 1 0 OBJCURSRCALT
/ Relationships

TKA01 foreign keys.

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