SAP ABAP Table VLCDIAVEHI_CONF (VELO : Dialog Structure for Vehicles (with Configuration))

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_CONF	Table Relationship Diagram
Short Description	VELO : Dialog Structure for Vehicles (with Configuration)

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in