C_LastMileReloadReqItemDEX

DDL: C_LASTMILERELOADREQITEMDEX Type: view_entity CONSUMPTION
9 Fields 1 Data Sources 1 Associations

LMD Reload Request Item Data Extraction

C_LastMileReloadReqItemDEX (Consumption)

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

LastMileReloadRequestItem · Supply Chain

C_LastMileReloadReqItemDEX is a Consumption CDS View (Fact) that provides data about "LMD Reload Request Item Data Extraction" in SAP S/4HANA. It reads from 1 data source (I_LastMileReloadRequestItem) and exposes 9 fields with key field LastMileReloadRequestItemUUID. 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_LastMileReloadRequestItem I_LastMileReloadRequestItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_LastMileReloadRequestDEX _ReloadRequest $projection.LastMileReloadRequestUUID = _ReloadRequest.LastMileReloadRequestUUID

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label LMD Reload Request Item Data Extraction 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
ObjectModel.modelingPattern #ANALYTICAL_FACT view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name LastMileReloadRequestItem view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY LastMileReloadRequestItemUUID LastMileReloadRequestItemUUID Reload Request Item UUID
LastMileReloadRequestUUID LastMileReloadRequestUUID Reload Request UUID
Product Product Material Number
Quantity Quantity Quantity field, 15 characters
QuantityUnit QuantityUnit Base Unit of Measure
SDDocumentItem SDDocumentItem Sales Document Item
Plant Plant Plant (Own or External)
StorageLocation StorageLocation Storage Location
_ReloadRequest _ReloadRequest

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_LastMileReloadReqItemDEX.
-- 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_LastMileReloadReqItemDEX AS
SELECT
  LastMileReloadRequestItemUUID,
  LastMileReloadRequestUUID,
  Product,
  Quantity,
  QuantityUnit,
  SDDocumentItem,
  Plant,
  StorageLocation
FROM I_LastMileReloadRequestItem
LEFT OUTER JOIN C_LastMileReloadRequestDEX AS _ReloadRequest ON LastMileReloadRequestUUID = _ReloadRequest.LastMileReloadRequestUUID  -- association [1..1]
;

Learn More