SAP ABAP Table VLCDIAVEHI (VELO: Dialog Structure for Vehicles)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-A-VMS (Application Component) Vehicle Management System
     ⤷ ISAUTO_VLC (Package) Vehicle Management System (VMS)

Basic Data

Table Category	INTTAB	Structure
Structure	VLCDIAVEHI	Table Relationship Diagram
Short Description	VELO: Dialog Structure for Vehicles

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	VELO: Vehicle
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	VGUID	☐	VLC_GUID	SYSUUID_22	CHAR	22	0	Vehicle GUID (Globally Unique IDentifier)
4	VHCLE	☐	VLC_VHCLE	CHARG	CHAR	10	0	Internal Vehicle Number	*
5	MATNR	☐	VLC_MATNR	MATNR	CHAR	18	0	Vehicle Model	MARA
6	LIFNR	☐	VLC_LIFNR	LIFNR	CHAR	10	0	Vendor	LFA1
7	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
8	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
9	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
10	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
11	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	MBEW
12	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
13	CUABA	☐	VLC_ACTDOCTYPE	VLC_ACTDOCTYPE	CHAR	4	0	Type of Document for Action
14	MMCTR	☐	VLC_CNTRL	VLC_CNTRL	CHAR	4	0	Action Control	CVLC01
15	MMSTA	☐	VLC_MMSTATU	VLC_STATU	CHAR	4	0	Primary Status	CVLC02
16	MMTSP	☐	VLC_LTSTAMP	TZNTSTMPL	DEC	21	7	Long Time Stamp
17	SDCTR	☐	VLC_CNTRL	VLC_CNTRL	CHAR	4	0	Action Control	CVLC01
18	SDSTA	☐	VLC_SDSTATU	VLC_STATU	CHAR	4	0	Secondary Status	CVLC02
19	SDTSP	☐	VLC_LTSTAMP	TZNTSTMPL	DEC	21	7	Long Time Stamp
20	KUNNR	☐	VLC_KUNNR	KUNNR	CHAR	10	0	Customer	KNA1
21	ENDCU	☐	VLC_ENDCU	BU_PARTNER	CHAR	10	0	End Customer (Central Business Partner)	BUT000
22	.INCLUDE	☐				0	0	VELO : Additional Data in the vlcvehicle for Vehicle
23	VHVIN	☐	VLC_VHVIN	TEXT35	CHAR	35	0	Vehicle Identification Number (Vehicle Identification No.)
24	VHCEX	☐	VLC_VHCEX	CHAR35	CHAR	35	0	External Vehicle Number
25	AVAIL	☐	VLC_AVAILABILITY	VLC_AVAILABILITY	CHAR	2	0	Availability Status	CVLC10
26	VBLTY	☐	VLC_VISIBILITY	VLC_VISIBILITY	CHAR	1	0	Visibility
27	LOCTN	☐	VLC_LOCTN	CHAR10	CHAR	10	0	VMS-Vehicle Location
28	GPRICE	☐	VLC_GPRICE		CURR	17	2	Gross List Price of Vehicle
29	GPRICECUKY	☐	VLC_GPRICECUKY	WAERS	CUKY	5	0	Currency of Vehicle Price	TCURC
30	CDTSP	☐	VLC_CTSTAMP	TZNTSTMPS	DEC	15	0	Time Stamp for Confirmed Delivery Date
31	PSTSP	☐	VLC_PTSTAMP	TZNTSTMPS	DEC	15	0	Time Stamp for Planned Delivery Time
32	PDTSP	☐	VLC_PRODTSTAMP	TZNTSTMPS	DEC	15	0	Time Stamp for Production Time
33	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
34	VHUSG	☐	VLC_VEHIUSAGE	VLC_VEHIUSAGE	CHAR	2	0	Vehicle Usage	CVLC13
35	CMPGN	☐	VLC_SALESCAMPAIGN	VLC_SALESCAMPAIGN	CHAR	10	0	Sales Campaign	VLCSCAMPGN
36	PCOUNT	☐	VLC_PCOUNT	VLC_PCOUNT	QUAN	7	0	Counter Reading
37	PCOUNT_U	☐	FLEET_COUNT_UNIT	MEINS	UNIT	3	0	Fleet counter unit	T006
38	IMMATDATE	☐	VLC_IMMATDATE	DATE	DATS	8	0	Initial Registration Date
39	VHSAR	☐	VLC_VHSAR	VLC_VHSAR	CHAR	10	0	Vehicle Search Area	CVLC18
40	VHORD	☐	VLC_VHORD	KUNNR	CHAR	10	0	Original Ordering Party of Vehicle	KNA1
41	SHLVL	☐	VLC_SHLVL	VLC_SHLVL	CHAR	2	0	Sharing Levels for Vehicle Search	CVLC27
42	ARCHIVE_FLAG	☐	VLC_ARCHIVE_VEHICLE	XFELD	CHAR	1	0	Archiving
43	USED_VEHICLE	☐	VLC_USED_FLAG	XFELD	CHAR	1	0	Flag That Indicates That the Vehicle Is a Used Vehicle
44	MMDATU	☐	VLC_MMDATUM	DATUM	DATS	8	0	Date of Primary Status
45	MMTIME	☐	VLC_MMTIME	UZEIT	TIMS	6	0	Time of Primary Status
46	SDDATU	☐	VLC_SDDATUM	DATUM	DATS	8	0	Date of Secondary Status
47	SDTIME	☐	VLC_SDTIME	UZEIT	TIMS	6	0	Time of Secondary Status
48	CDDATE	☐	VLC_CDATE	DATUM	DATS	8	0	Confirmed Delivery Date (According to CTP Logic)
49	CDTIME	☐	VLC_CTIME	UZEIT	TIMS	6	0	Confirmed Time on Delivery Date
50	PSDATU	☐	VLC_PDATUM	DATUM	DATS	8	0	Planned Delivery Date
51	PSTIME	☐	VLC_PTIME	UZEIT	TIMS	6	0	Planned Time of Delivery
52	PDDATU	☐	VLC_PRODDATUM	DATUM	DATS	8	0	Production Date
53	PDTIME	☐	VLC_PRODTIME	UZEIT	TIMS	6	0	Production Time
54	CSTRYEAR	☐	VLC_YEAR_OF_CONSTRUCTION	GJAHR	NUMC	4	0	Construction Year of Vehicle
55	CSTRMONTH	☐	VLC_MONTH	VLC_MONTH	NUMC	2	0	Month of Construction of Vehicle
56	.INCLUDE	☐				0	0	VELO : Short Texts
57	MATNRTXT	☐	VLC_MAKTX	TEXT40	CHAR	40	0	Description of Vehicle Model
58	MMCTRTXT	☐	VLC_MMCNTRLT	TEXT40	CHAR	40	0	Description of Primary Action Control
59	MMSTATXT	☐	VLC_MMSTATUT	TEXT40	CHAR	40	0	Description of Primary Status
60	SDCTRTXT	☐	VLC_SDCNTRLT	TEXT40	CHAR	40	0	Description of Secondary Action Control
61	SDSTATXT	☐	VLC_SDSTATUT	TEXT40	CHAR	40	0	Description of Secondary Status
62	AVAILTXT	☐	VLC_AVAILABILITYT	TEXT40	CHAR	40	0	Description of Availability Status
63	LOCTNCITY	☐	VLC_LOCTNCITY	TEXT30	CHAR	30	0	Vehicle Location (City)
64	LOCTNTXT	☐	VLC_LOCTNTXT	TEXT30	CHAR	30	0	Description of VMS Vehicle Location
65	VHUSGTXT	☐	VLC_VEHIUSAGET	TEXT40	CHAR	40	0	Description of Vehicle Usage
66	VBLTYTXT	☐	VLC_VISIBILITYT	TEXT40	CHAR	40	0	Description of Visibility
67	SHLVL_TXT	☐	VLC_SHLVL_TXT	TEXT60	CHAR	60	0	Access Authorization Description During Vehicle Search
68	VHSARTXT	☐	VLC_VHSAR_TXT	TEXT30	CHAR	30	0	Vehicle Search Area Description
69	CMPGNTXT	☐	VLC_SALESCAMPAIGNT	TEXT40	CHAR	40	0	Description of Sales Campaign
70	ENDCUTXT	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
71	CU_NAME1	☐	VLC_CU_NAME1_GP	NAME	CHAR	35	0	Name of Customer
72	SU_NAME1	☐	VLC_SU_NAME1_GP	NAME	CHAR	35	0	Name of Vendor
73	CONVPRICE	☐	VLC_GPRICE		CURR	17	2	Gross List Price of Vehicle
74	CONVPRICECUKY	☐	VLC_GPRICECUKY	WAERS	CUKY	5	0	Currency of Vehicle Price	*
75	XERROR	☐	VLC_XERROR	XFLAG	CHAR	1	0	Error Indicator
76	ACTLED	☐	VLC_ACTLED	SYCHAR132	CHAR	132	0	Success Indicator
77	NEWTSP	☐	VLC_LTSTAMP	TZNTSTMPL	DEC	21	7	Long Time Stamp
78	ACTDOCTYPE	☐	VLC_ACTDOCTYPE	VLC_ACTDOCTYPE	CHAR	4	0	Type of Document for Action
79	CATEGORY	☐	VLC_CATEGORY	BOOL_ID	CHAR	11	0	Category for Vehicle Search	*
80	ACTERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
81	PREV_VHCLE	☐	VLC_PREV_VHCLE	CHARG	CHAR	10	0	Preceding Internal Vehicle Number (New Vehicle)	*
82	FOLL_VHCLE	☐	VLC_FOLL_VHCLE	CHARG	CHAR	10	0	Following Internal Vehicle Number (Used Vehicle)	*
83	.INCLUDE	☐				0	0	VELO: Dialog Structure for SD documents
84	.INCLUDE	☐				0	0	VELO: SD document (Header Data)
85	VBELN	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
86	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
87	TIMESTAMP	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VLCDIAVEHI	AVAIL	CVLC10	AVAIL
2	VLCDIAVEHI	BWTAR	MBEW	BWTAR
3	VLCDIAVEHI	CHARG	MCH1	CHARG
4	VLCDIAVEHI	CMPGN	VLCSCAMPGN	CMPGN		1	CN
5	VLCDIAVEHI	ENDCU	BUT000	PARTNER
6	VLCDIAVEHI	EQUNR	EQUI	EQUNR
7	VLCDIAVEHI	GPRICECUKY	TCURC	WAERS
8	VLCDIAVEHI	KUNNR	KNA1	KUNNR		1	CN
9	VLCDIAVEHI	LGORT	T001L	LGORT
10	VLCDIAVEHI	LIFNR	LFA1	LIFNR		1	CN
11	VLCDIAVEHI	MANDT	T000	MANDT
12	VLCDIAVEHI	MATNR	MARA	MATNR
13	VLCDIAVEHI	MMCTR	CVLC01	CNTRL		1	CN
14	VLCDIAVEHI	MMSTA	CVLC02	STATU		1	CN
15	VLCDIAVEHI	PCOUNT_U	T006	MSEHI		1	CN
16	VLCDIAVEHI	SDCTR	CVLC01	CNTRL		1	CN
17	VLCDIAVEHI	SDSTA	CVLC02	STATU		1	CN
18	VLCDIAVEHI	SHLVL	CVLC27	SHLVL
19	VLCDIAVEHI	VHORD	KNA1	KUNNR
20	VLCDIAVEHI	VHSAR	CVLC18	VHSAR		1	CN
21	VLCDIAVEHI	VHUSG	CVLC13	VHUSG		1	CN
22	VLCDIAVEHI	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in