TVKOV
Org. Unit: Distribution Channels per Sales Organization
TVKOV is an SAP database table in S/4HANA. Org. Unit: Distribution Channels per Sales Organization. It contains 10 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| CIC_I_DistributionChainText | view_entity | from | Projection on Distribution Chain | |
| I_BPFuncComDistrChannel | view | from | BASIC | Common Distribution Channel for Customer and Product |
| I_SlsOrganizationDistrChnl | view | from | BASIC | Distribution Channel for Sales Org |
| P_Productplantreferences | view | left_outer | BASIC |
Fields (10)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | vkorg | VKORG | Sales Org. | |||
| KEY | vtweg | VTWEG | Distr. Channel | |||
| vtwko | VTWKO | RefDistCh-Conds | ||||
| vtwau | VTWAU | RefDistCh-docs | ||||
| vtwku | VTWKU | RefDistCh-Cust/Mat. | ||||
| vlgfi | VLGFI | Reference Store | ||||
| vltyp | VLTYP | Distr.chain cat | ||||
| vlkeb | VLKEB | DCh. pr. levels | ||||
| 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.
-- Org. Unit: Distribution Channels per Sales Organization
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TVKOV (
MANDT, -- Client [MANDT]
VKORG, -- Sales Org. [VKORG]
VTWEG, -- Distr. Channel [VTWEG]
VTWKO, -- RefDistCh-Conds [VTWKO]
VTWAU, -- RefDistCh-docs [VTWAU]
VTWKU, -- RefDistCh-Cust/Mat. [VTWKU]
VLGFI, -- Reference Store [VLGFI]
VLTYP, -- Distr.chain cat [VLTYP]
VLKEB, -- DCh. pr. levels [VLKEB]
HIDE, -- Hide in Input Help [SD_OBSOLETE]
PRIMARY KEY (MANDT, VKORG, VTWEG)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA