I_LstMiRouteStopTP

DDL: I_LSTMIROUTESTOPTP Type: view_entity TRANSACTIONAL
27 Fields 1 Data Sources 2 Associations

Last Mile UI Route Stops - TP

I_LstMiRouteStopTP is a Transactional CDS View that provides data about "Last Mile UI Route Stops - TP" in SAP S/4HANA. It reads from 1 data source (I_LstMiRouteStop) and exposes 27 fields with key fields LastMileRouteStopUUID, LastMileRouteUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_LstMiRouteStop Stop from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Customer _BusinessPartnerShipTo $projection.ShipToParty = _BusinessPartnerShipTo.Customer
[0..*] I_LstMiUIRouteDocumentTP _DocumentTP $projection.LastMileRouteUUID = _DocumentTP.LastMileRouteUUID and $projection.LastMileRouteStopUUID = _DocumentTP.LastMileRouteStopUUID

Annotations (8)

NameValueLevelField
EndUserText.label Last Mile UI Route Stops - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY LastMileRouteStopUUID I_LstMiRouteStop LastMileRouteStopUUID Stop UUID
KEY LastMileRouteUUID I_LstMiRouteStop LastMileRouteUUID Route UUID
LastMileRouteStopType
LstMiRouteStopProcessingStatus I_LstMiRouteStop LstMiRouteStopProcessingStatus Route Stop Status
ShipToParty I_LstMiRouteStop ShipToParty Ship-To Party (obsolete)
CustomerName _BusinessPartnerShipTo CustomerName Name of Customer
LastMileRouteStop I_LstMiRouteStop LastMileRouteStop Stop ID
LastMileRouteStage I_LstMiRouteStop LastMileRouteStage Stage ID
LastMileRouteStopSequenceValue I_LstMiRouteStop LastMileRouteStopSequenceValue Visit Sequence
TranspOrdStopLocation I_LstMiRouteStop TranspOrdStopLocation Location ID
TranspOrdReqArrivalDteTme I_LstMiRouteStop TranspOrdReqArrivalDteTme Timestamp
TranspOrdReqDepartureDteTme I_LstMiRouteStop TranspOrdReqDepartureDteTme Timestamp
TranspOrdArrivalDateTime I_LstMiRouteStop TranspOrdArrivalDateTime Timestamp
TranspOrdDepartureDateTime I_LstMiRouteStop TranspOrdDepartureDateTime Timestamp
LstMiRouteStopOdometerQuantity I_LstMiRouteStop LstMiRouteStopOdometerQuantity Odometer
LstMiRteOdometerUnitOfMeasure I_LstMiRouteStop LstMiRteOdometerUnitOfMeasure
LastMileRouteReasonCode I_LstMiRouteStop LastMileRouteReasonCode Reason
AddressIDendasAddressID
LstMiRouteStopHasStockTransfer HasStockTransfer LstMiRouteStopHasStockTransfer
_COCIPayment I_LstMiRouteStop _COCIPayment
_COCIProduct I_LstMiRouteStop _COCIProduct
_Collection I_LstMiRouteStop _Collection
_Document I_LstMiRouteStop _Document
_Route I_LstMiRouteStop _Route
_ShipToPartyVH I_LstMiRouteStop _ShipToPartyVH
_RouteTP _RouteTP
_DocumentTP _DocumentTP

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_LstMiRouteStopTP.
-- 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_LstMiRouteStopTP AS
SELECT
  Stop.LastMileRouteStopUUID AS LastMileRouteStopUUID,
  Stop.LastMileRouteUUID AS LastMileRouteUUID,
  Stop.LstMiRouteStopProcessingStatus AS LstMiRouteStopProcessingStatus,
  Stop.ShipToParty AS ShipToParty,
  _BusinessPartnerShipTo.CustomerName AS CustomerName,
  Stop.LastMileRouteStop AS LastMileRouteStop,
  Stop.LastMileRouteStage AS LastMileRouteStage,
  Stop.LastMileRouteStopSequenceValue AS LastMileRouteStopSequenceValue,
  Stop.TranspOrdStopLocation AS TranspOrdStopLocation,
  Stop.TranspOrdReqArrivalDteTme AS TranspOrdReqArrivalDteTme,
  Stop.TranspOrdReqDepartureDteTme AS TranspOrdReqDepartureDteTme,
  Stop.TranspOrdArrivalDateTime AS TranspOrdArrivalDateTime,
  Stop.TranspOrdDepartureDateTime AS TranspOrdDepartureDateTime,
  Stop.LstMiRouteStopOdometerQuantity AS LstMiRouteStopOdometerQuantity,
  Stop.LstMiRteOdometerUnitOfMeasure AS LstMiRteOdometerUnitOfMeasure,
  Stop.LastMileRouteReasonCode AS LastMileRouteReasonCode,
  case when Stop.AddressID is not initial then Stop.AddressID else _BusinessPartnerShipTo.AddressID end as AddressID AS AddressIDendasAddressID,
  HasStockTransfer.LstMiRouteStopHasStockTransfer AS LstMiRouteStopHasStockTransfer,
  Stop._COCIPayment AS _COCIPayment,
  Stop._COCIProduct AS _COCIProduct,
  Stop._Collection AS _Collection,
  Stop._Document AS _Document,
  Stop._Route AS _Route,
  Stop._ShipToPartyVH AS _ShipToPartyVH
FROM I_LstMiRouteStop AS Stop
LEFT OUTER JOIN I_Customer AS _BusinessPartnerShipTo ON ShipToParty = _BusinessPartnerShipTo.Customer  -- association [0..1]
LEFT OUTER JOIN I_LstMiUIRouteDocumentTP AS _DocumentTP ON LastMileRouteUUID = _DocumentTP.LastMileRouteUUID AND LastMileRouteStopUUID = _DocumentTP.LastMileRouteStopUUID  -- association [0..*]
;

Learn More