SAP table TVKOV (Org. Unit: Distribution Channels per Sales Organization)

SAP table TVKOV has 3 primary key fields being MANDT,VKORG,VTWEG.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG 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
Distribution chain for wholesale trade
1 Distribution chain for stores
2 Distribution chain for distribution centers
VLKEB Allowed pricing levels below distribution chain level CHAR 1 0 VLKEB
Only price lists allowed
1 Only plants allowed
2 Price lists and plants allowed
HIDE Customization of SD Input Help Entries CHAR 1 0 SD_OBSOLETE

TVKOV foreign key relationships

Table Field Check Table Check Field
0 TVKOV VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 TVKOV VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 TVKOV VLGFI T001W Plants/Branches WERKS
0 TVKOV VTWAU TVTW Organizational Unit: Distribution Channels MANDT
0 TVKOV VTWAU TVTW Organizational Unit: Distribution Channels VTWEG
1 TVKOV VTWEG TVTW Organizational Unit: Distribution Channels MANDT
1 TVKOV VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
0 TVKOV VTWKO TVTW Organizational Unit: Distribution Channels MANDT
0 TVKOV VTWKO TVTW Organizational Unit: Distribution Channels VTWEG
1 TVKOV VTWKU TVTW Organizational Unit: Distribution Channels MANDT
1 TVKOV VTWKU TVTW Organizational Unit: Distribution Channels VTWEG