I_LstMiRouteDriverVH

DDL: I_LSTMIROUTEDRIVERVH SQL: ILMDRTEDRIVERVH Type: view COMPOSITE

Last Mile Route Driver VH

I_LstMiRouteDriverVH is a Composite CDS View that provides data about "Last Mile Route Driver VH" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartner) and exposes 5 fields with key field TransportationVehicleDriver. It is exposed through 6 OData services (LMD_ROUTE_COLLECTED_PAYMENT_SD, LMD_ROUTE_CUSTOMERDOCS_SD, LMD_ROUTE_MONITOR_SD, ...). It is used in 2 Fiori applications: Check-Out/In Differences, Route Overview.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartner _BusinessPartner inner

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ILMDRTEDRIVERVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Last Mile Route Driver VH view
Search.searchable true view
ObjectModel.representativeKey TransportationVehicleDriver view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #VALUE_HELP view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
Consumption.ranked true view

OData Services (6)

ServiceBindingVersionContractRelease
LMD_ROUTE_COLLECTED_PAYMENT_SD LMD_ROUTE_COL_PAY_SB_UI_V2 V2 C1 NOT_RELEASED
LMD_ROUTE_CUSTOMERDOCS_SD LMD_ROUTE_CUSTDOC_SB_UI_V2 V2 C1 NOT_RELEASED
LMD_ROUTE_MONITOR_SD LMD_ROUTE_MONITOR_SB_UI_V2 V2 C1 NOT_RELEASED
LMD_ROUTE_STTLMT_SD LMD_ROUTE_STTLMT_SB_UI_V2 V2 C1 NOT_RELEASED
UI_LE_LMD_COCIDIFFS UI_LE_LMD_COCIDIFFS V2 C1 NOT_RELEASED
UI_LE_LMD_SETTLMT_OVW UI_LE_LMD_SETTLMT_OVW V2 C1 NOT_RELEASED

Fiori Apps (2)

App IDApp NameTypeDescription
F4741 Check-Out/In Differences Transactional An application to analyze check-out/in differences for products / material
F4743 Route Overview Transactional An overview page for route and settlement data

Check-Out/In Differences

Business Role: Transportation Manager - Direct Distribution

This feature enables you to track differences between planned and actual check-out quantities and between expected and actual check-in quantities. Thus, you can analyze the efficiency of the loading process and of the route execution.

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 (5)

KeyFieldSource TableSource FieldDescription
KEY TransportationVehicleDriver Routes TransportationVehicleDriver Driver
TranspVehicleDriverName
FirstName I_BusinessPartner FirstName First Name
LastName I_BusinessPartner LastName Last Name
IsBusinessPurposeCompleted I_BusinessPartner IsBusinessPurposeCompleted Purpose Completed

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_LstMiRouteDriverVH.
-- 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: ILMDRTEDRIVERVH

CREATE VIEW I_LstMiRouteDriverVH AS
SELECT
  Routes.TransportationVehicleDriver AS TransportationVehicleDriver,
  cast( _BusinessPartner.BusinessPartnerName as lmd_com_driver_name preserving type ) AS TranspVehicleDriverName,
  _BusinessPartner.FirstName AS FirstName,
  _BusinessPartner.LastName AS LastName,
  _BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
INNER JOIN I_BusinessPartner AS _BusinessPartner ON /* join condition not captured in parsed metadata */
;