A_VMSVehicle

Vehicle Details | view: AVMSVEHICLE | Extraction: Not supported | Component: Vehicle Management System
Tables used: VLCVEHICLE, ADCP, ADRC, T001, TKA02, T001W, T001K, T000, T001L, CVLC06, 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
PlantName Plant Name TEXT30
StorageLocationName Storage Location Name TEXT16
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
Master Data Relations Join Conditions
Equipment
  • Client
  • Equipment Number
  • A_VMSVEHICLE.MANDT == EQUI.MANDT
  • A_VMSVEHICLE.EQUIPMENT == EQUI.EQUNR
Logical system A_VMSVEHICLE.LOGICALSYSTEM == TBDLS.LOGSYS
Material Master
  • Client
  • Vehicle Model
  • A_VMSVEHICLE.MANDT == MARA.MANDT
  • A_VMSVEHICLE.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • A_VMSVEHICLE.MANDT == T001W.MANDT
  • A_VMSVEHICLE.PLANT == T001W.WERKS
Vendor
  • Vendor
  • Client
  • A_VMSVEHICLE.REFERENCEVENDOR == LFA1.LIFNR
  • A_VMSVEHICLE.MANDT == LFA1.MANDT
Storage location
  • Client
  • Storage location
  • Plant
  • A_VMSVEHICLE.MANDT == T001L.MANDT
  • A_VMSVEHICLE.STORAGELOCATION == T001L.LGORT
  • A_VMSVEHICLE.PLANT == T001L.WERKS
Material Valuation
  • Valuation Type
  • Client
  • ?
  • Vehicle Model
  • A_VMSVEHICLE.VALUATIONTYPE == MBEW.BWTAR
  • A_VMSVEHICLE.MANDT == MBEW.MANDT
  • A_VMSVEHICLE.[column in domain "BWKEY"] == MBEW.BWKEY
  • A_VMSVEHICLE.MATERIAL == MBEW.MATNR
Availability Status
  • Client
  • Availability Status
  • A_VMSVEHICLE.MANDT == CVLC10.MANDT
  • A_VMSVEHICLE.VMSVEHICLEAVAILABILITYSTATUS == CVLC10.AVAIL
Batch Number
  • Batch Number
  • Client
  • Vehicle Model
  • A_VMSVEHICLE.VMSVEHICLEBATCH == MCH1.CHARG
  • A_VMSVEHICLE.MANDT == MCH1.MANDT
  • A_VMSVEHICLE.MATERIAL == MCH1.MATNR
Customer
  • Customer
  • Client
  • A_VMSVEHICLE.VMSVEHICLECUSTOMER == KNA1.KUNNR
  • A_VMSVEHICLE.MANDT == KNA1.MANDT
End Customer (Central Business Partner)
  • End Customer (Central Business Partner)
  • Client
  • A_VMSVEHICLE.VMSVEHICLEENDCUSTOMER == BUT000.PARTNER
  • A_VMSVEHICLE.MANDT == BUT000.CLIENT
Fleet counter unit
  • Client
  • Fleet counter unit
  • A_VMSVEHICLE.MANDT == T006.MANDT
  • A_VMSVEHICLE.VMSVEHICLEMILEAGEUSAGEUNIT == T006.MSEHI
Original Ordering Party of Vehicle
  • Client
  • Original Ordering Party of Vehicle
  • A_VMSVEHICLE.MANDT == KNA1.MANDT
  • A_VMSVEHICLE.VMSVEHICLEORDERINGPARTY == KNA1.KUNNR
Currency of Vehicle Price
  • Client
  • Currency of Vehicle Price
  • A_VMSVEHICLE.MANDT == TCURC.MANDT
  • A_VMSVEHICLE.VMSVEHICLEPRICECRCY == TCURC.WAERS
Action Control
  • Client
  • Action Control
  • A_VMSVEHICLE.MANDT == CVLC01.MANDT
  • A_VMSVEHICLE.VMSVEHICLEPRIMACTIONCONTROL == CVLC01.CNTRL
Primary Status
  • Client
  • Primary Status
  • A_VMSVEHICLE.MANDT == CVLC02.MANDT
  • A_VMSVEHICLE.VMSVEHICLEPRIMARYSTATUS == CVLC02.STATU
Sales Campaign
  • Client
  • Sales Campaign
Vehicle Search Area
  • Client
  • Vehicle Search Area
  • A_VMSVEHICLE.MANDT == CVLC18.MANDT
  • A_VMSVEHICLE.VMSVEHICLESEARCHAREA == CVLC18.VHSAR
Action Control
  • Client
  • Action Control
  • A_VMSVEHICLE.MANDT == CVLC01.MANDT
  • A_VMSVEHICLE.VMSVEHICLESECDRYACTIONCONTROL == CVLC01.CNTRL
Secondary Status
  • Client
  • Secondary Status
  • A_VMSVEHICLE.MANDT == CVLC02.MANDT
  • A_VMSVEHICLE.VMSVEHICLESECONDARYSTATUS == CVLC02.STATU
Sharing Levels for Vehicle Search
  • Client
  • Sharing Levels for Vehicle Search
  • A_VMSVEHICLE.MANDT == CVLC27.MANDT
  • A_VMSVEHICLE.VMSVEHICLESHARINGLEVEL == CVLC27.SHLVL
Vehicle Usage
  • Client
  • Vehicle Usage
  • A_VMSVEHICLE.MANDT == CVLC13.MANDT
  • A_VMSVEHICLE.VMSVEHICLEUSAGESTATUS == CVLC13.VHUSG