TKA01

Transparent Table Customizing Table
53 Fields 72 CDS Views

Controlling Areas

TKA01 is an SAP database table in S/4HANA. Controlling Areas. It contains 53 fields. 72 CDS views read from this table.

CDS Views using this table (72)

ViewTypeJoinVDMDescription
Adk0_Dli_Wip_Detail_Vbl_View view inner DLI WIP Detail View for SD Documents
Adk0_Dli_Wip_Detail_View view inner DLI WIP Detail View for WBS Elements
fac_opp_cds_co_ctrl_area view from CDS View For CO Controlling Area
fac_opp_cds_co_fiscal_variants view from CDS View For variant from CO Areas
fco_abr_bel_04_a view inner Settlement actual costs
fco_abr_bel_ld_a view inner Settlement actual costs per ledger
fco_abr_bel04_a view inner Settlement actual costs w. additional currencies
FCO_COR_HSL_DER view inner HSL Corr. for Stat. Records in CO: Derivation of CurrKey
FCO_COST_RATE_MIG_CLASSIC view inner Activity prices from COST in ACCOSTRATE format
FCO_MIG_ACDOCA view inner CO Delta Entries - Aggregated ACDOCA Records
FCO_MIG_COEP view inner CO Delta Entries - Line Items after sFIN 1.0 (src. COEP)
FCO_MIG_COEP11 view inner CO Delta Entries - Statistical Line Items
FCO_MIG_CUR view inner CO Delta Entries - Currency Handling (src. COEP+COSP+COSS)
FCO_MIG_DERIV_P view inner CO Delta Entries (COSP+COSS) - Derivation of Dep. Fields
fco_ovhd_cost_acdoca view_entity inner Overhead costs from acdoca
fco_ovhd_cost_co_values1 view_entity inner Overhead costs from acdoca to fields for CO-Version
fco_ovhd_cost_co_values1_l view_entity inner Overhead costs from acdoca to fields for CO-Version
fiscds_evpad_01 view left_outer Line Item Browser: DDL Source
fiscds_gllit_02 view left_outer GL Line Item (other Ledger)
fiscds_ldcmpcurr view left_outer Currencies of Company Code and Ledger
I_ControllingArea view from BASIC Controlling Area
I_DistrAccountingData view_entity inner COMPOSITE Distribution cost data
I_DistrAccountingDataDebit view_entity inner BASIC Distribution cost data
I_MasterProjectCurrency view inner BASIC Get master Project Currency
I_ProjectResultAnalysisData view inner BASIC Result Analysis Data for Projects
I_ProjStkOrderActualCost view_entity inner COMPOSITE Stock order actual cost
Kkag_Kokrs_Bukrs_Waers view inner Currency of company code and CO area
Kkag_Tkkaz1 view inner TKKAZ Step 1
Kkag_Tkkaz2 view inner TKKAZ Step 2
P_Ldcmpcurr view left_outer BASIC
P_Projectwiprevdetlbasic view inner BASIC
P_Ra_Line_Items_Posting_Rules view inner BASIC
P_RTPCOrderActlCostForSttlLd view inner BASIC
P_RTPCOrderSettCostForRevLd view inner BASIC
Skcska_V view inner Mass Maintenance: Cost Elements
V_COEP_ACDOCA_CT1_VIEW view inner Mapping of ACDOCA to COEP-fields - add. curr.types - part 1
V_Coep_Acdoca_R1_view view inner Mapping of ACDOCA to COEP-fields - revised version - part 1
v_coep_acdoca_view view inner Mapping from ACDOCA to COEP
V_COEP_SASCB_VIEW view inner COEP simple as simple can be
V_Coepacdoca_Age_view view inner Cold data fom ACDOCA (only value type 04)
v_coepext_acdoca_view view inner Mapping from ACDOCA to COEP_EXT
v_coepxt_acdocav_view view inner Mapping from ACDOCA to COEP_EXT with Version
V_Cosp_3_Ddl_Age_view view inner Cold Data: Primary Actuals from ACDOCA per period
v_cosp_3_view view inner CO Object: Cost Totals for External Postings (part 3)
V_Cosp_D_as_Coep_Age_View view inner Cold Data: Totals - Migrated Deltas (primary)
v_cosp_d2_coep_view view inner COSP Difference from Migration as COEP - BSTAT=C
V_COSP_KSII_1_VIEW view inner COSP for TA KSII, WRTTP=04 only - 1
V_COSP_LVP_1_VIEW view inner COSP totals: all currencies/valuations - 1
V_COSP_PER_1_VIEW view inner COSP totals: all currencies/valuations - 1
V_Cosp_R_3s_View view inner CO Object: Cost Totals for External Postings ("Rev.") Part3s
V_Cosp_R_8_View view inner CO Object: Cost Totals for External Postings ("Rev.") Part 8
v_cosp_wdv_1_view view inner COSP with delta versions (parallel valuation/COGM) - part 1
V_Coss_3_Ddl_Age_view view inner Cold Data: Actuals from ACDOCA per period
v_coss_3_view view inner CO Object: Cost Totals for Internal Postings (part 3)
V_Coss_D_as_Coep_Age_View view inner Cold Data: Totals - Migrated Deltas (secondary)
v_coss_d2_coep_view view inner COSS Difference from Migration as COEP - BSTAT=C
V_COSS_KSII_1_VIEW view inner COSS for TA KSII, WRTTP=04 only - 1
V_COSS_LVP_1_VIEW view inner COSS totals: all currencies/valuations - 1
V_COSS_PER_1_VIEW view inner COSS totals in all currencies/valuations - 1
V_Coss_R_3s_View view inner CO Object: Cost Totals for Internal Postings ("Rev.") Part3s
V_Coss_R_8_View view inner CO Object: Cost Totals for Internal Postings ("Rev.") Part 8
V_COSS_W11_1_VIEW view inner COSS for WRTTP=11 only - part 1
v_coss_wdv_1_view view inner COSS with delta versions (parallel valuation/COGM) - part 1
V_COSS_X_PER_1_VIEW view inner COSS totals in all currencies/valuations - 1
V_COSS4W09_1_VIEW view inner COSS for WRTTP=09 - part 1
V_COSX_ACDOCA_VIEW view inner COSP/COSS data on ACDOCA wo delta logic
V_COSX_LVP_1_VIEW view inner COSx totals: all currencies/valuations - 1
v_cosx_wof_1_view view inner calculation WOF value for COSP/COSS on ACDOCA basis - part 1
v_ml_account_l2_view view left_outer LOCAL: Material Ledger Periods
v_ml_inv_base_view view left_outer ML Delta Entries - Aggregate of ACDOCA
v_ml_invtot_view view left_outer LOCAL: Inventory Stock Totals
v_ml_mig_base_view view left_outer ML Delta Entries - Aggregate of ACDOCA

