I_VMSVehicle

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_VMSVehicle.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IVMSVEH

CREATE VIEW I_VMSVehicle AS
SELECT
  vguid AS VMSVehicleUUID,
  matnr AS Material,
  _Vehdvhmodel.dvh_model AS VMSDigitalVehicleHubModel,
  vhcle AS VMSVehicleInternalID,
  lifnr AS ReferenceVendor,
  charg AS VMSVehicleBatch,
  equnr AS Equipment,
  cuaba AS VMSVehicleActionDocType,
  werks AS Plant,
  lgort AS StorageLocation,
  bwtar AS ValuationType,
  cuobj AS ConfigurationNumber,
  mmctr AS VMSVehiclePrimActionControl,
  mmsta AS VMSVehiclePrimaryStatus,
  mmtsp AS VMSVehiclePrimStatusDateTime,
  sdctr AS VMSVehicleSecdryActionControl,
  sdsta AS VMSVehicleSecondaryStatus,
  sdtsp AS VMSVehicleSecdryStatusDateTime,
  cdtsp AS VMSVehicleConfdDelivDateTime,
  pdtsp AS VMSVehicleProductionDateTime,
  pstsp AS VMSVehiclePlndDelivDateTime,
  archive_flag AS VMSVehicleIsArchived,
  vhvin AS VehicleIdentificationNumber,
  vhcex AS VMSVehicleExternalID,
  avail AS VMSVehicleAvailabilityStatus,
  vblty AS VMSVehicleIsVisible,
  loctn AS VMSVehicleLocation,
  kunnr AS VMSVehicleCustomer,
  endcu AS VMSVehicleEndCustomer,
  ernam AS CreatedByUserName,
  vhusg AS VMSVehicleUsageStatus,
  cmpgn AS VMSVehicleSalesCampaign,
  pcount AS VMSVehicleMileageQuantity,
  pcount_u AS VMSVehicleMileageUsageUnit,
  immatdate AS VMSVehicleRegistrationDate,
  DigitalVehicleReferenceID,
  vhsar AS VMSVehicleSearchArea,
  vhord AS VMSVehicleOrderingParty,
  gprice AS VMSVehGrossPrcAmtInVehPrcCrcy,
  gpricecuky AS VMSVehiclePriceCrcy,
  shlvl AS VMSVehicleSharingLevel,
  used_vehicle AS VMSVehicleIsUsed
FROM vlcvehicle
LEFT OUTER JOIN E_VMSVehicle AS _Extension ON _Extension.VMSVehicleUUID = VMSVehicleUUID  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON VMSVehicleCustomer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _OrderingParty ON VMSVehicleOrderingParty = _OrderingParty.Customer  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON ReferenceVendor = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _Partner ON VMSVehicleEndCustomer = _Partner.BusinessPartner  -- association [1..1]
;