TKA09

Transparent Table Customizing Table
11 Fields 11 CDS Views

Basic Settings for Versions

TKA09 is an SAP database table in S/4HANA. Basic Settings for Versions. It contains 11 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
Fac_opp_cds_co_version view from CDS View For CO version
FCO_MIG_CUR view inner CO Delta Entries - Currency Handling (src. COEP+COSP+COSS)
FINS_REV_REC_CATEGORY_VERSION view inner Plan category and CO plan version
FINSCDS_F4_ACVTP view from Actual Transfer Price Versions in Contr. Area
V_COSP_LVP_2_VIEW view left_outer COSP totals: all currencies/valuations - 1
V_COSP_PER_2_VIEW view inner COSP totals: all currencies/valuations - 2
V_COSS_LVP_2_VIEW view left_outer COSS totals: all currencies/valuations - 1
V_COSS_PER_2_VIEW view inner COSS totals: all currencies/valuations - 2
V_COSS_X_PER_1_VIEW view inner COSS totals in all currencies/valuations - 1
V_COSS4W09_2_VIEW view inner COSS for WRTTP=09 - part 2
V_COSX_LVP_2_VIEW view left_outer COSX totals: all currencies/valuations - 1

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kokrs KOKRS CO Area
KEY versn VERSN Version
actual VER_ACTUAL Record Actual Data
planning VER_PLAN Record planning data
brgru KPP_BRGRU Authorization
refvs REFVS Refer. Version
exuvs CO_EXUVS Exclusive Use
valutyp VALUTYP Valuation View
wipdf VER_WIP Carry WIP
abwdf VER_ABW Carry variance

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.

-- Basic Settings for Versions
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TKA09 (
    MANDT,     -- Client [MANDT]
    KOKRS,     -- CO Area [KOKRS]
    VERSN,     -- Version [VERSN]
    ACTUAL,    -- Record Actual Data [VER_ACTUAL]
    PLANNING,  -- Record planning data [VER_PLAN]
    BRGRU,     -- Authorization [KPP_BRGRU]
    REFVS,     -- Refer. Version [REFVS]
    EXUVS,     -- Exclusive Use [CO_EXUVS]
    VALUTYP,   -- Valuation View [VALUTYP]
    WIPDF,     -- Carry WIP [VER_WIP]
    ABWDF,     -- Carry variance [VER_ABW]
    PRIMARY KEY (MANDT, KOKRS, VERSN)
);

Learn More