Fields (53)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kokrs KOKRS CO Area
bezei BEZEI Name
waers WAERS Currency
ktopl KTOPL Chart of Accts
lmona PERIV FY Variant
kokfi KOKFI CoCd->CO Area
logsystem LOGSYSTEM Logical System
alemt CO_ALEMT Distr. Method
md_logsystem MASTERDATA_LOGSYSTEM LS master data
khinr KSTHI Std. Hierarchy
komp1 KOMP1 Convert revenue
komp0 KOMP0 Productive ind.
komp2 KOMP2 Reserve
erkrs ERKRS Operating concern
dprct DPRCT Dummy PrCtr
phinr PHINR Area
pcldg PCLDG PrCtr ledger
pcbel PCBEL Elim.IntBusVol
xwbuk XWBUK Diff CCode Curr
bphinr CO_BPHINR Area
xbpale XBPALE ALE active BP
kstar_fin KSTAR_FIN CElem vend.dwnp
kstar_fid KSTAR_FID RevTyp cus.dwnp
pcacur PCACUR PrCtr Local Currency
pcacurtp CURTPPC Currency type
pcatrcur PCATRCUR Transaction currency
ctyp CO_CTYP Currency Type
rclac RCLACTIV RecLedgr Active
blart RCL_BLART Document Type
fikrs FIKRS FM Area
rcl_primac RCL_PRIMAC AcctDet.forPrim.CEls
pca_alemt PCA_ALEMT ALE dist. method
pca_valu VALUTYP Valuation View
cvprof CVPROF Curr/Val. Prof.
cvact CVACT C&V Pro. Active
vname CO_VNAME Person Respons.
pca_acc_diff PCA_ACCOUNT_VAL_DIFF Account control
tp_valohb VALUTYP_OH_BASE ValView CalcBas
defprctr FAGL_DEFPRCTR Default PrCtr
f_obsolete CO_OBSOLETE_F4 Hide Entry
leading_fsv FCO_LEADING_FSV Leading FS Version
auth_use_no_std AUTH_USE_NO_STD No StdHier
auth_use_add1 AUTH_USE_ADD1 Hierarchy 1
auth_use_add2 AUTH_USE_ADD2 Hierarchy 2
auth_ke_no_std AUTH_USE_NO_STD No StdHier
auth_ke_use_add1 AUTH_USE_ADD1 Hierarchy 1
auth_ke_use_add2 AUTH_USE_ADD2 Hierarchy 2
objcur_use OBJCURUSE Alter. Use Obj. Crcy
objcur_kurst KURST Exch. Rate Type
objcur_curdt OBJCURCURDT Trns.date type
objcur_srcct FINS_SOURCE_CURTYPE Source Currency Type
objcur_srcal OBJCURSRCALT Equal Crcy Preferred

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Controlling Areas
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TKA01 (
    MANDT,             -- Client [MANDT]
    KOKRS,             -- CO Area [KOKRS]
    BEZEI,             -- Name [BEZEI]
    WAERS,             -- Currency [WAERS]
    KTOPL,             -- Chart of Accts [KTOPL]
    LMONA,             -- FY Variant [PERIV]
    KOKFI,             -- CoCd->CO Area [KOKFI]
    LOGSYSTEM,         -- Logical System [LOGSYSTEM]
    ALEMT,             -- Distr. Method [CO_ALEMT]
    MD_LOGSYSTEM,      -- LS master data [MASTERDATA_LOGSYSTEM]
    KHINR,             -- Std. Hierarchy [KSTHI]
    KOMP1,             -- Convert revenue [KOMP1]
    KOMP0,             -- Productive ind. [KOMP0]
    KOMP2,             -- Reserve [KOMP2]
    ERKRS,             -- Operating concern [ERKRS]
    DPRCT,             -- Dummy PrCtr [DPRCT]
    PHINR,             -- Area [PHINR]
    PCLDG,             -- PrCtr ledger [PCLDG]
    PCBEL,             -- Elim.IntBusVol [PCBEL]
    XWBUK,             -- Diff CCode Curr [XWBUK]
    BPHINR,            -- Area [CO_BPHINR]
    XBPALE,            -- ALE active BP [XBPALE]
    KSTAR_FIN,         -- CElem vend.dwnp [KSTAR_FIN]
    KSTAR_FID,         -- RevTyp cus.dwnp [KSTAR_FID]
    PCACUR,            -- PrCtr Local Currency [PCACUR]
    PCACURTP,          -- Currency type [CURTPPC]
    PCATRCUR,          -- Transaction currency [PCATRCUR]
    CTYP,              -- Currency Type [CO_CTYP]
    RCLAC,             -- RecLedgr Active [RCLACTIV]
    BLART,             -- Document Type [RCL_BLART]
    FIKRS,             -- FM Area [FIKRS]
    RCL_PRIMAC,        -- AcctDet.forPrim.CEls [RCL_PRIMAC]
    PCA_ALEMT,         -- ALE dist. method [PCA_ALEMT]
    PCA_VALU,          -- Valuation View [VALUTYP]
    CVPROF,            -- Curr/Val. Prof. [CVPROF]
    CVACT,             -- C&V Pro. Active [CVACT]
    VNAME,             -- Person Respons. [CO_VNAME]
    PCA_ACC_DIFF,      -- Account control [PCA_ACCOUNT_VAL_DIFF]
    TP_VALOHB,         -- ValView CalcBas [VALUTYP_OH_BASE]
    DEFPRCTR,          -- Default PrCtr [FAGL_DEFPRCTR]
    F_OBSOLETE,        -- Hide Entry [CO_OBSOLETE_F4]
    LEADING_FSV,       -- Leading FS Version [FCO_LEADING_FSV]
    AUTH_USE_NO_STD,   -- No StdHier [AUTH_USE_NO_STD]
    AUTH_USE_ADD1,     -- Hierarchy 1 [AUTH_USE_ADD1]
    AUTH_USE_ADD2,     -- Hierarchy 2 [AUTH_USE_ADD2]
    AUTH_KE_NO_STD,    -- No StdHier [AUTH_USE_NO_STD]
    AUTH_KE_USE_ADD1,  -- Hierarchy 1 [AUTH_USE_ADD1]
    AUTH_KE_USE_ADD2,  -- Hierarchy 2 [AUTH_USE_ADD2]
    OBJCUR_USE,        -- Alter. Use Obj. Crcy [OBJCURUSE]
    OBJCUR_KURST,      -- Exch. Rate Type [KURST]
    OBJCUR_CURDT,      -- Trns.date type [OBJCURCURDT]
    OBJCUR_SRCCT,      -- Source Currency Type [FINS_SOURCE_CURTYPE]
    OBJCUR_SRCAL,      -- Equal Crcy Preferred [OBJCURSRCALT]
    PRIMARY KEY (MANDT, KOKRS)
);

Learn More