I_LstMiRouteDocumentEnhanced

DDL: I_LSTMIROUTEDOCUMENTENHANCED Type: view_entity COMPOSITE
87 Fields 2 Data Sources

Last Mile Distribution Document Enhanced

I_LstMiRouteDocumentEnhanced is a Composite CDS View that provides data about "Last Mile Distribution Document Enhanced" in SAP S/4HANA. It reads from 2 data sources (I_LstMiRouteDocument, I_LstMiRouteDocument) and exposes 87 fields with key field LstMiRouteDocumentHeaderUUID.

Data Sources (2)

SourceAliasJoin Type
I_LstMiRouteDocument DocumentHeader from
I_LstMiRouteDocument DocumentHeader union_all

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Last Mile Distribution Document Enhanced view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #REQUIRED view

Fields (87)

KeyFieldSource TableSource FieldDescription
KEY LstMiRouteDocumentHeaderUUID I_LstMiRouteDocument LstMiRouteDocumentHeaderUUID Document Header UUID
LastMileRouteStopUUID I_LstMiRouteDocument LastMileRouteStopUUID Stop UUID
LastMileRouteUUID I_LstMiRouteDocument LastMileRouteUUID Route UUID
SDDocument I_LstMiRouteDocument SDDocument SD Document
LastMileRouteDocumentType I_LstMiRouteDocument LastMileRouteDocumentType Document Type
SoldToParty I_LstMiRouteDocument SoldToParty Sold-to Party
ShiptoParty I_LstMiRouteDocument ShiptoParty Ship-To Party (obsolete)
SalesOrganization I_LstMiRouteDocument SalesOrganization Sales Organization
DistributionChannel I_LstMiRouteDocument DistributionChannel RefDistCh-Cust/Mat.
Division I_LstMiRouteDocument Division Internal Division ID
AddressID I_LstMiRouteDocument AddressID Ship-to address
LastMileRouteDocumentDate I_LstMiRouteDocument LastMileRouteDocumentDate Reversal Doc Date
LstMiRouteDocumentReasonCode I_LstMiRouteDocument LstMiRouteDocumentReasonCode Return/Change Reason
LstMiRteDocumentSignatureDate I_LstMiRouteDocument LstMiRteDocumentSignatureDate Signature Date
CustomerReferenceNumber I_LstMiRouteDocument CustomerReferenceNumber
LstMiRteCustRlvtOrderNumber I_LstMiRouteDocument LstMiRteCustRlvtOrderNumber Reference Document No.
LastMileRouteDocumentIsReturn I_LstMiRouteDocument LastMileRouteDocumentIsReturn Return
LastMileRouteIsMnllyAddedRecd I_LstMiRouteDocument LastMileRouteIsMnllyAddedRecd Manually Added
LastMileStockTransferType I_LstMiRouteDocument LastMileStockTransferType Transfer Type
LastMileReferenceRoute I_LstMiRouteDocument LastMileReferenceRoute Reference Route ID
CustomerPaymentTerms I_LstMiRouteDocument CustomerPaymentTerms Pyt Terms
LastMileRouteSDDocumentType I_LstMiRouteDocument LastMileRouteSDDocumentType SD Doc. Type
LastMileRouteRequestedDelivDte I_LstMiRouteDocument LastMileRouteRequestedDelivDte Requested Dlvy Date
LstMiIsDocCreatedBySettlement I_LstMiRouteDocument LstMiIsDocCreatedBySettlement Created by Settlmt
LastMileRouteDocumentYear I_LstMiRouteDocument LastMileRouteDocumentYear Fiscal Year
DocumentReferenceID I_LstMiRouteDocument DocumentReferenceID Reference
LastMileRouteDocumentAmount I_LstMiRouteDocument LastMileRouteDocumentAmount amount
LstMiRtePriceCondition1Value I_LstMiRouteDocument LstMiRtePriceCondition1Value
LstMiRtePriceCondition2Value I_LstMiRouteDocument LstMiRtePriceCondition2Value
LstMiRtePriceCondition3Value I_LstMiRouteDocument LstMiRtePriceCondition3Value
LstMiRtePriceCondition4Value I_LstMiRouteDocument LstMiRtePriceCondition4Value
LastMileRouteCurrency I_LstMiRouteDocument LastMileRouteCurrency Valuation Crcy
LstMiRteAssgdPaytColltdAmount I_LstMiRouteDocument LstMiRteAssgdPaytColltdAmount Assigned Amount
LstMiRteVstIsCancldByRsnCode StopReasonUsage LstMiRteVstIsCancldByRsnCode
LstMiRteDocIsCancldByRsnCode
LastMileRouteVisitUUID I_LstMiRouteDocument LastMileRouteVisitUUID
LastMileRouteDocumentNumber I_LstMiRouteDocument LastMileRouteDocumentNumber Snapshot ID
LastMileRouteOriginCode I_LstMiRouteDocument LastMileRouteOriginCode Origin
LstMiRteIsUpdtdInTranspMgmt I_LstMiRouteDocument LstMiRteIsUpdtdInTranspMgmt Updated in TM
_Item I_LstMiRouteDocument _Item
_Route I_LstMiRouteDocument _Route
_Stop I_LstMiRouteDocument _Stop
LstMiRteIsSh2PBusPrpsCmpltd ShipToParty IsBusinessPurposeCompleted Purpose Completed
LstMiRouteDocumentHeaderUUID Document Header UUID
LastMileRouteStopUUID I_LstMiRouteDocument LastMileRouteStopUUID Stop UUID
LastMileRouteUUID I_LstMiRouteDocument LastMileRouteUUID Route UUID
SDDocument I_LstMiRouteDocument SDDocument SD Document
LastMileRouteDocumentType I_LstMiRouteDocument LastMileRouteDocumentType Document Type
SoldToParty I_LstMiRouteDocument SoldToParty Sold-to Party
ShiptoParty I_LstMiRouteDocument ShiptoParty Ship-To Party (obsolete)
SalesOrganization I_LstMiRouteDocument SalesOrganization Sales Organization
DistributionChannel I_LstMiRouteDocument DistributionChannel RefDistCh-Cust/Mat.
Division I_LstMiRouteDocument Division Internal Division ID
AddressID I_LstMiRouteDocument AddressID Ship-to address
LastMileRouteDocumentDate I_LstMiRouteDocument LastMileRouteDocumentDate Reversal Doc Date
LstMiRouteDocumentReasonCode I_LstMiRouteDocument LstMiRouteDocumentReasonCode Return/Change Reason
LstMiRteDocumentSignatureDate I_LstMiRouteDocument LstMiRteDocumentSignatureDate Signature Date
CustomerReferenceNumber I_LstMiRouteDocument CustomerReferenceNumber
LstMiRteCustRlvtOrderNumber I_LstMiRouteDocument LstMiRteCustRlvtOrderNumber Reference Document No.
LastMileRouteDocumentIsReturn I_LstMiRouteDocument LastMileRouteDocumentIsReturn Return
LastMileRouteIsMnllyAddedRecd I_LstMiRouteDocument LastMileRouteIsMnllyAddedRecd Manually Added
LastMileStockTransferType I_LstMiRouteDocument LastMileStockTransferType Transfer Type
LastMileReferenceRoute I_LstMiRouteDocument LastMileReferenceRoute Reference Route ID
CustomerPaymentTerms I_LstMiRouteDocument CustomerPaymentTerms Pyt Terms
LastMileRouteSDDocumentType I_LstMiRouteDocument LastMileRouteSDDocumentType SD Doc. Type
LastMileRouteRequestedDelivDte I_LstMiRouteDocument LastMileRouteRequestedDelivDte Requested Dlvy Date
LstMiIsDocCreatedBySettlement I_LstMiRouteDocument LstMiIsDocCreatedBySettlement Created by Settlmt
LastMileRouteDocumentYear I_LstMiRouteDocument LastMileRouteDocumentYear Fiscal Year
DocumentReferenceID I_LstMiRouteDocument DocumentReferenceID Reference
LastMileRouteDocumentAmount I_LstMiRouteDocument LastMileRouteDocumentAmount amount
LstMiRtePriceCondition1Value I_LstMiRouteDocument LstMiRtePriceCondition1Value
LstMiRtePriceCondition2Value I_LstMiRouteDocument LstMiRtePriceCondition2Value
LstMiRtePriceCondition3Value I_LstMiRouteDocument LstMiRtePriceCondition3Value
LstMiRtePriceCondition4Value I_LstMiRouteDocument LstMiRtePriceCondition4Value
LastMileRouteCurrency I_LstMiRouteDocument LastMileRouteCurrency Valuation Crcy
LstMiRteAssgdPaytColltdAmount I_LstMiRouteDocument LstMiRteAssgdPaytColltdAmount Assigned Amount
LstMiRteVstIsCancldByRsnCode StopReasonUsage LstMiRteVstIsCancldByRsnCode
LstMiRteDocIsCancldByRsnCode
LastMileRouteVisitUUID I_LstMiRouteDocument LastMileRouteVisitUUID
LastMileRouteDocumentNumber I_LstMiRouteDocument LastMileRouteDocumentNumber Snapshot ID
LastMileRouteOriginCode I_LstMiRouteDocument LastMileRouteOriginCode Origin
LstMiRteIsUpdtdInTranspMgmt I_LstMiRouteDocument LstMiRteIsUpdtdInTranspMgmt Updated in TM
_Item I_LstMiRouteDocument _Item
_Route I_LstMiRouteDocument _Route
_Stop I_LstMiRouteDocument _Stop
LstMiRteIsSh2PBusPrpsCmpltd ShipToParty IsBusinessPurposeCompleted Purpose Completed
LstMiRteIsSo2PBusPrpsCmpltd SoldToParty 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_LstMiRouteDocumentEnhanced.
-- 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_LstMiRouteDocumentEnhanced AS
SELECT
  DocumentHeader.LstMiRouteDocumentHeaderUUID AS LstMiRouteDocumentHeaderUUID,
  DocumentHeader.LastMileRouteStopUUID AS LastMileRouteStopUUID,
  DocumentHeader.LastMileRouteUUID AS LastMileRouteUUID,
  DocumentHeader.SDDocument AS SDDocument,
  DocumentHeader.LastMileRouteDocumentType AS LastMileRouteDocumentType,
  DocumentHeader.SoldToParty AS SoldToParty,
  DocumentHeader.ShiptoParty AS ShiptoParty,
  DocumentHeader.SalesOrganization AS SalesOrganization,
  DocumentHeader.DistributionChannel AS DistributionChannel,
  DocumentHeader.Division AS Division,
  DocumentHeader.AddressID AS AddressID,
  DocumentHeader.LastMileRouteDocumentDate AS LastMileRouteDocumentDate,
  DocumentHeader.LstMiRouteDocumentReasonCode AS LstMiRouteDocumentReasonCode,
  DocumentHeader.LstMiRteDocumentSignatureDate AS LstMiRteDocumentSignatureDate,
  DocumentHeader.CustomerReferenceNumber AS CustomerReferenceNumber,
  DocumentHeader.LstMiRteCustRlvtOrderNumber AS LstMiRteCustRlvtOrderNumber,
  DocumentHeader.LastMileRouteDocumentIsReturn AS LastMileRouteDocumentIsReturn,
  DocumentHeader.LastMileRouteIsMnllyAddedRecd AS LastMileRouteIsMnllyAddedRecd,
  DocumentHeader.LastMileStockTransferType AS LastMileStockTransferType,
  DocumentHeader.LastMileReferenceRoute AS LastMileReferenceRoute,
  DocumentHeader.CustomerPaymentTerms AS CustomerPaymentTerms,
  DocumentHeader.LastMileRouteSDDocumentType AS LastMileRouteSDDocumentType,
  DocumentHeader.LastMileRouteRequestedDelivDte AS LastMileRouteRequestedDelivDte,
  DocumentHeader.LstMiIsDocCreatedBySettlement AS LstMiIsDocCreatedBySettlement,
  DocumentHeader.LastMileRouteDocumentYear AS LastMileRouteDocumentYear,
  DocumentHeader.DocumentReferenceID AS DocumentReferenceID,
  DocumentHeader.LastMileRouteDocumentAmount AS LastMileRouteDocumentAmount,
  DocumentHeader.LstMiRtePriceCondition1Value AS LstMiRtePriceCondition1Value,
  DocumentHeader.LstMiRtePriceCondition2Value AS LstMiRtePriceCondition2Value,
  DocumentHeader.LstMiRtePriceCondition3Value AS LstMiRtePriceCondition3Value,
  DocumentHeader.LstMiRtePriceCondition4Value AS LstMiRtePriceCondition4Value,
  DocumentHeader.LastMileRouteCurrency AS LastMileRouteCurrency,
  DocumentHeader.LstMiRteAssgdPaytColltdAmount AS LstMiRteAssgdPaytColltdAmount,
  StopReasonUsage.LstMiRteVstIsCancldByRsnCode AS LstMiRteVstIsCancldByRsnCode,
  '' AS LstMiRteDocIsCancldByRsnCode,
  DocumentHeader.LastMileRouteVisitUUID AS LastMileRouteVisitUUID,
  DocumentHeader.LastMileRouteDocumentNumber AS LastMileRouteDocumentNumber,
  DocumentHeader.LastMileRouteOriginCode AS LastMileRouteOriginCode,
  DocumentHeader.LstMiRteIsUpdtdInTranspMgmt AS LstMiRteIsUpdtdInTranspMgmt,
  DocumentHeader._Item AS _Item,
  DocumentHeader._Route AS _Route,
  DocumentHeader._Stop AS _Stop,
  ShipToParty.IsBusinessPurposeCompleted AS LstMiRteIsSh2PBusPrpsCmpltd,
  SoldToParty.IsBusinessPurposeCompleted AS LstMiRteIsSo2PBusPrpsCmpltd
FROM I_LstMiRouteDocument AS DocumentHeader
-- UNION ALL with additional select branch(es): I_LstMiRouteDocument
;

Learn More