SAP VLCVEHICLE VELO : Vehicle Table
Overview
VLCVEHICLE is a standard SAP S/4HANA table that stores VELO : Vehicle data. There are total 40 fields in the VLCVEHICLE table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VLCVEHICLE belongs to Vehicle Management System (IS-A-VMS) module and is located in the package Vehicle Management System (VMS) (ISAUTO_VLC).
In addition, following links provide an overview of foreign key relationships, if any, that link VLCVEHICLE to other SAP tables and standard CDS views available based on VLCVEHICLE table in S/4HANA 2020.
Techincal Settings of VLCVEHICLE
Below are technical details of the table VLCVEHICLE
- Buffering not allowed
- No buffering
- Storage type is Not Defined
List of VLCVEHICLE Fields
The following table gives you an overview of the fields available in VLCVEHICLE
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| VGUID | Vehicle GUID (Globally Unique IDentifier) | VLC_GUID | CHAR | 22 | |
| VHCLE | Internal Vehicle Number | VLC_VHCLE | CHAR | 10 | |
| MATNR | Vehicle Model | VLC_MATNR | MARA | CHAR | 40 |
| LIFNR | Vendor | VLC_LIFNR | LFA1 | CHAR | 10 |
| CHARG | Batch Number | CHARG_D | MCH1 | CHAR | 10 |
| EQUNR | Equipment Number | EQUNR | EQUI | CHAR | 18 |
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 |
| LGORT | Storage location | LGORT_D | T001L | CHAR | 4 |
| BWTAR | Valuation Type | BWTAR_D | MBEW | CHAR | 10 |
| CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | |
| CUABA | Type of Document for Action | VLC_ACTDOCTYPE | CHAR | 4 | |
| MMCTR | Action Control | VLC_CNTRL | CVLC01 | CHAR | 4 |
| MMSTA | Primary Status | VLC_MMSTATU | CVLC02 | CHAR | 4 |
| MMTSP | Long Time Stamp | VLC_LTSTAMP | DEC | 21 | |
| SDCTR | Action Control | VLC_CNTRL | CVLC01 | CHAR | 4 |
| SDSTA | Secondary Status | VLC_SDSTATU | CVLC02 | CHAR | 4 |
| SDTSP | Long Time Stamp | VLC_LTSTAMP | DEC | 21 | |
| KUNNR | Customer | VLC_KUNNR | KNA1 | CHAR | 10 |
| ENDCU | End Customer (Central Business Partner) | VLC_ENDCU | BUT000 | CHAR | 10 |
| VHVIN | Vehicle Identification Number (Vehicle Identification No.) | VLC_VHVIN | CHAR | 35 | |
| VHCEX | External Vehicle Number | VLC_VHCEX | CHAR | 35 | |
| AVAIL | Availability Status | VLC_AVAILABILITY | CVLC10 | CHAR | 2 |
| VBLTY | Visibility | VLC_VISIBILITY | CHAR | 1 | |
| LOCTN | VMS-Vehicle Location | VLC_LOCTN | CHAR | 10 | |
| GPRICECUKY | Currency of Vehicle Price | VLC_GPRICECUKY | TCURC | CUKY | 5 |
| CDTSP | Time Stamp for Confirmed Delivery Date | VLC_CTSTAMP | DEC | 15 | |
| PSTSP | Time Stamp for Planned Delivery Time | VLC_PTSTAMP | DEC | 15 | |
| PDTSP | Time Stamp for Production Time | VLC_PRODTSTAMP | DEC | 15 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| VHUSG | Vehicle Usage | VLC_VEHIUSAGE | CVLC13 | CHAR | 2 |
| CMPGN | Sales Campaign | VLC_SALESCAMPAIGN | VLCSCAMPGN | CHAR | 10 |
| PCOUNT | Counter Reading | VLC_PCOUNT | QUAN | 7 | |
| PCOUNT_U | Fleet counter unit | FLEET_COUNT_UNIT | T006 | UNIT | 3 |
| IMMATDATE | Initial Registration Date | VLC_IMMATDATE | DATS | 8 | |
| VHSAR | Vehicle Search Area | VLC_VHSAR | CVLC18 | CHAR | 10 |
| VHORD | Original Ordering Party of Vehicle | VLC_VHORD | KNA1 | CHAR | 10 |
| SHLVL | Sharing Levels for Vehicle Search | VLC_SHLVL | CVLC27 | CHAR | 2 |
| ARCHIVE_FLAG | Archiving | VLC_ARCHIVE_VEHICLE | CHAR | 1 | |
| USED_VEHICLE | Flag That Indicates That the Vehicle Is a Used Vehicle | VLC_USED_FLAG | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VLCVEHICLE
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VLCVEHICLE | AVAIL | : | CVLC10 |
| VLCVEHICLE | BWTAR | : | MBEW |
| VLCVEHICLE | CHARG | : | MCH1 |
| VLCVEHICLE | CMPGN | 1: CN | VLCSCAMPGN |
| VLCVEHICLE | ENDCU | : | BUT000 |
| VLCVEHICLE | EQUNR | : | EQUI |
| VLCVEHICLE | GPRICECUKY | : | TCURC |
| VLCVEHICLE | KUNNR | 1: CN | KNA1 |
| VLCVEHICLE | LGORT | : | T001L |
| VLCVEHICLE | LIFNR | 1: CN | LFA1 |
| VLCVEHICLE | MANDT | : | T000 |
| VLCVEHICLE | MATNR | : | MARA |
| VLCVEHICLE | MMCTR | 1: CN | CVLC01 |
| VLCVEHICLE | MMSTA | 1: CN | CVLC02 |
| VLCVEHICLE | PCOUNT_U | 1: CN | T006 |
| VLCVEHICLE | SDCTR | 1: CN | CVLC01 |
| VLCVEHICLE | SDSTA | 1: CN | CVLC02 |
| VLCVEHICLE | SHLVL | : | CVLC27 |
| VLCVEHICLE | VHORD | : | KNA1 |
| VLCVEHICLE | VHSAR | 1: CN | CVLC18 |
| VLCVEHICLE | VHUSG | 1: CN | CVLC13 |
| VLCVEHICLE | WERKS | : | T001W |