SAP ABAP Table /DSD/VC_VL_TREE (Tree Display: Visit List)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ LE-DSD-VC (Application Component) Visit Control
     ⤷ /DSD/VC (Package) Visit Control

Basic Data

Table Category	INTTAB	Structure
Structure	/DSD/VC_VL_TREE	Table Relationship Diagram
Short Description	Tree Display: Visit List

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Tree Display: Visit List Header
2	.INCLUDE	☐				0	0	DSD: Visit List - Header Data
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	VLID	☐	/DSD/VC_VLID	/DSD/VC_VLID	CHAR	10	0	Visit List	*
5	EXDAT	☐	/DSD/VC_EXDAT	DATUM	DATS	8	0	Execution Date
6	VCTEXT	☐	/DSD/VCTEXT		CHAR	30	0	Name of Visit Schedule/List
7	VPID	☐	/DSD/VC_VPID	/DSD/VC_VPID	CHAR	10	0	Visit Plan	/DSD/VC_VPH
8	VPTYP	☐	/DSD/VC_VPTYP	/DSD/VC_VPTYP	CHAR	3	0	Visit Plan Type	/DSD/VC_VPTYPE
9	TRUCK	☐	/DSD/RP_TRUCK	EQUNR	CHAR	18	0	Vehicle	EQUI
10	TRAIL	☐	/DSD/RP_TRAIL	EQUNR	CHAR	18	0	Trailer	EQUI
11	STIME	☐	/DSD/VC_STIME	UZEIT	TIMS	6	0	Start Time
12	STIMEZONE	☐	/DSD/VC_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone	TTZZ
13	SPOINT	☐	/DSD/VC_START	KUNNR	CHAR	10	0	Starting Point of a Tour (Customer, For Example as Plant)	KNA1
14	EPOINT	☐	/DSD/VC_END	KUNNR	CHAR	10	0	End Point of a Tour (Customer, For Example, as Plant)	KNA1
15	DRIVER1	☐	/DSD/RP_DRIVER1	KUNNR	CHAR	10	0	Driver 1	KNA1
16	DRIVER2	☐	/DSD/RP_DRIVER2	KUNNR	CHAR	10	0	Driver 2	KNA1
17	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
18	AUTH	☐	/DSD/VC_AUTHORITY	/DSD/VC_AUTH	CHAR	10	0	Visit Group	/DSD/VC_AUTH
19	EXDAT1	☐	/DSD/VC_EXDAT1	DATUM	DATS	8	0	Original Executation Date
20	XLOCK	☐	/DSD/VC_LOCK	XFELD	CHAR	1	0	Lock due to Transport Link
21	INACTIV	☐	/DSD/VC_VLINACTIV	XFELD	CHAR	1	0	Inactive Flag (Visit List)
22	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
23	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
24	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
25	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
26	AEZET	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
27	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
28	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
29	DIST_CHANNEL	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
30	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	*
31	.INCLUDE	☐				0	0	Text Fields of Text Tables for Visit Control
32	VPTYPT	☐	/DSD/VC_VPTYPT	TEXT40	CHAR	40	0	Name of Visit Plan Type
33	AUTHORITYT	☐	/DSD/VC_AUTHORITYT	TEXT40	CHAR	40	0	Name of Visit Group
34	ROUTEBEZ	☐	ROUTBEZ	TEXT40	CHAR	40	0	Description of route
35	TRUCKT	☐	EQKTU	CHAR40	CHAR	40	0	Equipment description in capital letters
36	TRAILT	☐	EQKTU	CHAR40	CHAR	40	0	Equipment description in capital letters
37	DRIVER1_NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
38	DRIVER1_NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
39	DRIVER2_NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
40	DRIVER2_NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
41	SPOINT_NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
42	EPOINT_NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
43	VLPOS	☐	/DSD/VC_VLPOS	/DSD/VC_VLPOS	NUMC	3	0	Item Number: Visit List	*
44	SEQU	☐	/DSD/VC_SEQU		NUMC	3	0	Sequence
45	KUNNR	☐	/DSD/VC_KUNNR	KUNNR	CHAR	10	0	Customer Number	*
46	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
47	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
48	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
49	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
50	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
51	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
52	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
53	DURA	☐	/DSD/VC_DURA	TSTRDURAN	DEC	11	0	Waiting Time
54	DTRVD	☐	/DSD/VC_DTRVD	TSTRDURAN	DEC	11	0	Direct Driving Time
55	TRVD	☐	/DSD/VC_TRVD	TSTRDURAN	DEC	11	0	Driving Time
56	DISTZ	☐	/DSD/VC_DISTZ	MENG13	QUAN	13	3	Distance
57	MEDST	☐	/DSD/VC_MEDST	MEINS	UNIT	3	0	Unit of Measure for Distance	*
58	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
59	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
60	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
61	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
62	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
63	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
64	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	*
65	PARNR	☐	PARNR	PARNR	NUMC	10	0	Number of contact person
66	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
67	FMORE	☐	/DSD/VC_FMORE	XFELD	CHAR	1	0	Flag: Several Contact Persons or Unloading Points Exist
68	VANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
69	VNAME1	☐	NAME1_BAS	NAME	CHAR	35	0	Name 1
70	VNAME2	☐	NAME2_BAS	NAME	CHAR	35	0	Name 2
71	VSTRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
72	VPSTLZ	☐	PSTLZ_BAS	PSTLZ	CHAR	10	0	Postal code
73	VORT	☐	ORT01_GP	TEXT35	CHAR	35	0	City
74	VREGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
75	VLAND	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
76	TIMFR1	☐	/DSD/VC_TIMFR1	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Mornings from...
77	TIMTO1	☐	/DSD/VC_TIMTO1	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Mornings Until...
78	TIMFR2	☐	/DSD/VC_TIMFR2	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Afternoons from...
79	TIMTO2	☐	/DSD/VC_TIMTO2	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Afternoons Until...
80	.INCLUDE	☐				0	0	Shadow Nodes for Tree Controls
81	NODEKEY	☐	TV_NODEKEY	TM_CHAR12	CHAR	12	0	Tree Control: Node Key
82	NODEKEY_PARENT	☐	TV_NODEKEY	TM_CHAR12	CHAR	12	0	Tree Control: Node Key
83	ROOT_NODE_FLAG	☐			CHAR	1	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/DSD/VC_VL_TREE	AUTH	/DSD/VC_AUTH	AUTH	REF	1	CN
2	/DSD/VC_VL_TREE	DRIVER1	KNA1	KUNNR	REF	1	CN
3	/DSD/VC_VL_TREE	DRIVER2	KNA1	KUNNR	REF	1	CN
4	/DSD/VC_VL_TREE	EPOINT	KNA1	KUNNR	REF	1	CN
5	/DSD/VC_VL_TREE	MANDT	T000	MANDT	KEY	1	CN
6	/DSD/VC_VL_TREE	ROUTE	TVRO	ROUTE	REF	1	CN
7	/DSD/VC_VL_TREE	SPOINT	KNA1	KUNNR	REF	1	CN
8	/DSD/VC_VL_TREE	STIMEZONE	TTZZ	TZONE	REF	1	CN
9	/DSD/VC_VL_TREE	TRAIL	EQUI	EQUNR	REF	1	CN
10	/DSD/VC_VL_TREE	TRUCK	EQUI	EQUNR	REF	1	CN
11	/DSD/VC_VL_TREE	VPID	/DSD/VC_VPH	VPID	REF	1	CN
12	/DSD/VC_VL_TREE	VPTYP	/DSD/VC_VPTYPE	VPTYP	REF	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in	200