SAP ABAP Table VLCVEHICLE2 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VLCVEHICLE2	Table Relationship Diagram
Short Description	Generated Table for View

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	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	VHVIN	☐	VLC_VHVIN	TEXT35	CHAR	35	0	Vehicle Identification Number (Vehicle Identification No.)
22	VHCEX	☐	VLC_VHCEX	CHAR35	CHAR	35	0	External Vehicle Number
23	AVAIL	☐	VLC_AVAILABILITY	VLC_AVAILABILITY	CHAR	2	0	Availability Status	CVLC10
24	VBLTY	☐	VLC_VISIBILITY	VLC_VISIBILITY	CHAR	1	0	Visibility
25	LOCTN	☐	VLC_LOCTN	CHAR10	CHAR	10	0	VMS-Vehicle Location
26	GPRICE	☐	VLC_GPRICE		CURR	17	2	Gross List Price of Vehicle
27	GPRICECUKY	☐	VLC_GPRICECUKY	WAERS	CUKY	5	0	Currency of Vehicle Price	TCURC
28	CDTSP	☐	VLC_CTSTAMP	TZNTSTMPS	DEC	15	0	Time Stamp for Confirmed Delivery Date
29	PSTSP	☐	VLC_PTSTAMP	TZNTSTMPS	DEC	15	0	Time Stamp for Planned Delivery Time
30	PDTSP	☐	VLC_PRODTSTAMP	TZNTSTMPS	DEC	15	0	Time Stamp for Production Time
31	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
32	VHUSG	☐	VLC_VEHIUSAGE	VLC_VEHIUSAGE	CHAR	2	0	Vehicle Usage	CVLC13
33	CMPGN	☐	VLC_SALESCAMPAIGN	VLC_SALESCAMPAIGN	CHAR	10	0	Sales Campaign	VLCSCAMPGN
34	PCOUNT	☐	VLC_PCOUNT	VLC_PCOUNT	QUAN	7	0	Counter Reading
35	PCOUNT_U	☐	FLEET_COUNT_UNIT	MEINS	UNIT	3	0	Fleet counter unit	T006
36	IMMATDATE	☐	VLC_IMMATDATE	DATE	DATS	8	0	Initial Registration Date
37	VHSAR	☐	VLC_VHSAR	VLC_VHSAR	CHAR	10	0	Vehicle Search Area	CVLC18
38	VHORD	☐	VLC_VHORD	KUNNR	CHAR	10	0	Original Ordering Party of Vehicle	KNA1
39	SHLVL	☐	VLC_SHLVL	VLC_SHLVL	CHAR	2	0	Sharing Levels for Vehicle Search	CVLC27
40	ARCHIVE_FLAG	☐	VLC_ARCHIVE_VEHICLE	XFELD	CHAR	1	0	Archiving
41	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	VLCVEHICLE2	AVAIL	CVLC10	AVAIL
2	VLCVEHICLE2	BWTAR	MBEW	BWTAR
3	VLCVEHICLE2	CHARG	MCH1	CHARG
4	VLCVEHICLE2	CMPGN	VLCSCAMPGN	CMPGN		1	CN
5	VLCVEHICLE2	ENDCU	BUT000	PARTNER
6	VLCVEHICLE2	EQUNR	EQUI	EQUNR
7	VLCVEHICLE2	GPRICECUKY	TCURC	WAERS
8	VLCVEHICLE2	KUNNR	KNA1	KUNNR		1	CN
9	VLCVEHICLE2	LGORT	T001L	LGORT
10	VLCVEHICLE2	LIFNR	LFA1	LIFNR		1	CN
11	VLCVEHICLE2	MANDT	T000	MANDT
12	VLCVEHICLE2	MATNR	MARA	MATNR
13	VLCVEHICLE2	MMCTR	CVLC01	CNTRL		1	CN
14	VLCVEHICLE2	MMSTA	CVLC02	STATU		1	CN
15	VLCVEHICLE2	PCOUNT_U	T006	MSEHI		1	CN
16	VLCVEHICLE2	SDCTR	CVLC01	CNTRL		1	CN
17	VLCVEHICLE2	SDSTA	CVLC02	STATU		1	CN
18	VLCVEHICLE2	SHLVL	CVLC27	SHLVL
19	VLCVEHICLE2	VHORD	KNA1	KUNNR
20	VLCVEHICLE2	VHSAR	CVLC18	VHSAR		1	CN
21	VLCVEHICLE2	VHUSG	CVLC13	VHUSG		1	CN
22	VLCVEHICLE2	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in