I_VMSVehicle

Vehicle Details | view: IVMSVEH | TRAN | Extraction: Not supported | Component: Vehicle Management System
Tables used: VLCVEHICLE, VLC_VEHDVHMODEL
Column Name Description
VMSVehicleUUID Vehicle GUID (Globally Unique IDentifier)
Column Name Description
💲 Currency of Vehicle Price (VMSVehiclePriceCrcy):
VMSVehGrossPrcAmtInVehPrcCrcy Gross List Price of Vehicle
Column Name Description
📏 Fleet counter unit (VMSVehicleMileageUsageUnit):
VMSVehicleMileageQuantity Counter Reading
Column Name Description
VMSVehicleRegistrationDate Initial Registration Date
Column Name Description
VMSVehicleActionDocType Type of Document for Action Show values
VMSVehicleIsArchived Archiving Show values
VMSVehicleIsVisible Visibility Show values
VMSVehicleIsUsed Flag That Indicates That the Vehicle Is a Used Vehicle Show values
Column Name Description Domain name
VMSDigitalVehicleHubModel DVH Model VLC_DVH_MODEL
VMSVehicleInternalID Internal Vehicle Number CHARG
ConfigurationNumber Configuration (internal object number) CUOBJ
VMSVehiclePrimStatusDateTime Long Time Stamp TZNTSTMPL
VMSVehicleSecdryStatusDateTime Long Time Stamp TZNTSTMPL
VMSVehicleConfdDelivDateTime Time Stamp for Confirmed Delivery Date TZNTSTMPS
VMSVehicleProductionDateTime Time Stamp for Production Time TZNTSTMPS
VMSVehiclePlndDelivDateTime Time Stamp for Planned Delivery Time TZNTSTMPS
VehicleIdentificationNumber Vehicle Identification Number (Vehicle Identification No.) TEXT35
VMSVehicleExternalID External Vehicle Number CHAR35
VMSVehicleLocation VMS-Vehicle Location CHAR10
CreatedByUserName Name of Person Responsible for Creating the Object USNAM
DigitalVehicleReferenceID Digital Vehicle Reference ID CHAR35
Master Data Relations Join Conditions
Equipment
  • Equipment Number
  • Client
  • I_VMSVEHICLE.EQUIPMENT == EQUI.EQUNR
  • I_VMSVEHICLE.MANDT == EQUI.MANDT
Material Master
  • Client
  • Vehicle Model
  • I_VMSVEHICLE.MANDT == MARA.MANDT
  • I_VMSVEHICLE.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • I_VMSVEHICLE.MANDT == T001W.MANDT
  • I_VMSVEHICLE.PLANT == T001W.WERKS
Vendor
  • Vendor
  • Client
  • I_VMSVEHICLE.REFERENCEVENDOR == LFA1.LIFNR
  • I_VMSVEHICLE.MANDT == LFA1.MANDT
Storage location
  • Storage location
  • Client
  • Plant
  • I_VMSVEHICLE.STORAGELOCATION == T001L.LGORT
  • I_VMSVEHICLE.MANDT == T001L.MANDT
  • I_VMSVEHICLE.PLANT == T001L.WERKS
Material Valuation
  • ?
  • Valuation Type
  • Client
  • Vehicle Model
  • I_VMSVEHICLE.[column in domain "BWKEY"] == MBEW.BWKEY
  • I_VMSVEHICLE.VALUATIONTYPE == MBEW.BWTAR
  • I_VMSVEHICLE.MANDT == MBEW.MANDT
  • I_VMSVEHICLE.MATERIAL == MBEW.MATNR
Availability Status
  • Availability Status
  • Client
  • I_VMSVEHICLE.VMSVEHICLEAVAILABILITYSTATUS == CVLC10.AVAIL
  • I_VMSVEHICLE.MANDT == CVLC10.MANDT
Batch Number
  • Batch Number
  • Client
  • Vehicle Model
  • I_VMSVEHICLE.VMSVEHICLEBATCH == MCH1.CHARG
  • I_VMSVEHICLE.MANDT == MCH1.MANDT
  • I_VMSVEHICLE.MATERIAL == MCH1.MATNR
Customer
  • Customer
  • Client
  • I_VMSVEHICLE.VMSVEHICLECUSTOMER == KNA1.KUNNR
  • I_VMSVEHICLE.MANDT == KNA1.MANDT
End Customer (Central Business Partner)
  • End Customer (Central Business Partner)
  • Client
  • I_VMSVEHICLE.VMSVEHICLEENDCUSTOMER == BUT000.PARTNER
  • I_VMSVEHICLE.MANDT == BUT000.CLIENT
Fleet counter unit
  • Fleet counter unit
  • Client
  • I_VMSVEHICLE.VMSVEHICLEMILEAGEUSAGEUNIT == T006.MSEHI
  • I_VMSVEHICLE.MANDT == T006.MANDT
Original Ordering Party of Vehicle
  • Original Ordering Party of Vehicle
  • Client
  • I_VMSVEHICLE.VMSVEHICLEORDERINGPARTY == KNA1.KUNNR
  • I_VMSVEHICLE.MANDT == KNA1.MANDT
Currency of Vehicle Price
  • Currency of Vehicle Price
  • Client
  • I_VMSVEHICLE.VMSVEHICLEPRICECRCY == TCURC.WAERS
  • I_VMSVEHICLE.MANDT == TCURC.MANDT
Action Control
  • Action Control
  • Client
  • I_VMSVEHICLE.VMSVEHICLEPRIMACTIONCONTROL == CVLC01.CNTRL
  • I_VMSVEHICLE.MANDT == CVLC01.MANDT
Primary Status
  • Primary Status
  • Client
  • I_VMSVEHICLE.VMSVEHICLEPRIMARYSTATUS == CVLC02.STATU
  • I_VMSVEHICLE.MANDT == CVLC02.MANDT
Sales Campaign
  • Sales Campaign
  • Client
Vehicle Search Area
  • Vehicle Search Area
  • Client
  • I_VMSVEHICLE.VMSVEHICLESEARCHAREA == CVLC18.VHSAR
  • I_VMSVEHICLE.MANDT == CVLC18.MANDT
Action Control
  • Action Control
  • Client
  • I_VMSVEHICLE.VMSVEHICLESECDRYACTIONCONTROL == CVLC01.CNTRL
  • I_VMSVEHICLE.MANDT == CVLC01.MANDT
Secondary Status
  • Client
  • Secondary Status
  • I_VMSVEHICLE.MANDT == CVLC02.MANDT
  • I_VMSVEHICLE.VMSVEHICLESECONDARYSTATUS == CVLC02.STATU
Sharing Levels for Vehicle Search
  • Sharing Levels for Vehicle Search
  • Client
  • I_VMSVEHICLE.VMSVEHICLESHARINGLEVEL == CVLC27.SHLVL
  • I_VMSVEHICLE.MANDT == CVLC27.MANDT
Vehicle Usage
  • Vehicle Usage
  • Client
  • I_VMSVEHICLE.VMSVEHICLEUSAGESTATUS == CVLC13.VHUSG
  • I_VMSVEHICLE.MANDT == CVLC13.MANDT