SAP ABAP Table VLCVEHICLE (VELO: Vehicle)

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	TRANSP	Transparent table
Transparent table	VLCVEHICLE	Table Relationship Diagram
Short Description	VELO: Vehicle

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	VGUID	☑	VLC_GUID	SYSUUID_22	CHAR	22	0	Vehicle GUID (Globally Unique IDentifier)
3	VHCLE	☐	VLC_VHCLE	CHARG	CHAR	10	0	Internal Vehicle Number	*
4	MATNR	☐	VLC_MATNR	MATNR	CHAR	18	0	Vehicle Model	MARA
5	LIFNR	☐	VLC_LIFNR	LIFNR	CHAR	10	0	Vendor	LFA1
6	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
7	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
8	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
9	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
10	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	MBEW
11	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
12	CUABA	☐	VLC_ACTDOCTYPE	VLC_ACTDOCTYPE	CHAR	4	0	Type of Document for Action
13	MMCTR	☐	VLC_CNTRL	VLC_CNTRL	CHAR	4	0	Action Control	CVLC01
14	MMSTA	☐	VLC_MMSTATU	VLC_STATU	CHAR	4	0	Primary Status	CVLC02
15	MMTSP	☐	VLC_LTSTAMP	TZNTSTMPL	DEC	21	7	Long Time Stamp
16	SDCTR	☐	VLC_CNTRL	VLC_CNTRL	CHAR	4	0	Action Control	CVLC01
17	SDSTA	☐	VLC_SDSTATU	VLC_STATU	CHAR	4	0	Secondary Status	CVLC02
18	SDTSP	☐	VLC_LTSTAMP	TZNTSTMPL	DEC	21	7	Long Time Stamp
19	KUNNR	☐	VLC_KUNNR	KUNNR	CHAR	10	0	Customer	KNA1
20	ENDCU	☐	VLC_ENDCU	BU_PARTNER	CHAR	10	0	End Customer (Central Business Partner)	BUT000
21	.INCLUDE	☐				0	0	VELO : Additional Data in the vlcvehicle for Vehicle
22	VHVIN	☐	VLC_VHVIN	TEXT35	CHAR	35	0	Vehicle Identification Number (Vehicle Identification No.)
23	VHCEX	☐	VLC_VHCEX	CHAR35	CHAR	35	0	External Vehicle Number
24	AVAIL	☐	VLC_AVAILABILITY	VLC_AVAILABILITY	CHAR	2	0	Availability Status	CVLC10
25	VBLTY	☐	VLC_VISIBILITY	VLC_VISIBILITY	CHAR	1	0	Visibility
26	LOCTN	☐	VLC_LOCTN	CHAR10	CHAR	10	0	VMS-Vehicle Location
27	GPRICE	☐	VLC_GPRICE		CURR	17	2	Gross List Price of Vehicle
28	GPRICECUKY	☐	VLC_GPRICECUKY	WAERS	CUKY	5	0	Currency of Vehicle Price	TCURC
29	CDTSP	☐	VLC_CTSTAMP	TZNTSTMPS	DEC	15	0	Time Stamp for Confirmed Delivery Date
30	PSTSP	☐	VLC_PTSTAMP	TZNTSTMPS	DEC	15	0	Time Stamp for Planned Delivery Time
31	PDTSP	☐	VLC_PRODTSTAMP	TZNTSTMPS	DEC	15	0	Time Stamp for Production Time
32	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
33	VHUSG	☐	VLC_VEHIUSAGE	VLC_VEHIUSAGE	CHAR	2	0	Vehicle Usage	CVLC13
34	CMPGN	☐	VLC_SALESCAMPAIGN	VLC_SALESCAMPAIGN	CHAR	10	0	Sales Campaign	VLCSCAMPGN
35	PCOUNT	☐	VLC_PCOUNT	VLC_PCOUNT	QUAN	7	0	Counter Reading
36	PCOUNT_U	☐	FLEET_COUNT_UNIT	MEINS	UNIT	3	0	Fleet counter unit	T006
37	IMMATDATE	☐	VLC_IMMATDATE	DATE	DATS	8	0	Initial Registration Date
38	VHSAR	☐	VLC_VHSAR	VLC_VHSAR	CHAR	10	0	Vehicle Search Area	CVLC18
39	VHORD	☐	VLC_VHORD	KUNNR	CHAR	10	0	Original Ordering Party of Vehicle	KNA1
40	SHLVL	☐	VLC_SHLVL	VLC_SHLVL	CHAR	2	0	Sharing Levels for Vehicle Search	CVLC27
41	ARCHIVE_FLAG	☐	VLC_ARCHIVE_VEHICLE	XFELD	CHAR	1	0	Archiving
42	USED_VEHICLE	☐	VLC_USED_FLAG	XFELD	CHAR	1	0	Flag That Indicates That the Vehicle Is a Used Vehicle

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in