I_LstMiRouteDriverVH
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)
| Source | Alias | Join Type |
|---|---|---|
| I_BusinessPartner | _BusinessPartner | inner |
Annotations (15)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| 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 ID | App Name | Type | Description |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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 */
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- OData Services in SAP S/4HANA Explained
- Service Bindings and Service Definitions in SAP S/4HANA
- SAP Fiori Apps Architecture — How Fiori Apps Connect to Data
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA