I_StorePickingRequestItem

DDL: I_STOREPICKINGREQUESTITEM SQL: ISTRPICKITEM Type: view BASIC Package: RFM_STORE_PICK_REQ
20 Fields 1 Data Sources 2 Associations

Store Picking Request Item

I_StorePickingRequestItem (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

StorePickingRequestItem · Cross Applications

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

SAP Help Documentation

CategoryOmnichannel Order Fulfillment for Retail
Data CategoryDimension
StatusStore picking request item status
Purpose
This CDS view provides the items list of the store picking requests. This CDS view provides the data to answer the following business question: As of today, how many store picking request items are in short picked status? Which items are those? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Structure
Business Objects This view is built on the Store Picking Request ( StorePickingRequest ) business object. Further Important Fields Important fields in this view include the following: Field Name Description Store store StorePickingRequest Store picking request StorePickingRequestItem Store picking request item Product Product name RequestedQuantity Requested quantity ProductPickedQuantity Product picked quantity UnitOfMeasure Unit of measure StorePickingRequestItemStatus Store picking request item status StoreReferenceOrder Store reference order StoreReferenceOrderItem Store reference order item

SAP Business Warehouse (SAP BW) Extraction
Data Extraction Type Full (physical deletions are possible in source tables)

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessCross Applications
Application ComponentLO-RFM-STO-FIO-2CL
CapabilitiesData Source for Data Extraction,Data Source in SQL Select,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities,Analytical Dimension
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageCross Applications for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the items list of the store picking requests.</p> This CDS view provides the data to answer the following business question:<ul> <li><p>As of today, how many store picking request items are in short picked status? Which items are those?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
rfm_st_pick_reqi rfm_st_pick_reqi from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Site _Site $projection.Store = _Site.Site
[1..1] I_StorePickingRequest _StorePickingRequest $projection.Store = _StorePickingRequest.Store and $projection.StorePickingRequest = _StorePickingRequest.StorePickingRequest

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName ISTRPICKITEM view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
ObjectModel.representativeKey StorePickingRequestItem view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.sapObjectNodeType.name StorePickingRequestItem view
EndUserText.label Store Picking Request Item view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY Store store Retail plant
KEY StorePickingRequest storepickingrequest Store Picking Request ID
KEY StorePickingRequestItem storepickingrequestitem Store Picking Request Item ID
Product product Material Number
RequestedQuantity requestedquantity Requested Item Quantity
ProductPickedQuantity productpickedquantity Picked Item Quantity
UnitOfMeasure unitofmeasure Base Unit of Measure
StorePickingRequestItemStatus storepickingrequestitemstatus Store Picking Request Item Status
StoreReferenceOrder referencestorepickuporder Order Number of the Reference Document
StoreReferenceOrderItem referencestorepickuporderitem Item Number of the Reference Document
StoreItemOverallStatus storeitemoverallstatus Store Picking Request Item Overall Status
RequestedStorePickingReqItem requestedstorepickingreqitem Requested Item Number of Substitute Product
StorePkngReqItemIsSubstituted storepkngreqitemissubstituted Substitution Flag for Store Picking Request Item
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 Level Item Flag for Store Picking Request Item
RetailStoreProductIsEmpties retailstoreproductisempties Retail Store Empties Product Flag
_Site _Site
_StorePickingRequest _StorePickingRequest

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_StorePickingRequestItem.
-- 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: ISTRPICKITEM

CREATE VIEW I_StorePickingRequestItem AS
SELECT
  Store,
  StorePickingRequest,
  StorePickingRequestItem,
  Product,
  RequestedQuantity,
  ProductPickedQuantity,
  UnitOfMeasure,
  StorePickingRequestItemStatus,
  referencestorepickuporder AS StoreReferenceOrder,
  referencestorepickuporderitem AS StoreReferenceOrderItem,
  StoreItemOverallStatus,
  RequestedStorePickingReqItem,
  StorePkngReqItemIsSubstituted,
  ProductRemainingQuantity,
  RetailStoreProdIsPickingCmpltd,
  RetailStoreProdIsNonStock,
  StorePkngReqItemIsHigherLvl,
  RetailStoreProductIsEmpties
FROM rfm_st_pick_reqi
LEFT OUTER JOIN I_Site AS _Site ON Store = _Site.Site  -- association [1..1]
LEFT OUTER JOIN I_StorePickingRequest AS _StorePickingRequest ON Store = _StorePickingRequest.Store AND StorePickingRequest = _StorePickingRequest.StorePickingRequest  -- association [1..1]
;

Learn More