C_LstMiRouteDocumentItemDEX

DDL: C_LSTMIROUTEDOCUMENTITEMDEX SQL: CLMRDOCIDEX Type: view CONSUMPTION
30 Fields 1 Data Sources 1 Associations

Last Mile Distribution Doc Itm Data Extr

C_LstMiRouteDocumentItemDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

LastMileRouteDocumentItem · Supply Chain

C_LstMiRouteDocumentItemDEX is a Consumption CDS View (Fact) that provides data about "Last Mile Distribution Doc Itm Data Extr" in SAP S/4HANA. It reads from 1 data source (I_LstMiRteDocumentItemEnhanced) and exposes 30 fields with key field LastMileRouteDocumentItemUUID. It has 1 association to related views.

SAP API Hub

StateC1
Line of BusinessSupply Chain
Application ComponentLE-LMD
CapabilitiesData Source for Data Extraction
PackageSupply Chain for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_LstMiRteDocumentItemEnhanced I_LstMiRteDocumentItemEnhanced from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_LstMiRouteDEX _Route $projection.LastMileRouteUUID = _Route.LastMileRouteUUID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CLMRDOCIDEX view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Last Mile Distribution Doc Itm Data Extr view
Analytics.dataCategory #FACT view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_FACT view
ObjectModel.sapObjectNodeType.name LastMileRouteDocumentItem view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY LastMileRouteDocumentItemUUID LastMileRouteDocumentItemUUID Document Item UUID
LastMileRouteUUID LastMileRouteUUID DB Key
LastMileRouteStopUUID LastMileRouteStopUUID DB Key
LstMiRouteDocumentHeaderUUID LstMiRouteDocumentHeaderUUID DB Key
LastMileRouteDocumentType LastMileRouteDocumentType Document Type
SDDocument SDDocument Document No.
SDDocumentItem SDDocumentItem Item ID
HigherLevelItem HigherLevelItem Higher-Lev.Item
ProductID ProductID Product ID
LastMileRoutePlannedQuantity LastMileRoutePlannedQuantity Quantity
LastMileRouteActualQuantity LastMileRouteActualQuantity Quantity
UnitOfMsrOfDelivUnit UnitOfMsrOfDelivUnit Unit of Measurement
Batch Batch Lot No.
Plant Plant Valuation Area
LastMileRouteProductIsReturn LastMileRouteProductIsReturn Item Is Return Item
LastMileRouteProductIsFreeGood LastMileRouteProductIsFreeGood Item Is Free Goods Item
LastMileRouteItemReasonCode LastMileRouteItemReasonCode Reason Code
LastMileRouteRefDocumentType LastMileRouteRefDocumentType Document Type
ReferenceSDDocument ReferenceSDDocument Reference Doc.
ReferenceSDDocumentItem ReferenceSDDocumentItem Reference Item
CustomerReferenceNumber CustomerReferenceNumber Customer Reference Number
LastMileRouteUnloadingLocation LastMileRouteUnloadingLocation Unloading Point
LastMileRouteIsMnllyAddedRecd LastMileRouteIsMnllyAddedRecd Is Manually Added
LastMileRouteItemIsTiedEmpty LastMileRouteItemIsTiedEmpty Is Tied Empty
LastMileRouteItemIsUntiedEmpty LastMileRouteItemIsUntiedEmpty Is Untied Empty
LstMiRouteDocumentItemCurrency LstMiRouteDocumentItemCurrency Currency Code
LstMiRouteDocumentItemAmount LstMiRouteDocumentItemAmount Payment Amount
OmniChannelSalesPromotion OmniChannelSalesPromotion ID for Omnichannel Sales Promotion
LstMiRteOmniChannelFreeGoodsID LstMiRteOmniChannelFreeGoodsID Free Goods ID of Omnichannel Sales Promotions
_Route _Route

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_LstMiRouteDocumentItemDEX.
-- 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: CLMRDOCIDEX

CREATE VIEW C_LstMiRouteDocumentItemDEX AS
SELECT
  LastMileRouteDocumentItemUUID,
  LastMileRouteUUID,
  LastMileRouteStopUUID,
  LstMiRouteDocumentHeaderUUID,
  LastMileRouteDocumentType,
  SDDocument,
  SDDocumentItem,
  HigherLevelItem,
  ProductID,
  LastMileRoutePlannedQuantity,
  LastMileRouteActualQuantity,
  UnitOfMsrOfDelivUnit,
  Batch,
  Plant,
  LastMileRouteProductIsReturn,
  LastMileRouteProductIsFreeGood,
  LastMileRouteItemReasonCode,
  LastMileRouteRefDocumentType,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  CustomerReferenceNumber,
  LastMileRouteUnloadingLocation,
  LastMileRouteIsMnllyAddedRecd,
  LastMileRouteItemIsTiedEmpty,
  LastMileRouteItemIsUntiedEmpty,
  LstMiRouteDocumentItemCurrency,
  LstMiRouteDocumentItemAmount,
  OmniChannelSalesPromotion,
  LstMiRteOmniChannelFreeGoodsID
FROM I_LstMiRteDocumentItemEnhanced
LEFT OUTER JOIN C_LstMiRouteDEX AS _Route ON LastMileRouteUUID = _Route.LastMileRouteUUID  -- association [1..1]
;

Learn More