A_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 A_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: AVMSVEHICLE

CREATE VIEW A_VMSVehicle AS
SELECT
  VMSVehicleUUID,
  Material,
  VMSDigitalVehicleHubModel,
  VMSVehicleInternalID,
  ReferenceVendor,
  VMSVehicleBatch,
  Equipment,
  VMSVehicleActionDocType,
  Plant,
  _plant.PlantName AS PlantName,
  StorageLocation,
  _storagelocation.StorageLocationName AS StorageLocationName,
  ValuationType,
  ConfigurationNumber,
  VMSVehiclePrimActionControl,
  VMSVehiclePrimaryStatus,
  VMSVehiclePrimStatusDateTime,
  VMSVehicleSecdryActionControl,
  VMSVehicleSecondaryStatus,
  VMSVehicleSecdryStatusDateTime,
  VMSVehicleConfdDelivDateTime,
  VMSVehicleProductionDateTime,
  VMSVehiclePlndDelivDateTime,
  VMSVehicleIsArchived,
  VehicleIdentificationNumber,
  VMSVehicleExternalID,
  VMSVehicleAvailabilityStatus,
  VMSVehicleIsVisible,
  _VMSVehicleLocation.VMSVehicleLocation AS VMSVehicleLocation,
  VMSVehicleCustomer,
  VMSVehicleEndCustomer,
  CreatedByUserName,
  VMSVehicleUsageStatus,
  VMSVehicleSalesCampaign,
  VMSVehicleMileageQuantity,
  VMSVehicleMileageUsageUnit,
  VMSVehicleRegistrationDate,
  VMSVehicleSearchArea,
  VMSVehicleOrderingParty,
  VMSVehGrossPrcAmtInVehPrcCrcy,
  VMSVehiclePriceCrcy,
  VMSVehicleSharingLevel,
  VMSVehicleIsUsed,
  _SAPClient.LogicalSystem AS LogicalSystem
FROM I_VMSVehicle
INNER JOIN I_SAPClient AS _SAPClient ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_VMSVehicle AS _Extension ON _Extension.VMSVehicleUUID = VMSVehicleUUID  -- association [1..1]
LEFT OUTER JOIN A_VMSVehicleInvoice AS _VMSVehicleInvoice ON _VMSVehicleInvoice.VMSVehicleUUID = VMSVehicleUUID  -- association [1..*]
LEFT OUTER JOIN A_VMSVehicleIncomingInvoice AS _VMSVehicleIncomingInvoice ON _VMSVehicleIncomingInvoice.VMSVehicleUUID = VMSVehicleUUID  -- association [1..*]
LEFT OUTER JOIN A_VMSVehicleToEquipment AS _VMSVehicleToEquipment ON _VMSVehicleToEquipment.InstalledBaseComponent = ConfigurationNumber AND Material = _VMSVehicleToEquipment.ClfnObjectID  -- association [1..*]
LEFT OUTER JOIN A_VMSVehicleSalesOrder AS _VMSVehicleSalesOrder ON _VMSVehicleSalesOrder.VMSVehicleUUID = VMSVehicleUUID  -- association [1..*]
LEFT OUTER JOIN A_VMSVehiclePurchaseOrder AS _VMSVehiclePurchaseOrder ON _VMSVehiclePurchaseOrder.VMSVehicleUUID = VMSVehicleUUID  -- association [1..*]
LEFT OUTER JOIN A_VMSVehicleHistory AS _VMSVehicleHistory ON _VMSVehicleHistory.VMSVehicleUUID = VMSVehicleUUID  -- association [1..*]
LEFT OUTER JOIN A_VMSVehicleLocation AS _VMSVehicleLocation ON I_VMSVehicle.VMSVehicleLocation = _VMSVehicleLocation.AddressNumber AND _VMSVehicleLocation.AddressNumber <> ' '  -- association [0..1]
LEFT OUTER JOIN A_VMSVehicleStatusText AS _VMSVehiclePrimaryStatusText ON _VMSVehiclePrimaryStatusText.VMSVehicleStatus = VMSVehiclePrimaryStatus  -- association [1..*]
LEFT OUTER JOIN A_VMSVehicleStatusText AS _VMSVehicleSecondaryStatusText ON _VMSVehicleSecondaryStatusText.VMSVehicleStatus = VMSVehicleSecondaryStatus  -- association [1..*]
LEFT OUTER JOIN A_VMSVehicleAvailabilityText AS _VMSVehicleAvailabilityText ON _VMSVehicleAvailabilityText.VMSVehicleAvailabilityStatus = VMSVehicleAvailabilityStatus  -- association [1..*]
LEFT OUTER JOIN A_VMSVehicleCampaignText AS _VMSVehCampaignText ON _VMSVehCampaignText.VMSVehicleSalesCampaign = VMSVehicleSalesCampaign  -- association [1..*]
LEFT OUTER JOIN A_VMSVehicleSearchAreaText AS _VMSVehicleSearchAreaText ON _VMSVehicleSearchAreaText.VMSVehicleSearchArea = VMSVehicleSearchArea  -- association [1..*]
LEFT OUTER JOIN A_VMSVehicleSharingLevelText AS _VMSVehSharingLevelText ON _VMSVehSharingLevelText.VMSVehicleSharingLevel = VMSVehicleSharingLevel  -- association [1..*]
LEFT OUTER JOIN A_VMSVehicleUsageStatusText AS _VMSVehUsageStatusText ON _VMSVehUsageStatusText.VMSVehicleUsageStatus = VMSVehicleUsageStatus  -- association [1..*]
LEFT OUTER JOIN A_VMSVehicleLocationText AS _LocationText ON vmsvehiclelocation = _LocationText.VMSVehicleLocation  -- association [1..*]
LEFT OUTER JOIN A_Customer AS _Customer ON VMSVehicleCustomer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN A_Customer AS _OrderingParty ON VMSVehicleOrderingParty = _OrderingParty.Customer  -- association [1..1]
LEFT OUTER JOIN A_Supplier AS _Supplier ON ReferenceVendor = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN A_BusinessPartner AS _Partner ON VMSVehicleEndCustomer = _Partner.BusinessPartner  -- association [1..1]
;