TVKO

Transparent Table Customizing Table
27 Fields 7 CDS Views

Organizational Unit: Sales Organizations

TVKO is an SAP database table in S/4HANA. Organizational Unit: Sales Organizations. It contains 27 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
fins_prctr_of_object_acdoca view left_outer Derive PRCTR & PPRCTR for ACDOCA object
I_SalesOrganization view from BASIC Sales Organization
P_CmmSalesOrganization view from BASIC
P_Dchain_Salestax view inner BASIC
P_Sales_Organization view from BASIC
SHSM_H_MVKE view left_outer CDS View for H_MVKE (search help)
vfco_dll_va88_l1 view left_outer

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY vkorg VKORG Sales Org.
waers WAERS_V Stats Currency
bukrs VKBUK Company Code
adrnr ADRNR Address
txnam_adr TXNAM_ADR Address text
txnam_kop TXNAM_KOP Letter header
txnam_fus TXNAM_FUS Footer text li.
txnam_gru TXNAM_GRU Greeting text
vkoau VKOAU Ref.sales org.
kunnr KUNIV Cust.Interc.Bl.
boavo BOAVO Reb.proc.active
vkokl VKOKL SOrg calendar
ekorg EKORG Purchasing Org.
ekgrp EKGRP Purch. Group
lifnr LIFNR Supplier
werks WERKS_D Plant
bsart BSART Order Type
bstyp BSTYP Doc. Category
bwart BWARTWE Movement Type
lgort LGORT_D Location
txnam_sdb TXNAM_SDB Text SDS sender
mwskz J_1AMWSKZ SD tax code
xstceg XSTCEG VAT ID Determ.
j_1anutime J_1ANUTIME Numb. time
maxbi MAXBI No. bill. items
hide SD_OBSOLETE Hide in Input Help

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.

-- Organizational Unit: Sales Organizations
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TVKO (
    MANDT,       -- Client [MANDT]
    VKORG,       -- Sales Org. [VKORG]
    WAERS,       -- Stats Currency [WAERS_V]
    BUKRS,       -- Company Code [VKBUK]
    ADRNR,       -- Address [ADRNR]
    TXNAM_ADR,   -- Address text [TXNAM_ADR]
    TXNAM_KOP,   -- Letter header [TXNAM_KOP]
    TXNAM_FUS,   -- Footer text li. [TXNAM_FUS]
    TXNAM_GRU,   -- Greeting text [TXNAM_GRU]
    VKOAU,       -- Ref.sales org. [VKOAU]
    KUNNR,       -- Cust.Interc.Bl. [KUNIV]
    BOAVO,       -- Reb.proc.active [BOAVO]
    VKOKL,       -- SOrg calendar [VKOKL]
    EKORG,       -- Purchasing Org. [EKORG]
    EKGRP,       -- Purch. Group [EKGRP]
    LIFNR,       -- Supplier [LIFNR]
    WERKS,       -- Plant [WERKS_D]
    BSART,       -- Order Type [BSART]
    BSTYP,       -- Doc. Category [BSTYP]
    BWART,       -- Movement Type [BWARTWE]
    LGORT,       -- Location [LGORT_D]
    TXNAM_SDB,   -- Text SDS sender [TXNAM_SDB]
    MWSKZ,       -- SD tax code [J_1AMWSKZ]
    XSTCEG,      -- VAT ID Determ. [XSTCEG]
    J_1ANUTIME,  -- Numb. time [J_1ANUTIME]
    MAXBI,       -- No. bill. items [MAXBI]
    HIDE,        -- Hide in Input Help [SD_OBSOLETE]
    PRIMARY KEY (MANDT, VKORG)
);

Learn More