SAP ABAP Table MGV_VLCVEHICLE2 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	MGV_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
42	MATNR_EXT	☐	MATNR_EXT	MATNR_EXT	CHAR	40	0	External Long Material Number
43	MATNR_VERS	☐	MATNR_VERS	MATNR_VERS	CHAR	10	0	Material Version Number

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in