SAP ABAP Table /DSD/VC_VL (Generated Table for View /DSD/VC_VL)

Basic Data

Table Category	VIEW	General view structure
General view structure	/DSD/VC_VL	Table Relationship Diagram
Short Description	Generated Table for View /DSD/VC_VL

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	VLID	☑	/DSD/VC_VLID	/DSD/VC_VLID	CHAR	10	0	Visit List
3	VLPOS	☑	/DSD/VC_VLPOS	/DSD/VC_VLPOS	NUMC	3	0	Item Number: Visit List
4	VPID	☐	/DSD/VC_VPID	/DSD/VC_VPID	CHAR	10	0	Visit Plan	/DSD/VC_VPH
5	VPTYP	☐	/DSD/VC_VPTYP	/DSD/VC_VPTYP	CHAR	3	0	Visit Plan Type	/DSD/VC_VPTYPE
6	TRUCK	☐	/DSD/RP_TRUCK	EQUNR	CHAR	18	0	Vehicle	EQUI
7	TRAIL	☐	/DSD/RP_TRAIL	EQUNR	CHAR	18	0	Trailer	EQUI
8	STIME	☐	/DSD/VC_STIME	UZEIT	TIMS	6	0	Start Time
9	STIMEZONE	☐	/DSD/VC_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone	TTZZ
10	SPOINT	☐	/DSD/VC_START	KUNNR	CHAR	10	0	Starting Point of a Tour (Customer, For Example as Plant)	KNA1
11	EPOINT	☐	/DSD/VC_END	KUNNR	CHAR	10	0	End Point of a Tour (Customer, For Example, as Plant)	KNA1
12	DRIVER1	☐	/DSD/RP_DRIVER1	KUNNR	CHAR	10	0	Driver 1	KNA1
13	DRIVER2	☐	/DSD/RP_DRIVER2	KUNNR	CHAR	10	0	Driver 2	KNA1
14	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	TVRO
15	AUTH	☐	/DSD/VC_AUTHORITY	/DSD/VC_AUTH	CHAR	10	0	Visit Group	/DSD/VC_AUTH
16	EXDAT	☐	/DSD/VC_EXDAT	DATUM	DATS	8	0	Execution Date
17	EXDAT1	☐	/DSD/VC_EXDAT1	DATUM	DATS	8	0	Original Executation Date
18	XLOCK	☐	/DSD/VC_LOCK	XFELD	CHAR	1	0	Lock due to Transport Link
19	INACTIV	☐	/DSD/VC_VLINACTIV	XFELD	CHAR	1	0	Inactive Flag (Visit List)
20	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
21	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
22	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
23	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
24	AEZET	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
25	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
26	SEQU	☐	/DSD/VC_SEQU		NUMC	3	0	Sequence
27	KUNNR	☐	/DSD/VC_KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
28	DURA	☐	/DSD/VC_DURA	TSTRDURAN	DEC	11	0	Waiting Time
29	DTRVD	☐	/DSD/VC_DTRVD	TSTRDURAN	DEC	11	0	Direct Driving Time
30	TRVD	☐	/DSD/VC_TRVD	TSTRDURAN	DEC	11	0	Driving Time
31	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization
32	DIST_CHANNEL	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel
33	DIVISION	☐	SPART	SPART	CHAR	2	0	Division

Foreign Keys

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

History

Last changed by/on	SAP	20050705
SAP Release Created in