SAP ABAP Table /DSD/VC_VP_TREE (Tree Display, Visit Schedule)

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_VP_TREE	Table Relationship Diagram
Short Description	Tree Display, Visit Schedule

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 Schedule Header
2	.INCLUDE	☐				0	0	DSD: Visit Schedule - Header Data
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	VPID	☐	/DSD/VC_VPID	/DSD/VC_VPID	CHAR	10	0	Visit Plan	*
5	VCTEXT	☐	/DSD/VCTEXT		CHAR	30	0	Name of Visit Schedule/List
6	VPTYP	☐	/DSD/VC_VPTYP	/DSD/VC_VPTYP	CHAR	3	0	Visit Plan Type	/DSD/VC_VPTYPE
7	RULEID	☐	SC_RULEID	TEXT25	CHAR	25	0	Internal Identification of Rules of Periodic Appointments
8	.INCLUDE	☐				0	0	Active Weekdays
9	MONDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
10	TUESDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
11	WEDNESDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
12	THURSDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
13	FRIDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
14	SATURDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
15	SUNDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
16	TRUCK	☐	/DSD/RP_TRUCK	EQUNR	CHAR	18	0	Vehicle	EQUI
17	TRAIL	☐	/DSD/RP_TRAIL	EQUNR	CHAR	18	0	Trailer	EQUI
18	STIME	☐	/DSD/VC_STIME	UZEIT	TIMS	6	0	Start Time
19	STIMEZONE	☐	/DSD/VC_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone	TTZZ
20	SPOINT	☐	/DSD/VC_START	KUNNR	CHAR	10	0	Starting Point of a Tour (Customer, For Example as Plant)	KNA1
21	EPOINT	☐	/DSD/VC_END	KUNNR	CHAR	10	0	End Point of a Tour (Customer, For Example, as Plant)	KNA1
22	DRIVER1	☐	/DSD/RP_DRIVER1	KUNNR	CHAR	10	0	Driver 1	KNA1
23	DRIVER2	☐	/DSD/RP_DRIVER2	KUNNR	CHAR	10	0	Driver 2	KNA1
24	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
25	DATFR	☐	/DSD/VC_DATFR	DATUM	DATS	8	0	Valid from
26	DATTO	☐	/DSD/VC_DATTO	DATUM	DATS	8	0	Valid to
27	LIMFR	☐	/DSD/VC_LIMFR	/DSD/VC_MMDD	DATS	8	0	Valid from (Restricted)
28	LIMTO	☐	/DSD/VC_LIMTO	/DSD/VC_MMDD	DATS	8	0	Valid to (Restricted)
29	AUTH	☐	/DSD/VC_AUTHORITY	/DSD/VC_AUTH	CHAR	10	0	Visit Group	/DSD/VC_AUTH
30	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
31	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
32	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
33	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
34	AEZET	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
35	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
36	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
37	DIST_CHANNEL	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
38	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	*
39	.INCLUDE	☐				0	0	Text Fields of Text Tables for Visit Control
40	VPTYPT	☐	/DSD/VC_VPTYPT	TEXT40	CHAR	40	0	Name of Visit Plan Type
41	AUTHORITYT	☐	/DSD/VC_AUTHORITYT	TEXT40	CHAR	40	0	Name of Visit Group
42	ROUTEBEZ	☐	ROUTBEZ	TEXT40	CHAR	40	0	Description of route
43	TRUCKT	☐	EQKTU	CHAR40	CHAR	40	0	Equipment description in capital letters
44	TRAILT	☐	EQKTU	CHAR40	CHAR	40	0	Equipment description in capital letters
45	DRIVER1_NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
46	DRIVER1_NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
47	DRIVER2_NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
48	DRIVER2_NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
49	SPOINT_NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
50	EPOINT_NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
51	VPPOS	☐	/DSD/VC_VPPOS		NUMC	3	0	Visit Schedule Item Number
52	SEQU	☐	/DSD/VC_SEQU		NUMC	3	0	Sequence
53	KUNNR	☐	/DSD/VC_KUNNR	KUNNR	CHAR	10	0	Customer Number	*
54	RULEID_CUST	☐	SC_RULEID	TEXT25	CHAR	25	0	Internal Identification of Rules of Periodic Appointments
55	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
56	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
57	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
58	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
59	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
60	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
61	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
62	INACTIVE	☐	/DSD/VC_VPINACTIV	XFELD	CHAR	1	0	Inactive Flag (Visit Schedule)
63	DURA	☐	/DSD/VC_DURA	TSTRDURAN	DEC	11	0	Waiting Time
64	DTRVD	☐	/DSD/VC_DTRVD	TSTRDURAN	DEC	11	0	Direct Driving Time
65	TRVD	☐	/DSD/VC_TRVD	TSTRDURAN	DEC	11	0	Driving Time
66	DISTZ	☐	/DSD/VC_DISTZ	MENG13	QUAN	13	3	Distance
67	MEDST	☐	/DSD/VC_MEDST	MEINS	UNIT	3	0	Unit of Measure for Distance	*
68	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
69	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
70	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
71	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
72	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
73	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
74	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	*
75	PARNR	☐	PARNR	PARNR	NUMC	10	0	Number of contact person
76	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
77	FMORE	☐	/DSD/VC_FMORE	XFELD	CHAR	1	0	Flag: Several Contact Persons or Unloading Points Exist
78	VANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
79	VNAME1	☐	NAME1_BAS	NAME	CHAR	35	0	Name 1
80	VNAME2	☐	NAME2_BAS	NAME	CHAR	35	0	Name 2
81	VSTRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
82	VPSTLZ	☐	PSTLZ_BAS	PSTLZ	CHAR	10	0	Postal code
83	VORT	☐	ORT01_GP	TEXT35	CHAR	35	0	City
84	VREGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
85	VLAND	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
86	.INCLUDE	☐				0	0	Visiting Hours or Goods Receiving Hours Each Weekday
87	MOAB1	☐	/DSD/VC_TIMFR1	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Mornings from...
88	MOBI1	☐	/DSD/VC_TIMTO1	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Mornings Until...
89	MOAB2	☐	/DSD/VC_TIMFR2	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Afternoons from...
90	MOBI2	☐	/DSD/VC_TIMTO2	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Afternoons Until...
91	DIAB1	☐	/DSD/VC_TIMFR1	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Mornings from...
92	DIBI1	☐	/DSD/VC_TIMTO1	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Mornings Until...
93	DIAB2	☐	/DSD/VC_TIMFR2	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Afternoons from...
94	DIBI2	☐	/DSD/VC_TIMTO2	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Afternoons Until...
95	MIAB1	☐	/DSD/VC_TIMFR1	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Mornings from...
96	MIBI1	☐	/DSD/VC_TIMTO1	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Mornings Until...
97	MIAB2	☐	/DSD/VC_TIMFR2	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Afternoons from...
98	MIBI2	☐	/DSD/VC_TIMTO2	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Afternoons Until...
99	DOAB1	☐	/DSD/VC_TIMFR1	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Mornings from...
100	DOBI1	☐	/DSD/VC_TIMTO1	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Mornings Until...
101	DOAB2	☐	/DSD/VC_TIMFR2	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Afternoons from...
102	DOBI2	☐	/DSD/VC_TIMTO2	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Afternoons Until...
103	FRAB1	☐	/DSD/VC_TIMFR1	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Mornings from...
104	FRBI1	☐	/DSD/VC_TIMTO1	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Mornings Until...
105	FRAB2	☐	/DSD/VC_TIMFR2	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Afternoons from...
106	FRBI2	☐	/DSD/VC_TIMTO2	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Afternoons Until...
107	SAAB1	☐	/DSD/VC_TIMFR1	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Mornings from...
108	SABI1	☐	/DSD/VC_TIMTO1	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Mornings Until...
109	SAAB2	☐	/DSD/VC_TIMFR2	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Afternoons from...
110	SABI2	☐	/DSD/VC_TIMTO2	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Afternoons Until...
111	SOAB1	☐	/DSD/VC_TIMFR1	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Mornings from...
112	SOBI1	☐	/DSD/VC_TIMTO1	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Mornings Until...
113	SOAB2	☐	/DSD/VC_TIMFR2	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Afternoons from...
114	SOBI2	☐	/DSD/VC_TIMTO2	UZEIT	TIMS	6	0	Visiting Hours or Goods Receiving Hours: Afternoons Until...
115	.INCLUDE	☐				0	0	Shadow Nodes for Tree Controls
116	NODEKEY	☐	TV_NODEKEY	TM_CHAR12	CHAR	12	0	Tree Control: Node Key
117	NODEKEY_PARENT	☐	TV_NODEKEY	TM_CHAR12	CHAR	12	0	Tree Control: Node Key
118	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_VP_TREE	AUTH	/DSD/VC_AUTH	AUTH	REF	1	CN
2	/DSD/VC_VP_TREE	DRIVER1	KNA1	KUNNR
3	/DSD/VC_VP_TREE	DRIVER2	KNA1	KUNNR
4	/DSD/VC_VP_TREE	EPOINT	KNA1	KUNNR	REF	1	CN
5	/DSD/VC_VP_TREE	MANDT	T000	MANDT	KEY	1	CN
6	/DSD/VC_VP_TREE	ROUTE	TVRO	ROUTE
7	/DSD/VC_VP_TREE	SPOINT	KNA1	KUNNR	REF	1	CN
8	/DSD/VC_VP_TREE	STIMEZONE	TTZZ	TZONE	REF	1	CN
9	/DSD/VC_VP_TREE	TRAIL	EQUI	EQUNR
10	/DSD/VC_VP_TREE	TRUCK	EQUI	EQUNR
11	/DSD/VC_VP_TREE	VPTYP	/DSD/VC_VPTYPE	VPTYP

History

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