I_LastMilePlannedDeliv

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_LastMilePlannedDeliv.
-- 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.

CREATE VIEW I_LastMilePlannedDeliv AS
SELECT
  I_OutboundDelivery.OutboundDelivery AS DeliveryDocument,
  I_DeliveryDocumentItem.Material AS ProductID,
  I_DeliveryDocumentItem.DeliveryDocumentItem AS DeliveryDocumentItem,
  I_LastMileVisit.LastMileVisitUUID AS LastMileVisitUUID,
  I_OutboundDelivery.SalesOrganization AS SalesOrganization,
  I_DeliveryDocumentItem.DistributionChannel AS DistributionChannel,
  I_DeliveryDocumentItem.Division AS Division,
  I_OutboundDelivery.DocumentDate AS DocumentDate,
  I_OutboundDelivery.ShipToParty AS Customer,
  I_DeliveryDocumentItem.DeliveryDocumentItemText AS DocumentItemText,
  I_DeliveryDocumentItem.ActualDeliveryQuantity AS Quantity,
  I_DeliveryDocumentItem.DeliveryQuantityUnit AS QuantityUnit,
  I_OutboundDelivery.TransportationPlanningStatus AS TransportationPlanningStatus,
  I_LastMileVisitList.LastMileVisitListUUID AS LastMileVisitListUUID,
  I_OutboundDelivery.ShippingPoint AS ShippingPoint,
  ' ' AS LastMileRouteDocumentIsReturn
FROM I_LastMileVisit
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _DeliveryQuantityUnit ON QuantityUnit = _DeliveryQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON ProductID = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON Customer = _ShipToParty.Customer  -- association [0..1]
-- UNION ALL with additional select branch(es): I_LastMileVisit
;