I_StorePickupOrderPickedItemTP

DDL: I_STOREPICKUPORDERPICKEDITEMTP SQL: ISTPKORDPKITM Type: view_entity TRANSACTIONAL Package: RFM_STORE_PICK_ORD
11 Fields 1 Data Sources 1 Associations

Picked Items for Order

I_StorePickupOrderPickedItemTP is a Transactional CDS View that provides data about "Picked Items for Order" in SAP S/4HANA. It reads from 1 data source (I_StorePickupOrderItemsTot) and exposes 11 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_StorePickupOrderItemsTot I_StorePickupOrderItemsTot from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ProductText _ProductText $projection.Product = _ProductText.Product and _ProductText.Language = $session.system_language

Annotations (6)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Picked Items for Order view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Store Store Plant
KEY StorePickUpOrder StorePickUpOrder Store Pickup Order
KEY Product Product Product Sold
KEY ProductStandardID ProductStandardID GTIN
KEY UnitOfMeasure UnitOfMeasure Unit Protected Qty
RequestedQuantity RequestedQuantity Requested Quantity
ProductPickedQuantity ProductPickedQuantity Picked Item Quantity
RetailStoreProductIsEmpties RetailStoreProductIsEmpties
ProductName _ProductText ProductName Description
RetailStoreImageType
_StorePickupOrder _StorePickupOrder

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_StorePickupOrderPickedItemTP.
-- 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: ISTPKORDPKITM

CREATE VIEW I_StorePickupOrderPickedItemTP AS
SELECT
  Store,
  StorePickUpOrder,
  Product,
  ProductStandardID,
  UnitOfMeasure,
  RequestedQuantity,
  ProductPickedQuantity,
  RetailStoreProductIsEmpties,
  _ProductText.ProductName AS ProductName,
  cast('THU' as rtst_image_type ) AS RetailStoreImageType
FROM I_StorePickupOrderItemsTot
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product AND _ProductText.Language = $session.system_language  -- association [0..1]
;

Learn More