SAP Table
TVKOV Org. Unit: Distribution Channels per Sales Organization
SAP table TVKOV has 3 primary key fields being MANDT,VKORG,VTWEG.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TVKOV columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||
| KeyVKORG | Sales Organization | CHAR | 4 | 0 | TVKO | VKORG | |||||||
| KeyVTWEG | Distribution Channel | CHAR | 2 | 0 | TVTW | VTWEG | |||||||
| VTWKO | Reference distribution channel for conditions | CHAR | 2 | 0 | TVTW | VTWKO | |||||||
| VTWAU | Distribution channel for sales doc types | CHAR | 2 | 0 | TVTW | VTWAU | |||||||
| VTWKU | Reference distrib.channel for cust.and material masters | CHAR | 2 | 0 | TVTW | VTWKU | |||||||
| VLGFI | Reference Plant of the Category "Store" (Material Master) | CHAR | 4 | 0 | T001W | VLGFI | |||||||
| VLTYP | Distribution chain category | CHAR | 1 | 0 | VLTYP | ||||||||
|
|||||||||||||
| VLKEB | Allowed pricing levels below distribution chain level | CHAR | 1 | 0 | VLKEB | ||||||||
|
|||||||||||||
| HIDE | Customization of SD Input Help Entries | CHAR | 1 | 0 | SD_OBSOLETE | ||||||||
/ Relationships
TVKOV foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| TVKOV | VKORG | TVKO | Organizational Unit: Sales Organizations | MANDT |
| TVKOV | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| TVKOV | VLGFI | T001W | Plants/Branches | WERKS |
| TVKOV | VTWAU | TVTW | Organizational Unit: Distribution Channels | MANDT |
| TVKOV | VTWAU | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| TVKOV | VTWEG | TVTW | Organizational Unit: Distribution Channels | MANDT |
| TVKOV | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| TVKOV | VTWKO | TVTW | Organizational Unit: Distribution Channels | MANDT |
| TVKOV | VTWKO | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| TVKOV | VTWKU | TVTW | Organizational Unit: Distribution Channels | MANDT |
| TVKOV | VTWKU | TVTW | Organizational Unit: Distribution Channels | VTWEG |