I_LstMiRteProcDeliveryDocument

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_LstMiRteProcDeliveryDocument.
-- 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_LstMiRteProcDeliveryDocument AS
SELECT
  rpt_docs.LstMiRouteProcessDocumentUUID AS LstMiRouteProcessDocumentUUID,
  rpt_docs.LastMileRouteProcessUUID AS LastMileRouteProcessUUID,
  rpt_docs.LastMileRouteProcessDocument AS LastMileRouteProcessDocument,
  rpt_docs.LstMiRouteProcessDocumentType AS LstMiRouteProcessDocumentType,
  rpt_docs.LastMileRoutePostingStatus AS LastMileRoutePostingStatus,
  _SDDelivery.ReadyForWarehouseExecStatus AS ReadyForWarehouseExecStatus,
  _SDDelivery.OverallPickingStatus AS OverallPickingStatus,
  rpt_docs._Process AS _Process
FROM I_LastMileRouteProcessDocument AS rpt_docs
LEFT OUTER JOIN I_DeliveryDocument AS _SDDelivery ON LastMileRouteProcessDocument = _SDDelivery.DeliveryDocument  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentPartner AS _SDDocumentPartner ON LastMileRouteProcessDocument = _SDDocumentPartner.SDDocument AND _SDDocumentPartner.PartnerFunction = 'WE'  -- association [0..1]
LEFT OUTER JOIN I_LstMiRteProcDlvPkngStsText AS _PickingStatusText ON overallpickingstatus = _PickingStatusText.OverallPickingStatus  -- association [0..*]
LEFT OUTER JOIN I_LstMiRteProcDlvWrhsStsText AS _WarehouseStatusText ON readyforwarehouseexecstatus = _WarehouseStatusText.ReadyForWarehouseExecStatus  -- association [0..*]
LEFT OUTER JOIN I_LstMiRteProcRteStkStatusText AS _RouteStockStatusText ON LastMileRoutePostingStatus = _RouteStockStatusText.LstMiRteProcRouteStockStatus  -- association [0..*]
;