SAP ABAP View V_TVBVK_ASSIGN (Assignment Sales Office - Sales Groups)

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_TVBVK_ASSIGN
Short Description	Assignment Sales Office - Sales Groups
Root table	TVBVK	Organizational Unit: Sales Groups per Sales Office

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TVBVK	TVBVK
2	TVBUR	TVBVK	VKBUR	E
3	TVKGR	TVBVK	VKGRP	E
4	TVKBT	TVBUR	VKBUR	I
5	TVGRT	TVKGR	VKGRP	I
6	TASSIGN_SD_VKBUR	TVBUR	VKBUR	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	TVBVK	MANDT		☐	MANDT	☐	Client
2	VKBUR	TVBVK	VKBUR		☐	VKBUR	☐	Sales office
3	VKGRP	TVBVK	VKGRP		☐	VKGRP	☐	Sales group
4	VKBURTEXT	TVKBT	BEZEI	R	☐	BEZEI20	☐	Description
5	VKGRPTEXT	TVGRT	BEZEI	R	☐	BEZEI20	☐	Description
6	STATUS_ASSIGN_SD	TASSIGN_SD_VKBUR	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