SAP ABAP Table /DSD/VC_VPH_TREE (Tree Display: Visit Schedule Header)

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_VPH_TREE	Table Relationship Diagram
Short Description	Tree Display: Visit Schedule Header

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	DSD: Visit Schedule - Header Data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	VPID	☐	/DSD/VC_VPID	/DSD/VC_VPID	CHAR	10	0	Visit Plan	*
4	VCTEXT	☐	/DSD/VCTEXT		CHAR	30	0	Name of Visit Schedule/List
5	VPTYP	☐	/DSD/VC_VPTYP	/DSD/VC_VPTYP	CHAR	3	0	Visit Plan Type	/DSD/VC_VPTYPE
6	RULEID	☐	SC_RULEID	TEXT25	CHAR	25	0	Internal Identification of Rules of Periodic Appointments
7	.INCLUDE	☐				0	0	Active Weekdays
8	MONDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
9	TUESDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
10	WEDNESDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
11	THURSDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
12	FRIDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
13	SATURDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
14	SUNDAY	☐	SC_RULEWD	CHAR1	CHAR	1	0	Is this weekday active?
15	TRUCK	☐	/DSD/RP_TRUCK	EQUNR	CHAR	18	0	Vehicle	EQUI
16	TRAIL	☐	/DSD/RP_TRAIL	EQUNR	CHAR	18	0	Trailer	EQUI
17	STIME	☐	/DSD/VC_STIME	UZEIT	TIMS	6	0	Start Time
18	STIMEZONE	☐	/DSD/VC_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone	TTZZ
19	SPOINT	☐	/DSD/VC_START	KUNNR	CHAR	10	0	Starting Point of a Tour (Customer, For Example as Plant)	KNA1
20	EPOINT	☐	/DSD/VC_END	KUNNR	CHAR	10	0	End Point of a Tour (Customer, For Example, as Plant)	KNA1
21	DRIVER1	☐	/DSD/RP_DRIVER1	KUNNR	CHAR	10	0	Driver 1	KNA1
22	DRIVER2	☐	/DSD/RP_DRIVER2	KUNNR	CHAR	10	0	Driver 2	KNA1
23	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
24	DATFR	☐	/DSD/VC_DATFR	DATUM	DATS	8	0	Valid from
25	DATTO	☐	/DSD/VC_DATTO	DATUM	DATS	8	0	Valid to
26	LIMFR	☐	/DSD/VC_LIMFR	/DSD/VC_MMDD	DATS	8	0	Valid from (Restricted)
27	LIMTO	☐	/DSD/VC_LIMTO	/DSD/VC_MMDD	DATS	8	0	Valid to (Restricted)
28	AUTH	☐	/DSD/VC_AUTHORITY	/DSD/VC_AUTH	CHAR	10	0	Visit Group	/DSD/VC_AUTH
29	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
30	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
31	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
32	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
33	AEZET	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
34	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
35	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
36	DIST_CHANNEL	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
37	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	*
38	.INCLUDE	☐				0	0	Text Fields of Text Tables for Visit Control
39	VPTYPT	☐	/DSD/VC_VPTYPT	TEXT40	CHAR	40	0	Name of Visit Plan Type
40	AUTHORITYT	☐	/DSD/VC_AUTHORITYT	TEXT40	CHAR	40	0	Name of Visit Group
41	ROUTEBEZ	☐	ROUTBEZ	TEXT40	CHAR	40	0	Description of route
42	TRUCKT	☐	EQKTU	CHAR40	CHAR	40	0	Equipment description in capital letters
43	TRAILT	☐	EQKTU	CHAR40	CHAR	40	0	Equipment description in capital letters
44	DRIVER1_NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
45	DRIVER1_NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
46	DRIVER2_NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
47	DRIVER2_NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
48	SPOINT_NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
49	EPOINT_NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1

Foreign Keys

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

History

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