TKA09

Transparent Table Customizing Table

Grundeinstellungen Versionen

TKA09 is an SAP database table in S/4HANA. Grundeinstellungen Versionen. 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.

-- Grundeinstellungen Versionen
-- 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)
);