I_StorePickupOrderItemsTot

DDL: I_STOREPICKUPORDERITEMSTOT SQL: ISTPICKUPORDTOT Type: view COMPOSITE Package: RFM_STORE_PICK_ORD
10 Fields 1 Data Sources 1 Associations

Aggregated items for Order

I_StorePickupOrderItemsTot is a Composite CDS View that provides data about "Aggregated items for Order" in SAP S/4HANA. It reads from 1 data source (I_StorePickupOrderItem) and exposes 10 fields with key fields Store, StorePickUpOrder, Product, ProductStandardID, UnitOfMeasure. 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
[1..1] I_ProductUnitOfMeasureEAN _UnitOfMeasure $projection.Product = _UnitOfMeasure.Product and $projection.UnitOfMeasure = _UnitOfMeasure.AlternativeUnit and _UnitOfMeasure.IsMainGlobalTradeItemNumber = 'X'

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISTPICKUPORDTOT 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 Aggregated items for Order view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Store Store Plant
KEY StorePickUpOrder StorePickUpOrder Store Pickup Order
KEY Product Product Product Sold
KEY ProductStandardID _UnitOfMeasure ProductStandardID GTIN
KEY UnitOfMeasure UnitOfMeasure Unit Protected Qty
RequestedQuantity
ProductPickedQuantity
StoreItemOverallStatus StoreItemOverallStatus Item Overall Status
RetailStoreProductIsEmpties RetailStoreProductIsEmpties
_UnitOfMeasure _UnitOfMeasure

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_StorePickupOrderItemsTot.
-- 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: ISTPICKUPORDTOT

CREATE VIEW I_StorePickupOrderItemsTot AS
SELECT
  Store,
  StorePickUpOrder,
  Product,
  _UnitOfMeasure.ProductStandardID AS ProductStandardID,
  UnitOfMeasure,
  sum (RequestedQuantity) AS RequestedQuantity,
  sum (ProductPickedQuantity) AS ProductPickedQuantity,
  StoreItemOverallStatus,
  RetailStoreProductIsEmpties
FROM I_StorePickupOrderItem
LEFT OUTER JOIN I_ProductUnitOfMeasureEAN AS _UnitOfMeasure ON Product = _UnitOfMeasure.Product AND UnitOfMeasure = _UnitOfMeasure.AlternativeUnit AND _UnitOfMeasure.IsMainGlobalTradeItemNumber = 'X'  -- association [1..1]
;

Learn More