I_LstMiRouteStop

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_LstMiRouteStop.
-- 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_LstMiRouteStop AS
SELECT
  stop_uuid AS LastMileRouteStopUUID,
  route_uuid AS LastMileRouteUUID,
  stop_type AS LastMileRouteStopType,
  processing_status AS LstMiRouteStopProcessingStatus,
  shipto_party_id AS ShipToParty,
  stop_id AS LastMileRouteStop,
  stop_stage_id AS LastMileRouteStage,
  sequence AS LastMileRouteStopSequenceValue,
  location_id AS TranspOrdStopLocation,
  planned_arrival_timestamp AS TranspOrdReqArrivalDteTme,
  planned_departure_timestamp AS TranspOrdReqDepartureDteTme,
  actual_arrival_timestamp AS TranspOrdArrivalDateTime,
  actual_departure_timestamp AS TranspOrdDepartureDateTime,
  _Route.LstMiRteOdometerUnitOfMeasure AS LstMiRteOdometerUnitOfMeasure,
  odometer AS LstMiRouteStopOdometerQuantity,
  clerk_name AS LastMileRouteClerkName,
  execution_reason_code AS LastMileRouteReasonCode,
  location_address_id AS AddressID,
  coci_behavior AS LastMileRouteStopCOCIBehavior,
  is_removed AS LastMileRouteStopIsRemoved,
  origin_code AS LastMileRouteOriginCode,
  replication_request_status AS LstMiReplicationRequestStatus,
  stop_data_version_uuid AS LstMiRteStopDataVersionUUID,
  is_manually_added AS LastMileRouteIsMnllyAddedRecd,
  reload_rel_ci_to_co_uuid AS LstMiRteRldChkInChkOutRltnUUID
FROM lmd_com_stops
LEFT OUTER JOIN I_LstMiRoute AS _Route ON LastMileRouteUUID = _Route.LastMileRouteUUID  -- association [1..1]
LEFT OUTER JOIN I_LstMiRouteDocument AS _Document ON LastMileRouteStopUUID = _Document.LastMileRouteStopUUID  -- association [0..*]
LEFT OUTER JOIN I_LstMiRouteCollection AS _Collection ON LastMileRouteStopUUID = _Collection.LastMileRouteStopUUID  -- association [0..*]
LEFT OUTER JOIN I_LstMiRouteCOCIPayment AS _COCIPayment ON LastMileRouteStopUUID = _COCIPayment.LastMileRouteStopUUID  -- association [0..*]
LEFT OUTER JOIN I_LstMiRouteCOCIProduct AS _COCIProduct ON LastMileRouteStopUUID = _COCIProduct.LastMileRouteStopUUID  -- association [0..*]
LEFT OUTER JOIN I_Customer AS _ShipToPartyVH ON ShipToParty = _ShipToPartyVH.Customer  -- association [0..1]
;