I_StorePkupOrdSubstitutedItms

DDL: I_STOREPKUPORDSUBSTITUTEDITMS SQL: ISTPICKUPORDSUBS Type: view COMPOSITE
15 Fields 1 Data Sources

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 15 fields with key fields Store, StorePickUpOrder, StorePickingRequest, StorePickingRequestItem, RetailStoreRequestedProduct.

Data Sources (1)

SourceAliasJoin Type
I_StorePickupOrderItem I_StorePickupOrderItem from

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 (15)

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
_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
FROM I_StorePickupOrderItem
;

Learn More