SAP ABAP View V_TVKWZ_ASSIGN (Assignment Sales Organization/Distribution Channel - Plant)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       VS0C (Package) Customizing R/3 Sales and Distribution master data
Basic Data
View Type C Maintenance View 
Maintenance View V_TVKWZ_ASSIGN  
Short Description Assignment Sales Organization/Distribution Channel - Plant    
Root table TVKWZ   Org.Unit: Allowed Plants per Sales Organization 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 TVKWZ TVKWZ
2 TVKO TVKWZ VKORG E
3 T001 TVKO BUKRS E
4 TVKOT TVKO VKORG I
5 TVKOV TVKWZ VTWEG E
6 TVTW TVKOV VTWEG E
7 TVTWT TVTW VTWEG I
8 TASSIGN_SD_VKORG TVKO VKORG I
9 T001W TVKWZ WERKS E
10 T001K T001W BWKEY E
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT TVKWZ MANDT   MANDT Client
2 VKORG TVKWZ VKORG   VKORG Sales Organization
3 VTWEG TVKWZ VTWEG   VTWKU Reference distrib.channel for cust.and material masters
4 WERKS TVKWZ WERKS   WERKS_EXT Plant (Own or External)
5 VKORGTEXT TVKOT VTEXT R VTXTK Name
6 VTWEGTEXT TVTWT VTEXT R VTXTK Name
7 WERKSTEXT T001W NAME1 R NAME1 Name
8 STATUS_ASSIGN_SD TASSIGN_SD_VKORG STATUS_ASSIGN_SD R STATUS_ASSIGN_SD Status of Assignment in SD Customizing
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class C   Customizing table, maintenance only by cust., not SAP import 
Data Browser/Table View Maintenance X  Display/Maintenance Allowed  
History
Last changed by/on SAP  20130529 
SAP Release Created in 600