I_StorePickupOrderItem

DDL: I_STOREPICKUPORDERITEM SQL: ISTPICKORDITM Type: view COMPOSITE Package: RFM_STORE_PICK_ORD
14 Fields 1 Data Sources 1 Associations

Store Pickup Order Items

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

Data Sources (1)

SourceAliasJoin Type
I_StorePickingRequestItem I_StorePickingRequestItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_StorePickingRequest _StorePickingRequest $projection.Store = _StorePickingRequest.Store and $projection.StorePickingRequest = _StorePickingRequest.StorePickingRequest

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISTPICKORDITM 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 Store Pickup Order Items view

Fields (14)

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

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_StorePickupOrderItem.
-- 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: ISTPICKORDITM

CREATE VIEW I_StorePickupOrderItem AS
SELECT
  Store,
  _StorePickingRequest.StoreReferenceOrder AS StorePickUpOrder,
  StorePickingRequest,
  StorePickingRequestItem,
  Product,
  RequestedQuantity,
  ProductPickedQuantity,
  UnitOfMeasure,
  StorePickingRequestItemStatus,
  StoreItemOverallStatus,
  RequestedStorePickingReqItem,
  StorePkngReqItemIsSubstituted,
  RetailStoreProductIsEmpties
FROM I_StorePickingRequestItem
LEFT OUTER JOIN I_StorePickingRequest AS _StorePickingRequest ON Store = _StorePickingRequest.Store AND StorePickingRequest = _StorePickingRequest.StorePickingRequest  -- association [1..1]
;

Learn More