I_LstMiRouteDocumentItem

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_LstMiRouteDocumentItem.
-- 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: ILSTMIDOCITM

CREATE VIEW I_LstMiRouteDocumentItem AS
SELECT
  document_item_uuid AS LastMileRouteDocumentItemUUID,
  route_uuid AS LastMileRouteUUID,
  stop_uuid AS LastMileRouteStopUUID,
  document_header_uuid AS LstMiRouteDocumentHeaderUUID,
  lmd_document_type AS LastMileRouteDocumentType,
  document_id AS SDDocument,
  item_number AS SDDocumentItem,
  hl_item_number AS HigherLevelItem,
  product_id AS ProductID,
  quantity AS LastMileRoutePlannedQuantity,
  actual_quantity AS LastMileRouteActualQuantity,
  uom AS UnitOfMsrOfDelivUnit,
  Batch,
  Plant,
  is_return_item AS LastMileRouteProductIsReturn,
  is_free_goods_item AS LastMileRouteProductIsFreeGood,
  reason_code AS LastMileRouteItemReasonCode,
  ref_lmd_doc_type AS LastMileRouteRefDocumentType,
  ref_doc_id AS ReferenceSDDocument,
  ref_doc_id_item AS ReferenceSDDocumentItem,
  cast( customer_reference_number as /plmb/ecr_cust_change_no ) AS CustomerReferenceNumber,
  unloading_point AS LastMileRouteUnloadingLocation,
  is_manually_added AS LastMileRouteIsMnllyAddedRecd,
  is_tied_empty AS LastMileRouteItemIsTiedEmpty,
  is_untied_empty AS LastMileRouteItemIsUntiedEmpty,
  currency AS LstMiRouteDocumentItemCurrency,
  total_gross_amount AS LstMiRouteDocumentItemAmount,
  cast( condition_value_1 as abap.dec(23,2) ) AS LstMiRtePriceCondition1Value,
  cast( condition_value_2 as abap.dec(23,2) ) AS LstMiRtePriceCondition2Value,
  cast( condition_value_3 as abap.dec(23,2) ) AS LstMiRtePriceCondition3Value,
  cast( condition_value_4 as abap.dec(23,2) ) AS LstMiRtePriceCondition4Value,
  inventory_group AS LastMileRteInventoryGroupCode,
  inventory_group_diff AS LstMiRteInvtryGrpDiffCode,
  bob_promotion_id AS OmniChannelSalesPromotion,
  bob_free_goods_id AS LstMiRteOmniChannelFreeGoodsID
FROM lmd_com_doc_itms
LEFT OUTER JOIN I_LstMiRouteDocument AS _Document ON LstMiRouteDocumentHeaderUUID = _Document.LstMiRouteDocumentHeaderUUID AND LastMileRouteUUID = _Document.LastMileRouteUUID  -- association [1..1]
LEFT OUTER JOIN I_LstMiRoute AS _Route ON LastMileRouteUUID = _Route.LastMileRouteUUID  -- association [1..1]
LEFT OUTER JOIN I_LstMiRouteStop AS _Stop ON LastMileRouteStopUUID = _Stop.LastMileRouteStopUUID AND LastMileRouteUUID = _Stop.LastMileRouteUUID  -- association [0..1]
LEFT OUTER JOIN I_LstMiRteDocItemProductVH AS _ProductVH ON ProductID = _ProductVH.ProductID AND LastMileRouteUUID = _ProductVH.LastMileRouteUUID  -- association [1..1]
LEFT OUTER JOIN I_SalesDocumentExtdItem AS _SalesDocumentItem ON ReferenceSDDocument = _SalesDocumentItem.SalesDocument AND ReferenceSDDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_LstMiRteDocItemCondition AS _DocumentItemCondition ON LastMileRouteDocumentItemUUID = _DocumentItemCondition.LastMileRouteDocumentItemUUID  -- association [0..*]
;