I_StorePickingRequestItemTP

DDL: I_STOREPICKINGREQUESTITEMTP SQL: ISTRPICKITEMTP Type: view_entity TRANSACTIONAL Package: RFM_STORE_PICK_REQ
25 Fields 1 Data Sources 5 Associations

Store Picking Request Item

I_StorePickingRequestItemTP is a Transactional CDS View that provides data about "Store Picking Request Item" in SAP S/4HANA. It reads from 1 data source (I_StorePickingRequestItem) and exposes 25 fields with key fields Store, StorePickingRequest, StorePickingRequestItem. It has 5 associations to related views. Part of development package RFM_STORE_PICK_REQ.

Data Sources (1)

SourceAliasJoin Type
I_StorePickingRequestItem Item from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_ProductUnitOfMeasureEAN _UnitOfMeasure $projection.Product = _UnitOfMeasure.Product and $projection.UnitOfMeasure = _UnitOfMeasure.AlternativeUnit and _UnitOfMeasure.IsMainGlobalTradeItemNumber = 'X'
[0..1] I_ProductText _ProductText $projection.Product = _ProductText.Product and _ProductText.Language = $session.system_language
[0..1] E_StorePickingRequestItem _ItemExtension Item.Store = _ItemExtension.Store and Item.StorePickingRequest = _ItemExtension.StorePickingRequest and Item.StorePickingRequestItem = _ItemExtension.StorePickingRequestItem
[0..1] I_ProductPlant _ProductPlant $projection.Product = _ProductPlant.Product and $projection.Store = _ProductPlant.Plant
[0..*] I_StorePkngReqItmSrlNmbrTP _ItemSerialNumber

Annotations (7)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Store Picking Request Item view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY Store Store Plant
KEY StorePickingRequest StorePickingRequest Store Pick Req ID
KEY StorePickingRequestItem StorePickingRequestItem Store Picking Request Item ID
Product Product Product Sold
StoreReferenceOrderItem StoreReferenceOrderItem Items No.
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
StoreReferenceOrder StoreReferenceOrder Ref Order No.
RequestedStorePickingReqItem RequestedStorePickingReqItem Requested Item Num
StorePkngReqItemIsSubstituted StorePkngReqItemIsSubstituted Is Substituted
ProductRemainingQuantity ProductRemainingQuantity Remaining item quantity
RetailStoreProdIsPickingCmpltd RetailStoreProdIsPickingCmpltd Picking completed flag for Store Picking Request Item
RetailStoreProdIsNonStock RetailStoreProdIsNonStock Retail Store Non Stock Product flag
StorePkngReqItemIsHigherLvl StorePkngReqItemIsHigherLvl Higher Lvl Item Flag
RetailStoreProductIsEmpties RetailStoreProductIsEmpties
SerialNumberProfile _ProductPlant SerialNumberProfile SerialNoProfile
RetailStoreImageType
ProductStandardID _UnitOfMeasure ProductStandardID GTIN
ProductName _ProductText ProductName Description
_Request _Request
_ProductPlant _ProductPlant
_ItemSerialNumber _ItemSerialNumber

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_StorePickingRequestItemTP.
-- 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: ISTRPICKITEMTP

CREATE VIEW I_StorePickingRequestItemTP AS
SELECT
  Store,
  StorePickingRequest,
  StorePickingRequestItem,
  Product,
  StoreReferenceOrderItem,
  RequestedQuantity,
  ProductPickedQuantity,
  UnitOfMeasure,
  StorePickingRequestItemStatus,
  StoreItemOverallStatus,
  StoreReferenceOrder,
  RequestedStorePickingReqItem,
  StorePkngReqItemIsSubstituted,
  ProductRemainingQuantity,
  RetailStoreProdIsPickingCmpltd,
  RetailStoreProdIsNonStock,
  StorePkngReqItemIsHigherLvl,
  RetailStoreProductIsEmpties,
  _ProductPlant.SerialNumberProfile AS SerialNumberProfile,
  cast('THU' as char3 ) AS RetailStoreImageType,
  _UnitOfMeasure.ProductStandardID AS ProductStandardID,
  _ProductText.ProductName AS ProductName
FROM I_StorePickingRequestItem AS Item
LEFT OUTER JOIN I_ProductUnitOfMeasureEAN AS _UnitOfMeasure ON Product = _UnitOfMeasure.Product AND UnitOfMeasure = _UnitOfMeasure.AlternativeUnit AND _UnitOfMeasure.IsMainGlobalTradeItemNumber = 'X'  -- association [1..1]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product AND _ProductText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_StorePickingRequestItem AS _ItemExtension ON Item.Store = _ItemExtension.Store AND Item.StorePickingRequest = _ItemExtension.StorePickingRequest AND Item.StorePickingRequestItem = _ItemExtension.StorePickingRequestItem  -- association [0..1]
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON Product = _ProductPlant.Product AND Store = _ProductPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorePkngReqItmSrlNmbrTP AS _ItemSerialNumber ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More