P_LstMiUIRouteDocument

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 P_LstMiUIRouteDocument.
-- 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 P_LstMiUIRouteDocument AS
SELECT
  Visit.stop_uuid AS LstMiRouteDocumentHeaderUUID,
  Visit.stop_uuid AS LastMileRouteStopUUID,
  Visit.route_uuid AS LastMileRouteUUID,
  cast('' as lmd_com_doc_id) AS SalesDocument,
  cast('PAY' as lmd_com_doc_type preserving type ) AS LastMileRouteDocumentType,
  DocumentHeader.SoldtoPartyId AS SoldToParty,
  Visit.shipto_party_id AS ShipToParty,
  DocumentHeader.SalesOrganization AS SalesOrganization,
  DocumentHeader.DistributionChannel AS DistributionChannel,
  DocumentHeader.Division AS Division,
  DocumentHeader.AddressId AS AddressId,
  cast('00000000' as lmd_com_doc_date) AS LastMileRouteDocumentDate,
  cast('' as lmd_com_reason_code) AS LstMiRouteDocumentReasonCode,
  cast('00000000' as lmd_com_doc_signature_date ) AS LstMiRteDocumentSignatureDate,
  cast('' as /plmb/ecr_cust_change_no) AS CustomerReferenceNumber,
  cast('' as lmd_com_cust_rel_ord_num) AS LstMiRteCustRlvtOrderNumber,
  cast('' as lmd_com_ui_doc_edit_status) AS LstMiRouteDocumentEditStatus,
  '' AS LstMiRteIsOnlyRetsPosAllowed,
  cast('PAYMENT' as bezei20) AS DeliveryDocumentTypeName,
  '' AS LastMileRouteIsMnllyAddedRecd,
  '' AS LastMileStockTransferType,
  cast('' as lmd_com_reference_route_id) AS LastMileReferenceRoute,
  cast('' as lmd_com_payment_terms) AS LastMileRoutePaymentTerms,
  cast('00000000' as lmd_com_doc_reqd_delivery_date ) AS LastMileRouteRequestedDelivDte,
  StopReasonUsage.LstMiRteVstIsCancldByRsnCode AS LstMiRteVstIsCancldByRsnCode,
  '' AS LstMiRteDocIsCancldByRsnCode,
  Visit.origin_code AS LastMileRouteOriginCode,
  cast('' as lmd_com_currency ) AS LastMileRouteCurrency,
  cast('0' as lmd_com_amount ) AS LastMileRouteDocumentAmount,
  DocumentHeader.DocumentReferenceID AS DocumentReferenceID
FROM lmd_com_stops AS Visit
-- UNION ALL with additional select branch(es): I_LstMiRouteDocumentEnhanced
;