I_VMSVehicleSalesOrder

View for Vehicle Sales Order | view: IVMSVEHICLESORD | TRAN | Extraction: Not supported | Component: Vehicle Management System
Tables used: VBAP, VBKD, VEDA, VBAK, VLCCUORDER
Column Name Description
VMSVehicleUUID Vehicle GUID (Globally Unique IDentifier)
VMSVehicleActionDateTime Long Time Stamp
Column Name Description
💲 SD Document Currency (SalesDocumentCurrency):
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
Column Name Description
SalesOrderDate Document Date (Date Received/Sent)
Column Name Description
VMSVehicleActionDocType Type of Document for Action Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
Column Name Description Domain name
SalesOrder Sales Document VBELN
SalesOrderItem Sales Document Item POSNR
CreatedByUserName Name of Person Responsible for Creating the Object USNAM
PurchasingDocReferenceByCust Customer Reference BSTNK
CostCenter Cost Center KOSTL
Plant Plant (Own or External) WERKS
Master Data Relations Join Conditions
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • I_VMSVEHICLESALESORDER.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_VMSVEHICLESALESORDER.MANDT == TVKOV.MANDT
  • I_VMSVEHICLESALESORDER.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • Division
  • I_VMSVEHICLESALESORDER.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_VMSVEHICLESALESORDER.MANDT == TVTA.MANDT
  • I_VMSVEHICLESALESORDER.SALESORGANIZATION == TVTA.VKORG
  • I_VMSVEHICLESALESORDER.ORGANIZATIONDIVISION == TVTA.SPART
SD Document Currency
  • Client
  • SD Document Currency
  • I_VMSVEHICLESALESORDER.MANDT == TCURC.MANDT
  • I_VMSVEHICLESALESORDER.SALESDOCUMENTCURRENCY == TCURC.WAERS
Sales group
  • Client
  • Sales group
  • Sales office
  • I_VMSVEHICLESALESORDER.MANDT == TVBVK.MANDT
  • I_VMSVEHICLESALESORDER.SALESGROUP == TVBVK.VKGRP
  • I_VMSVEHICLESALESORDER.SALESOFFICE == TVBVK.VKBUR
Order type in order header
  • Client
  • Sales Order Type
  • I_VMSVEHICLESALESORDER.MANDT == TVAK.MANDT
  • I_VMSVEHICLESALESORDER.SALESORDERTYPE == TVAK.AUART
Sales organization in order header
  • Client
  • Sales Organization
  • I_VMSVEHICLESALESORDER.MANDT == TVKO.MANDT
  • I_VMSVEHICLESALESORDER.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Client
  • Sold-to Party
  • I_VMSVEHICLESALESORDER.MANDT == KNA1.MANDT
  • I_VMSVEHICLESALESORDER.SOLDTOPARTY == KNA1.KUNNR
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Distribution Channel
  • Client
  • Sales Organization
  • Division
  • Sales office
  • I_VMSVEHICLESALESORDER.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_VMSVEHICLESALESORDER.MANDT == TVKBZ.MANDT
  • I_VMSVEHICLESALESORDER.SALESORGANIZATION == TVKBZ.VKORG
  • I_VMSVEHICLESALESORDER.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_VMSVEHICLESALESORDER.SALESOFFICE == TVKBZ.VKBUR