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