P_LstMiRteDocsRouteVisit

DDL: P_LSTMIRTEDOCSROUTEVISIT SQL: PLSTMIRTDCSRTEV Type: view COMPOSITE
27 Fields 1 Data Sources 2 Associations

P_LstMiRteDocsRouteVisit is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_LstMiRteDocsVisitWStatus) and exposes 27 fields with key field LastMileRouteVisitUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_LstMiRteDocsVisitWStatus P_LstMiRteDocsVisitWStatus from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_LstMiRteDocsClearingStatus _OverallClearingStatus $projection.LstMiRteVisitHasNotClrdDocs = _OverallClearingStatus.JournalEntryClearingStatus
[1..1] P_LstMiRteDocsExtDocClrgStatus _ExternalDocClrgStatus $projection.LastMileRouteVisitUUID = _ExternalDocClrgStatus.LastMileRouteVisitUUID and $projection.LastMileRoute = _ExternalDocClrgStatus.LastMileRoute and $projection.LastMileRouteDepartureLocation = _ExternalDocClrgStatus.LastMileRouteDepartureLocation and $projection.TranspOrdDepartureDate = _ExternalDocClrgStatus.TranspOrdDepartureDate and $projection.LastMileRouteType = _ExternalDocClrgStatus.LastMileRouteType and $projection.LstMiRteExecutionOrganization = _ExternalDocClrgStatus.LstMiRteExecutionOrganization and $projection.ShipToParty = _ExternalDocClrgStatus.ShipToParty and $projection.TransportationVehicleDriver = _ExternalDocClrgStatus.TransportationVehicleDriver and $projection.ResourceSecondDriver = _ExternalDocClrgStatus.ResourceSecondDriver

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PLSTMIRTDCSRTEV view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
Search.searchable true view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY LastMileRouteVisitUUID LastMileRouteVisitUUID
LastMileRouteUUID LastMileRouteUUID
LastMileRoute LastMileRoute
ShipToParty ShipToParty Ship-To Party (obsolete)
ShipToPartyName ShipToPartyName Ship-To Party Name
TranspOrdDepartureDate TranspOrdDepartureDate
LastMileRouteType LastMileRouteType
LstMiRteExecutionOrganization LstMiRteExecutionOrganization
TransportationVehicleDriver TransportationVehicleDriver Driver
TranspVehicleDriverName _RouteDriverVH TranspVehicleDriverName
ResourceSecondDriver ResourceSecondDriver
LstMiRteVisitIncmpltCritltyCod LstMiRteVisitIncmpltCritltyCod
LstMiRteVisitHasIncmpltDocs LstMiRteVisitHasIncmpltDocs
LastMileRouteDepartureLocation LastMileRouteDepartureLocation
LocationDescription
LstMiRteDocClrdCriticalityCode _ExternalDocClrgStatus LstMiRteDocClrdCriticalityCode
LstMiRteVisitHasNotClrdDocs _ExternalDocClrgStatus LstMiRteVisitHasNotClrdDocs
_Route _Route
_DepartureLocationVH _DepartureLocationVH
_ShipToPartyVH _ShipToPartyVH
_IncompletionStatus _IncompletionStatus
_OverallClearingStatus _OverallClearingStatus
_OutboundDelivery _OutboundDelivery
_RouteDriverVH _RouteDriverVH
_ResourceSecondDriverVH _ResourceSecondDriverVH
_RouteTypeVH _RouteTypeVH
_ExecutionOrganisationVH _ExecutionOrganisationVH

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 P_LstMiRteDocsRouteVisit.
-- 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: PLSTMIRTDCSRTEV

CREATE VIEW P_LstMiRteDocsRouteVisit AS
SELECT
  LastMileRouteVisitUUID,
  LastMileRouteUUID,
  LastMileRoute,
  ShipToParty,
  ShipToPartyName,
  TranspOrdDepartureDate,
  LastMileRouteType,
  LstMiRteExecutionOrganization,
  TransportationVehicleDriver,
  _RouteDriverVH.TranspVehicleDriverName AS TranspVehicleDriverName,
  ResourceSecondDriver,
  LstMiRteVisitIncmpltCritltyCod,
  LstMiRteVisitHasIncmpltDocs,
  LastMileRouteDepartureLocation,
  _DepartureLocationVH._Text[1: Language = $session.system_language].LocationDescription AS LocationDescription,
  _ExternalDocClrgStatus.LstMiRteDocClrdCriticalityCode AS LstMiRteDocClrdCriticalityCode,
  _ExternalDocClrgStatus.LstMiRteVisitHasNotClrdDocs AS LstMiRteVisitHasNotClrdDocs
FROM P_LstMiRteDocsVisitWStatus
LEFT OUTER JOIN I_LstMiRteDocsClearingStatus AS _OverallClearingStatus ON LstMiRteVisitHasNotClrdDocs = _OverallClearingStatus.JournalEntryClearingStatus  -- association [0..1]
LEFT OUTER JOIN P_LstMiRteDocsExtDocClrgStatus AS _ExternalDocClrgStatus ON LastMileRouteVisitUUID = _ExternalDocClrgStatus.LastMileRouteVisitUUID AND LastMileRoute = _ExternalDocClrgStatus.LastMileRoute AND LastMileRouteDepartureLocation = _ExternalDocClrgStatus.LastMileRouteDepartureLocation AND TranspOrdDepartureDate = _ExternalDocClrgStatus.TranspOrdDepartureDate AND LastMileRouteType = _ExternalDocClrgStatus.LastMileRouteType AND LstMiRteExecutionOrganization = _ExternalDocClrgStatus.LstMiRteExecutionOrganization AND ShipToParty = _ExternalDocClrgStatus.ShipToParty AND TransportationVehicleDriver = _ExternalDocClrgStatus.TransportationVehicleDriver AND ResourceSecondDriver = _ExternalDocClrgStatus.ResourceSecondDriver  -- association [1..1]
;

Learn More