I_StorePkupOrdSubstitutedItms

DDL: I_STOREPKUPORDSUBSTITUTEDITMS SQL: ISTPICKUPORDSUBS Type: view COMPOSITE Package: RFM_STORE_PICK_ORD
16 Fields 1 Data Sources 1 Associations

Substituted Items in Store Pickup Order

I_StorePkupOrdSubstitutedItms is a Composite CDS View that provides data about "Substituted Items in Store Pickup Order" in SAP S/4HANA. It reads from 1 data source (I_StorePickupOrderItem) and exposes 16 fields with key fields Store, StorePickUpOrder, StorePickingRequest, StorePickingRequestItem, RetailStoreRequestedProduct. It has 1 association to related views. Part of development package RFM_STORE_PICK_ORD.

Data Sources (1)

SourceAliasJoin Type
I_StorePickupOrderItem I_StorePickupOrderItem from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_StorePickupOrderItem _StorePickupOrderItem _StorePickupOrderItem.Store = $projection.Store and _StorePickupOrderItem.StorePickingRequest = $projection.StorePickingRequest and _StorePickupOrderItem.RequestedStorePickingReqItem = $projection.StorePickingRequestItem

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISTPICKUPORDSUBS view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Substituted Items in Store Pickup Order view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY Store Store Plant
KEY StorePickUpOrder StorePickUpOrder Store Pickup Order
KEY StorePickingRequest StorePickingRequest Store Pick Req ID
KEY StorePickingRequestItem StorePickingRequestItem Store Picking Request Item ID
KEY RetailStoreRequestedProduct Product Product Sold
Product _StorePickupOrderItem Product Product Sold
ProductPickedQuantity _StorePickupOrderItem ProductPickedQuantity Picked Item Quantity
RequestedQuantity _StorePickupOrderItem ProductPickedQuantity Picked Item Quantity
RequestedStorePickingReqItem RequestedStorePickingReqItem Requested Item Num
StorePkngReqItemIsSubstituted StorePkngReqItemIsSubstituted Is Substituted
UnitOfMeasure UnitOfMeasure Unit Protected Qty
StorePickingRequestItemStatus StorePickingRequestItemStatus Store Picking Request Item Status
StoreItemOverallStatus StoreItemOverallStatus Item Overall Status
RetailStoreProductIsEmpties RetailStoreProductIsEmpties
_StorePickingRequest _StorePickingRequest
_StorePickupOrderItem _StorePickupOrderItem

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_StorePkupOrdSubstitutedItms.
-- 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: ISTPICKUPORDSUBS

CREATE VIEW I_StorePkupOrdSubstitutedItms AS
SELECT
  Store,
  StorePickUpOrder,
  StorePickingRequest,
  StorePickingRequestItem,
  Product AS RetailStoreRequestedProduct,
  _StorePickupOrderItem.Product AS Product,
  _StorePickupOrderItem.ProductPickedQuantity AS ProductPickedQuantity,
  _StorePickupOrderItem.ProductPickedQuantity AS RequestedQuantity,
  RequestedStorePickingReqItem,
  StorePkngReqItemIsSubstituted,
  UnitOfMeasure,
  StorePickingRequestItemStatus,
  StoreItemOverallStatus,
  RetailStoreProductIsEmpties
FROM I_StorePickupOrderItem
LEFT OUTER JOIN I_StorePickupOrderItem AS _StorePickupOrderItem ON _StorePickupOrderItem.Store = Store AND _StorePickupOrderItem.StorePickingRequest = StorePickingRequest AND _StorePickupOrderItem.RequestedStorePickingReqItem = StorePickingRequestItem  -- association [0..*]
;

Learn More