SAP ABAP View V_TVTA_ASSIGN (Assignment Sales Org. - Distribution Channel - Division)

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_TVTA_ASSIGN
Short Description	Assignment Sales Org. - Distribution Channel - Division
Root table	TVTA	Organizational Unit: Sales Area(s)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TVTA	TVTA
2	TVKO	TVTA	VKORG	E
3	TVKOS	TVTA	SPART	E
4	TVKOV	TVTA	VTWEG	E
5	TVKOT	TVKO	VKORG	I
6	TSPA	TVKOS	SPART	E
7	TVTW	TVKOV	VTWEG	E
8	TSPAT	TSPA	SPART	I
9	TVTWT	TVTW	VTWEG	I
10	TASSIGN_SD_VKORG	TVKO	VKORG	I

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	TVTA	MANDT		☐	MANDT	☐	Client
2	VKORG	TVTA	VKORG		☐	VKORG	☐	Sales Organization
3	VTWEG	TVTA	VTWEG		☐	VTWEG	☐	Distribution Channel
4	SPART	TVTA	SPART		☐	SPART	☐	Division
5	VKORGTEXT	TVKOT	VTEXT	R	☐	VTXTK	☐	Name
6	VTWEGTEXT	TVTWT	VTEXT	R	☐	VTXTK	☐	Name
7	SPARTTEXT	TSPAT	VTEXT	R	☐	VTXTK	☐	Name
8	STATUS_ASSIGN_SD	TASSIGN_SD_VKORG	STATUS_ASSIGN_SD		☐	STATUS_ASSIGN_SD	☐	Status of Assignment in SD Customizing
9	VTWKU	TVTA	VTWKU	H	☐	VTWKU	☐	Reference distrib.channel for cust.and material masters
10	SPAKU	TVTA	SPAKU	H	☐	SPAKU	☐	Reference division for customers
11	VTWKO	TVTA	VTWKO	H	☐	VTWKO	☐	Reference distribution channel for conditions
12	SPAKO	TVTA	SPAKO	H	☐	SPAKO	☐	Reference division for conditions
13	VKOAU	TVTA	VKOAU	H	☐	VKOAU	☐	Reference sales org.for sales doc.types (by sales area)
14	VTWAU	TVTA	VTWAU	H	☐	VTWAU	☐	Distribution channel for sales doc types
15	SPAAU	TVTA	SPAAU	H	☐	SPAAU	☐	Reference division for document types (by sales area)

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