I_LstMiRouteIDVH

DDL: I_LSTMIROUTEIDVH SQL: ILMDROUTEIDVH Type: view COMPOSITE
9 Fields 2 OData Services 1 Fiori Apps

Last Mile Route ID

I_LstMiRouteIDVH is a Composite CDS View that provides data about "Last Mile Route ID" in SAP S/4HANA. It is exposed through 2 OData services (LMD_ROUTE_MONITOR_SD, UI_LE_LMD_SETTLMT_OVW). It is used in 1 Fiori application: Route Overview.

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ILMDROUTEIDVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Last Mile Route ID view
Search.searchable true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey LastMileRoute view
ClientHandling.algorithm #SESSION_VARIABLE view

OData Services (2)

ServiceBindingVersionContractRelease
LMD_ROUTE_MONITOR_SD LMD_ROUTE_MONITOR_SB_UI_V2 V2 C1 NOT_RELEASED
UI_LE_LMD_SETTLMT_OVW UI_LE_LMD_SETTLMT_OVW V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F4743 Route Overview Transactional An overview page for route and settlement data

Route Overview

Business Role: Transportation Manager - Direct Distribution

With this app, you can see all relevant route information and KPIs at a glance. This information gives you insights into the statuses of routes during the execution and settlement phases so that you can take action if necessary.

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY LastMileRoute LastMileRoute
LastMileRouteType LastMileRouteType
LastMileRouteDepartureLocation LastMileRouteDepartureLocation
LastMileRouteArrivalLocation LastMileRouteArrivalLocation
LstMiRteExecutionOrganization LstMiRteExecutionOrganization
TransportationVehicleDriver TransportationVehicleDriver Driver
_RouteDriverVH _RouteDriverVH
ResourceSecondDriver ResourceSecondDriver
_ResourceSecondDriverVH _ResourceSecondDriverVH

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_LstMiRouteIDVH.
-- 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: ILMDROUTEIDVH

CREATE VIEW I_LstMiRouteIDVH AS
SELECT
  LastMileRoute,
  LastMileRouteType,
  LastMileRouteDepartureLocation,
  LastMileRouteArrivalLocation,
  LstMiRteExecutionOrganization,
  TransportationVehicleDriver,
  ResourceSecondDriver
;

Learn More