SAP Table VLCVEHICLE

VELO : Vehicle

VLCVEHICLE (VELO : Vehicle) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VLCVEHICLE to other SAP tables.

VLCVEHICLE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VGUID Vehicle GUID (Globally Unique IDentifier) VLC_GUID CHAR 22 0
VHCLE Internal Vehicle Number VLC_VHCLE CHAR 10 0
MATNR Vehicle Model VLC_MATNR MARA CHAR 18 0
LIFNR Vendor VLC_LIFNR LFA1 CHAR 10 0
CHARG Batch Number CHARG_D MCH1 CHAR 10 0
EQUNR Equipment Number EQUNR EQUI CHAR 18 0
WERKS Plant WERKS_D T001W CHAR 4 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
BWTAR Valuation Type BWTAR_D MBEW CHAR 10 0
CUOBJ Configuration (internal object number) CUOBJ NUMC 18 0
CUABA Type of Document for Action VLC_ACTDOCTYPE CHAR 4 0
CUOR Sales Order Document
DELI Delivery Document
GISR Goods Issue Reversal Document
GOIS Goods Issue Document
GORE Goods Receipt Document
GRER Goods Receipt Reversal Document
IEID Initial Entry of Stock Document
IIVR Incoming Invoice Reversal Document
INIV Incoming Invoice Document
IQRY RFQ Document
OFFE Quotation Document
OUIV Outgoing Invoice
OIVR Outgoing Invoice Reversal Document
ORD1 Purchase Order Document
POEU Purchase Order Document for Used Car Trade-In
RETU Returns Document
RELI Delivery Returns Document
REGI Goods Receipt Document for Returns Delivery
SMOR Service Order Document
STOL Location Transfer Posting Document - Storage Location
UGRE Goods Receipt Document for Rework Purchase Order
UGRR Reversal Document of Goods Receipt for Rework Purchase Order
UORD Rework Purchase Order Document
UTPO Transfer Posting Document in SC Stock
UTPR Transfer Posting Reversal Document in SC Stock
SMNO Document Service Notification
SMIO Billing Request for Service Order
RVAL Revaluate Document Vehicle
RECM Document Credit Memo for Returns
CHCO Change Document Sales Order
DECO Delete Document Sales Order
SOEU Create Document Used Vehicle Sales: Create Order
SPEU Document Used Vehicle Sales: Define Price
REUS Document Transfer Posting Remain. BlockStock -> UnrestUse
WRTY Assign Document Master Warranty
CREQ Create Document Equipment
GEOB Create Document Object Number
MEAS Assign Document Measuring Points
SMCO Confirm Document Service Order
EMMI Enter Document Messages for SCEM
CPGM Cross Plant Goods Movement
MMCTR Action Control VLC_CNTRL CVLC01 CHAR 4 0
MMSTA Primary Status VLC_MMSTATU CVLC02 CHAR 4 0
MMTSP Long Time Stamp VLC_LTSTAMP DEC 21 7
SDCTR Action Control VLC_CNTRL CVLC01 CHAR 4 0
SDSTA Secondary Status VLC_SDSTATU CVLC02 CHAR 4 0
SDTSP Long Time Stamp VLC_LTSTAMP DEC 21 7
KUNNR Customer VLC_KUNNR KNA1 CHAR 10 0
ENDCU End Customer (Central Business Partner) VLC_ENDCU BUT000 CHAR 10 0
VHVIN Vehicle Identification Number (Vehicle Identification No.) VLC_VHVIN CHAR 35 0
VHCEX External Vehicle Number VLC_VHCEX CHAR 35 0
AVAIL Availability Status VLC_AVAILABILITY CVLC10 CHAR 2 0
VBLTY Visibility VLC_VISIBILITY CHAR 1 0
X Visible
NULL Invisible
LOCTN VMS-Vehicle Location VLC_LOCTN CHAR 10 0
GPRICE Gross List Price of Vehicle VLC_GPRICE CURR 17 2
GPRICECUKY Currency of Vehicle Price VLC_GPRICECUKY TCURC CUKY 5 0
CDTSP Time Stamp for Confirmed Delivery Date VLC_CTSTAMP DEC 15 0
PSTSP Time Stamp for Planned Delivery Time VLC_PTSTAMP DEC 15 0
PDTSP Time Stamp for Production Time VLC_PRODTSTAMP DEC 15 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
VHUSG Vehicle Usage VLC_VEHIUSAGE CVLC13 CHAR 2 0
CMPGN Sales Campaign VLC_SALESCAMPAIGN VLCSCAMPGN CHAR 10 0
PCOUNT Counter Reading VLC_PCOUNT QUAN 7 0
PCOUNT_U Fleet counter unit FLEET_COUNT_UNIT T006 UNIT 3 0
IMMATDATE Initial Registration Date VLC_IMMATDATE DATS 8 0
VHSAR Vehicle Search Area VLC_VHSAR CVLC18 CHAR 10 0
VHORD Original Ordering Party of Vehicle VLC_VHORD KNA1 CHAR 10 0
SHLVL Sharing Levels for Vehicle Search VLC_SHLVL CVLC27 CHAR 2 0
ARCHIVE_FLAG Archiving VLC_ARCHIVE_VEHICLE CHAR 1 0
X Yes
NULL No
USED_VEHICLE Flag That Indicates That the Vehicle Is a Used Vehicle VLC_USED_FLAG CHAR 1 0
X Yes
NULL No

