P_LstMiRouteDocumentEnhcdDEX

DDL: P_LSTMIROUTEDOCUMENTENHCDDEX Type: view_entity CONSUMPTION
43 Fields 1 Data Sources

P_LstMiRouteDocumentEnhcdDEX is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_LstMiRouteDocument) and exposes 43 fields with key field LstMiRouteDocumentHeaderUUID.

Data Sources (1)

SourceAliasJoin Type
I_LstMiRouteDocument DocumentHeader from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view

Fields (43)

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
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
_ShipToPartyVH I_LstMiRouteDocument _ShipToPartyVH
_SoldToPartyVH I_LstMiRouteDocument _SoldToPartyVH

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_LstMiRouteDocumentEnhcdDEX.
-- 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 P_LstMiRouteDocumentEnhcdDEX 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,
  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,
  DocumentHeader._ShipToPartyVH AS _ShipToPartyVH,
  DocumentHeader._SoldToPartyVH AS _SoldToPartyVH
FROM I_LstMiRouteDocument AS DocumentHeader
;

Learn More