I_LstMiRteProcDelivDocumentVH

DDL: I_LSTMIRTEPROCDELIVDOCUMENTVH Type: view_entity COMPOSITE
14 Fields 1 Data Sources

LMD Route Process Delivery Document

I_LstMiRteProcDelivDocumentVH is a Composite CDS View that provides data about "LMD Route Process Delivery Document" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocument) and exposes 14 fields with key field LastMileRouteProcessDocument.

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocument SDDeliveryDocument inner

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label LMD Route Process Delivery Document view
Search.searchable true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey LastMileRouteProcessDocument view
ObjectModel.dataCategory #VALUE_HELP view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Analytics.technicalName ILMRPDOCVH view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY LastMileRouteProcessDocument RouteProcessDeliveryDocument LastMileRouteProcessDocument
DeliveryDate I_DeliveryDocument DeliveryDate Delivery Date
ShipToPartyName
ShipToParty I_DeliveryDocument ShipToParty Ship-To Party (obsolete)
SalesOrganizationName
SalesOrganization I_DeliveryDocument SalesOrganization Sales Organization
ShippingPointName
ShippingPoint I_DeliveryDocument ShippingPoint Shipping Point
DeliveryDocumentType I_DeliveryDocument DeliveryDocumentType Delivery Type
DeliveryDocumentTypeName
_ShipToParty I_DeliveryDocument _ShipToParty
_SalesOrganization I_DeliveryDocument _SalesOrganization
_ShippingPoint I_DeliveryDocument _ShippingPoint
_DeliveryDocumentType I_DeliveryDocument _DeliveryDocumentType

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_LstMiRteProcDelivDocumentVH.
-- 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 I_LstMiRteProcDelivDocumentVH AS
SELECT
  RouteProcessDeliveryDocument.LastMileRouteProcessDocument AS LastMileRouteProcessDocument,
  SDDeliveryDocument.DeliveryDate AS DeliveryDate,
  SDDeliveryDocument._ShipToParty.CustomerName AS ShipToPartyName,
  SDDeliveryDocument.ShipToParty AS ShipToParty,
  SDDeliveryDocument._SalesOrganization._Text[1:Language=$session.system_language].SalesOrganizationName AS SalesOrganizationName,
  SDDeliveryDocument.SalesOrganization AS SalesOrganization,
  SDDeliveryDocument._ShippingPoint._Text[1:Language=$session.system_language].ShippingPointName AS ShippingPointName,
  SDDeliveryDocument.ShippingPoint AS ShippingPoint,
  SDDeliveryDocument.DeliveryDocumentType AS DeliveryDocumentType,
  SDDeliveryDocument._DeliveryDocumentType._Text[1:Language=$session.system_language].DeliveryDocumentTypeName AS DeliveryDocumentTypeName,
  SDDeliveryDocument._ShipToParty AS _ShipToParty,
  SDDeliveryDocument._SalesOrganization AS _SalesOrganization,
  SDDeliveryDocument._ShippingPoint AS _ShippingPoint,
  SDDeliveryDocument._DeliveryDocumentType AS _DeliveryDocumentType
INNER JOIN I_DeliveryDocument AS SDDeliveryDocument ON /* join condition not captured in parsed metadata */
;

Learn More