C_LstMiRteProcDeliveryDocument

DDL: C_LSTMIRTEPROCDELIVERYDOCUMENT Type: view_entity CONSUMPTION
21 Fields 1 Data Sources 1 OData Services

LMD Route Process Delivery Document

C_LstMiRteProcDeliveryDocument is a Consumption CDS View that provides data about "LMD Route Process Delivery Document" in SAP S/4HANA. It reads from 1 data source (R_LstMiRteProcDlvDocumentTP) and exposes 21 fields with key field LstMiRouteProcessDocumentUUID. It is exposed through 1 OData service (UI_LASTMILEROUTEPROCESS).

Data Sources (1)

SourceAliasJoin Type
R_LstMiRteProcDlvDocumentTP R_LstMiRteProcDlvDocumentTP projection

Annotations (7)

NameValueLevelField
EndUserText.label LMD Route Process Delivery Document view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
UI_LASTMILEROUTEPROCESS UI_LASTMILEROUTEPROCESS V4 C1 NOT_RELEASED

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY LstMiRouteProcessDocumentUUID LstMiRouteProcessDocumentUUID
LastMileRouteProcessUUID LastMileRouteProcessUUID
LastMileRouteProcessDocument LastMileRouteProcessDocument
LstMiRouteProcessDocumentType LstMiRouteProcessDocumentType
ShipToParty _SDDelivery ShipToParty Ship-To Party (obsolete)
CustomerName
CityName
Region
PostalCode
OverallPickingStatus OverallPickingStatus
OverallPickingStatusDesclocalized
ReadyForWarehouseExecStatus ReadyForWarehouseExecStatus
SafetyDataSheetStatusDesclocalized
LastMileRoutePostingStatus LastMileRoutePostingStatus
LstMiRteProcRteStockStatusTextlocalized
char55
_SDDelivery _SDDelivery
_SDDocumentPartner _SDDocumentPartner
_PickingStatusText _PickingStatusText
_WarehouseStatusText _WarehouseStatusText
_RouteStockStatusText _RouteStockStatusText

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_LstMiRteProcDeliveryDocument.
-- 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.

CREATE VIEW C_LstMiRteProcDeliveryDocument AS
SELECT
  LstMiRouteProcessDocumentUUID,
  LastMileRouteProcessUUID,
  LastMileRouteProcessDocument,
  LstMiRouteProcessDocumentType,
  _SDDelivery.ShipToParty AS ShipToParty,
  _SDDocumentPartner._DfltAddrRprstn.AddresseeFullName AS CustomerName,
  _SDDocumentPartner._DfltAddrRprstn.CityName AS CityName,
  _SDDocumentPartner._DfltAddrRprstn.Region AS Region,
  _SDDocumentPartner._DfltAddrRprstn.PostalCode AS PostalCode,
  OverallPickingStatus,
  _PickingStatusText.OverallPickingStatusDesc : localized AS OverallPickingStatusDesclocalized,
  ReadyForWarehouseExecStatus,
  _WarehouseStatusText.SafetyDataSheetStatusDesc : localized AS SafetyDataSheetStatusDesclocalized,
  LastMileRoutePostingStatus,
  _RouteStockStatusText.LstMiRteProcRteStockStatusText : localized AS LstMiRteProcRteStockStatusTextlocalized,
  virtual LstMiRteProcDlvAddrShortText : abap.char( 55 ) AS char55
FROM R_LstMiRteProcDlvDocumentTP
;

Learn More