I_StorePickupOrderReqdItems

DDL: I_STOREPICKUPORDERREQDITEMS SQL: ISTPICKUPORDREQD Type: view COMPOSITE Package: RFM_STORE_PICK_ORD
16 Fields 1 Data Sources

Requested Items in Store Pickup Order

I_StorePickupOrderReqdItems is a Composite CDS View that provides data about "Requested 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, Product. Part of development package RFM_STORE_PICK_ORD.

Data Sources (1)

SourceAliasJoin Type
I_StorePickupOrderItem I_StorePickupOrderItem from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISTPICKUPORDREQD 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 Requested 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 Product Product Product Sold
KEY RetailStoreRequestedProduct Product Product Sold
RequestedQuantity RequestedQuantity Requested Quantity
ProductPickedQuantity 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_StorePickupOrderReqdItems.
-- 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: ISTPICKUPORDREQD

CREATE VIEW I_StorePickupOrderReqdItems AS
SELECT
  Store,
  StorePickUpOrder,
  StorePickingRequest,
  StorePickingRequestItem,
  Product,
  Product AS RetailStoreRequestedProduct,
  RequestedQuantity,
  ProductPickedQuantity,
  RequestedStorePickingReqItem,
  StorePkngReqItemIsSubstituted,
  UnitOfMeasure,
  StorePickingRequestItemStatus,
  StoreItemOverallStatus,
  RetailStoreProductIsEmpties
FROM I_StorePickupOrderItem
;

Learn More