VLCVEHICLE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VLCVEHICLE AVAIL SYST MANDT CVLC10 VELO : Availability Status MANDT
VLCVEHICLE AVAIL VLCVEHICLE AVAIL CVLC10 VELO : Availability Status AVAIL
VLCVEHICLE BWTAR * MBEW Material Valuation BWKEY
VLCVEHICLE BWTAR VLCVEHICLE BWTAR MBEW Material Valuation BWTAR
VLCVEHICLE BWTAR VLCVEHICLE MANDT MBEW Material Valuation MANDT
VLCVEHICLE BWTAR VLCVEHICLE MATNR MBEW Material Valuation MATNR
VLCVEHICLE CHARG VLCVEHICLE MANDT MCH1 Batches (if Batch Management Cross-Plant) MANDT
VLCVEHICLE CHARG VLCVEHICLE MATNR MCH1 Batches (if Batch Management Cross-Plant) MATNR
VLCVEHICLE CHARG VLCVEHICLE CHARG MCH1 Batches (if Batch Management Cross-Plant) CHARG
VLCVEHICLE CMPGN VLCVEHICLE CMPGN VLCSCAMPGN VELO : Sales Campaign CMPGN
VLCVEHICLE CMPGN SYST MANDT VLCSCAMPGN VELO : Sales Campaign MANDT
VLCVEHICLE ENDCU VLCVEHICLE MANDT BUT000 BP: General data I CLIENT
VLCVEHICLE ENDCU VLCVEHICLE ENDCU BUT000 BP: General data I PARTNER
VLCVEHICLE EQUNR VLCVEHICLE EQUNR EQUI Equipment master data EQUNR
VLCVEHICLE EQUNR VLCVEHICLE MANDT EQUI Equipment master data MANDT
VLCVEHICLE GPRICECUKY SYST MANDT TCURC Currency Codes MANDT
VLCVEHICLE GPRICECUKY VLCVEHICLE GPRICECUKY TCURC Currency Codes WAERS
VLCVEHICLE KUNNR VLCVEHICLE MANDT KNA1 General Data in Customer Master MANDT
VLCVEHICLE KUNNR VLCVEHICLE KUNNR KNA1 General Data in Customer Master KUNNR
VLCVEHICLE LGORT VLCVEHICLE MANDT T001L Storage Locations MANDT
VLCVEHICLE LGORT VLCVEHICLE WERKS T001L Storage Locations WERKS
VLCVEHICLE LGORT VLCVEHICLE LGORT T001L Storage Locations LGORT
VLCVEHICLE LIFNR VLCVEHICLE MANDT LFA1 Vendor Master (General Section) MANDT
VLCVEHICLE LIFNR VLCVEHICLE LIFNR LFA1 Vendor Master (General Section) LIFNR
VLCVEHICLE MANDT VLCVEHICLE MANDT T000 Clients MANDT
VLCVEHICLE MATNR VLCVEHICLE MANDT MARA General Material Data MANDT
VLCVEHICLE MATNR VLCVEHICLE MATNR MARA General Material Data MATNR
VLCVEHICLE MMCTR VLCVEHICLE MMCTR CVLC01 VELO : Action Control CNTRL
VLCVEHICLE MMCTR VLCVEHICLE MANDT CVLC01 VELO : Action Control MANDT
VLCVEHICLE MMSTA VLCVEHICLE MANDT CVLC02 VELO : Vehicle Status MANDT
VLCVEHICLE MMSTA VLCVEHICLE MMSTA CVLC02 VELO : Vehicle Status STATU
VLCVEHICLE PCOUNT_U * T006 Units of Measurement MANDT
VLCVEHICLE PCOUNT_U VLCVEHICLE PCOUNT_U T006 Units of Measurement MSEHI
VLCVEHICLE SDCTR VLCVEHICLE MANDT CVLC01 VELO : Action Control MANDT
VLCVEHICLE SDCTR VLCVEHICLE SDCTR CVLC01 VELO : Action Control CNTRL
VLCVEHICLE SDSTA VLCVEHICLE MANDT CVLC02 VELO : Vehicle Status MANDT
VLCVEHICLE SDSTA VLCVEHICLE SDSTA CVLC02 VELO : Vehicle Status STATU
VLCVEHICLE SHLVL SYST MANDT CVLC27 VELO : Access Authorization During Vehicle Search MANDT
VLCVEHICLE SHLVL VLCVEHICLE SHLVL CVLC27 VELO : Access Authorization During Vehicle Search SHLVL
VLCVEHICLE VHORD SYST MANDT KNA1 General Data in Customer Master MANDT
VLCVEHICLE VHORD VLCVEHICLE VHORD KNA1 General Data in Customer Master KUNNR
VLCVEHICLE VHSAR SYST MANDT CVLC18 VELO : Vehicle Search Area MANDT
VLCVEHICLE VHSAR VLCVEHICLE VHSAR CVLC18 VELO : Vehicle Search Area VHSAR
VLCVEHICLE VHUSG SYST MANDT CVLC13 VELO : Vehicle Usage MANDT
VLCVEHICLE VHUSG VLCVEHICLE VHUSG CVLC13 VELO : Vehicle Usage VHUSG
VLCVEHICLE WERKS VLCVEHICLE WERKS T001W Plants/Branches WERKS
VLCVEHICLE WERKS VLCVEHICLE MANDT T001W Plants/Branches MANDT