C_LstMiSettlmtOvwRteChkInDiff

DDL: C_LSTMISETTLMTOVWRTECHKINDIFF SQL: CLMDSORCD Type: view CONSUMPTION
19 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

Last Mile Distr Settlmnt Ovw ChkIn Diffs

C_LstMiSettlmtOvwRteChkInDiff is a Consumption CDS View that provides data about "Last Mile Distr Settlmnt Ovw ChkIn Diffs" in SAP S/4HANA. It reads from 1 data source (P_LstMiSettlmtOvwRteDifference) and exposes 19 fields with key field LastMileRouteUUID. It is exposed through 1 OData service (UI_LE_LMD_SETTLMT_OVW). It is used in 1 Fiori application: Route Overview.

Data Sources (1)

SourceAliasJoin Type
P_LstMiSettlmtOvwRteDifference P_LstMiSettlmtOvwRteDifference from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CLMDSORCD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Last Mile Distr Settlmnt Ovw ChkIn Diffs view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
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 (19)

KeyFieldSource TableSource FieldDescription
KEY LastMileRouteUUID LastMileRouteUUID
LastMileRoute LastMileRoute
LastMileRouteType LastMileRouteType
LastMileRouteDepartureLocation LastMileRouteDepartureLocation
LastMileRouteArrivalLocation LastMileRouteArrivalLocation
LstMiRteExecutionOrganization LstMiRteExecutionOrganization
TransportationVehicleDriver TransportationVehicleDriver Driver
ResourceSecondDriver ResourceSecondDriver
LstMiRteArrivalShippingPoint LstMiRteArrivalShippingPoint
TranspOrdDepartureDate TranspOrdDepartureDate
LstMiRteChkInDifferenceAmount LstMiRteChkInDifferenceAmount
LastMileNmbrOfRteWithChkInDiff LastMileNmbrOfRteWithChkInDiff
LastMileRouteCurrency LastMileRouteCurrency
_RouteTypeVH _RouteTypeVH
_ExecutionOrganisationVH _ExecutionOrganisationVH
_DepartureLocationVH _DepartureLocationVH
_RouteDriverVH _RouteDriverVH
_ResourceSecondDriverVH _ResourceSecondDriverVH
_RouteCurrency _RouteCurrency

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 C_LstMiSettlmtOvwRteChkInDiff.
-- 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: CLMDSORCD

CREATE VIEW C_LstMiSettlmtOvwRteChkInDiff AS
SELECT
  LastMileRouteUUID,
  LastMileRoute,
  LastMileRouteType,
  LastMileRouteDepartureLocation,
  LastMileRouteArrivalLocation,
  LstMiRteExecutionOrganization,
  TransportationVehicleDriver,
  ResourceSecondDriver,
  LstMiRteArrivalShippingPoint,
  TranspOrdDepartureDate,
  LstMiRteChkInDifferenceAmount,
  LastMileNmbrOfRteWithChkInDiff,
  LastMileRouteCurrency
FROM P_LstMiSettlmtOvwRteDifference
;

Learn More