SAP ABAP Table VLCSELVEHI (VELO : Fields for Selecting 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	VLCSELVEHI	Table Relationship Diagram
Short Description	VELO : Fields for Selecting 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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	VHCLE	☐	VLC_VHCLE	CHARG	CHAR	10	0	Internal Vehicle Number	*
3	VHVIN	☐	VLC_VHVIN	TEXT35	CHAR	35	0	Vehicle Identification Number (Vehicle Identification No.)
4	VHCEX	☐	VLC_VHCEX	CHAR35	CHAR	35	0	External Vehicle Number
5	MATNR	☐	VLC_MATNR	MATNR	CHAR	18	0	Vehicle Model	*
6	LIFNR	☐	VLC_LIFNR	LIFNR	CHAR	10	0	Vendor	*
7	ENDCU	☐	VLC_ENDCU	BU_PARTNER	CHAR	10	0	End Customer (Central Business Partner)	*
8	KUNNR	☐	VLC_KUNNR	KUNNR	CHAR	10	0	Customer	*
9	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
10	AVAIL	☐	VLC_AVAILABILITY	VLC_AVAILABILITY	CHAR	2	0	Availability Status	*
11	LOCTN	☐	VLC_LOCTN	CHAR10	CHAR	10	0	VMS-Vehicle Location
12	LTEXT	☐	VLC_LOCTNTXT	TEXT30	CHAR	30	0	Description of VMS Vehicle Location
13	MMSTA	☐	VLC_MMSTATU	VLC_STATU	CHAR	4	0	Primary Status	*
14	MMDATU	☐	VLC_MMDATUM	DATUM	DATS	8	0	Date of Primary Status
15	MMTIME	☐	VLC_MMTIME	UZEIT	TIMS	6	0	Time of Primary Status
16	SDSTA	☐	VLC_SDSTATU	VLC_STATU	CHAR	4	0	Secondary Status	*
17	SDDATU	☐	VLC_SDDATUM	DATUM	DATS	8	0	Date of Secondary Status
18	SDTIME	☐	VLC_SDTIME	UZEIT	TIMS	6	0	Time of Secondary Status
19	VACTION	☐	VLC_VACTION	VLC_ACTION	CHAR	4	0	Interlinking Action	*
20	ACTION	☐	VLC_ACTION	VLC_ACTION	CHAR	4	0	Action	*
21	ACTDATU	☐	DATUM	DATUM	DATS	8	0	Date
22	ACTTIME	☐	UZEIT	UZEIT	TIMS	6	0	Time
23	VBELN_CO	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
24	POSNR_CO	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
25	BSTNK_CO	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
26	VBELN_DL	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
27	POSNR_DL	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
28	MBLNR_GI	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
29	MBLPO_GI	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
30	MJAHR_GI	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
31	VBELN_IN	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
32	POSNR_IN	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
33	VBELN_OF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
34	POSNR_OF	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
35	VBELN_IV	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	*
36	POSNR_IV	☐	POSNR_VF	POSNR	NUMC	6	0	Billing item	*
37	VHBLN_OR	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
38	VHPOS_OR	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
39	MBLNR_GR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
40	MJAHR_GR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
41	MBLPO_GR	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
42	LFSNR_GR	☐	LFSNR1	XBLNR1	CHAR	16	0	Number of External Delivery Note
43	FRBNR_GR	☐	FRBNR1	XBLNR1	CHAR	16	0	Number of Bill of Lading at Time of Goods Receipt
44	BELNR_FI	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
45	GJAHR_FI	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
46	RBLGP_FI	☐	RBLGP	NUMC6	NUMC	6	0	Document Item in Invoice Document
47	XBLNR_FI	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
48	SEARCHF	☐	VLC_SEARCHF		CHAR	20	0	General Search Field for Vehicle Search
49	SPROF	☐	VLC_SPROFILE	VLC_SPROFILE	CHAR	8	0	Profile for Vehicle Search
50	PROFT	☐	VLC_SPROFTXT	VLC_SPROFTXT	CHAR	40	0	Description of Search Profile
51	CNAME	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
52	CPCOD	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
53	CCITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
54	LNAME	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
55	LPCOD	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
56	LCITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
57	LCTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
58	LREGI	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
59	PSDATU	☐	VLC_PDATUM	DATUM	DATS	8	0	Planned Delivery Date
60	PSTIME	☐	VLC_PTIME	UZEIT	TIMS	6	0	Planned Time of Delivery
61	PDDATU	☐	VLC_PRODDATUM	DATUM	DATS	8	0	Production Date
62	PDTIME	☐	VLC_PRODTIME	UZEIT	TIMS	6	0	Production Time
63	AQUAL	☐	VLC_ADQUAL	VLC_ADQUAL	CHAR	4	0	Qualifier for Additional Data	*
64	QAUSP	☐	VLC_QTEXT	CHAR50	CHAR	50	0	Qualifier-Characteristic Value
65	VBLTY	☐	VLC_VISIBILITY	VLC_VISIBILITY	CHAR	1	0	Visibility
66	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
67	VHUSG	☐	VLC_VEHIUSAGE	VLC_VEHIUSAGE	CHAR	2	0	Vehicle Usage	*
68	CMPGN	☐	VLC_SALESCAMPAIGN	VLC_SALESCAMPAIGN	CHAR	10	0	Sales Campaign	*
69	GPRICE	☐	VLC_GPRICE		CURR	17	2	Gross List Price of Vehicle
70	GPCURR	☐	VLC_GPRICECUKY	WAERS	CUKY	5	0	Currency of Vehicle Price	TCURC
71	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T001W
72	VAWRK	☐	WERGW	WERKS	CHAR	4	0	Plant associated with main work center	T001W
73	VAPLZ	☐	GEWRK	ARBPL	CHAR	8	0	Main work center for maintenance tasks
74	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
75	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
76	REVFLAG	☐	FLAG	FLAG	CHAR	1	0	General Flag
77	AUFART_SM	☐	AUFART	AUFART	CHAR	4	0	Order Type	T003O
78	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL
79	QMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
80	VBELN_SM	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
81	POSNR_SM	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
82	VBELN_LR	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
83	POSNR_LR	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
84	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
85	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	VLCSELVEHI	AUFART_SM	T003O	AUART
2	VLCSELVEHI	AUFNR	AUFK	AUFNR
3	VLCSELVEHI	GPCURR	TCURC	WAERS		1	CN
4	VLCSELVEHI	IWERK	T001W	WERKS
5	VLCSELVEHI	LCTRY	T005	LAND1
6	VLCSELVEHI	LGORT	T001L	LGORT
7	VLCSELVEHI	POSNR_SM	VBUP	POSNR
8	VLCSELVEHI	QMART	TQ80	QMART
9	VLCSELVEHI	QMNUM	QMEL	QMNUM
10	VLCSELVEHI	VAWRK	T001W	WERKS
11	VLCSELVEHI	VBELN_SM	VBUK	VBELN

History

Last changed by/on	SAP	20130529
SAP Release Created in