SAP ABAP View V_TVKBZ_ASSIGN (Assignment Sales Office - Sales Area)

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_TVKBZ_ASSIGN
Short Description	Assignment Sales Office - Sales Area
Root table	TVKBZ	Org.Unit: Sales Office: Assignment to Organizational Unit

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TVKBZ	TVKBZ
2	TVBUR	TVKBZ	VKBUR	E
3	TVKO	TVKBZ	VKORG	E
4	TVKOT	TVKO	VKORG	I
5	TVKBT	TVBUR	VKBUR	I
6	TASSIGN_SD_VKORG	TVKO	VKORG	I
7	TVKOS	TVKBZ	SPART	E
8	TVKOV	TVKBZ	VTWEG	E
9	TVTW	TVKOV	VTWEG	E
10	TSPA	TVKOS	SPART	E
11	TVTWT	TVTW	VTWEG	I
12	TSPAT	TSPA	SPART	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	TVKBZ	MANDT		☐	MANDT	☐	Client
2	VKORG	TVKBZ	VKORG		☐	VKORG	☐	Sales Organization
3	VTWEG	TVKBZ	VTWEG		☐	VTWEG	☐	Distribution Channel
4	SPART	TVKBZ	SPART		☐	SPART	☐	Division
5	VKBUR	TVKBZ	VKBUR		☐	VKBUR	☐	Sales office
6	VKORGTEXT	TVKOT	VTEXT	R	☐	VTXTK	☐	Name
7	VTWEGTEXT	TVTWT	VTEXT	R	☐	VTXTK	☐	Name
8	SPARTTEXT	TSPAT	VTEXT	R	☐	VTXTK	☐	Name
9	VKBURTEXT	TVKBT	BEZEI	R	☐	BEZEI20	☐	Description
10	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