C_StorePickingRequestItem

DDL: C_STOREPICKINGREQUESTITEM Type: view_entity CONSUMPTION Package: RFM_STORE_PICK_PRODUCTS
24 Fields 1 Data Sources 1 Associations 2 OData Services 1 Fiori Apps

Store Pick Request Item

C_StorePickingRequestItem is a Consumption CDS View that provides data about "Store Pick Request Item" in SAP S/4HANA. It reads from 1 data source (I_StorePickingRequestItemTP) and exposes 24 fields with key fields Store, StorePickingRequest, StorePickingRequestItem. It has 1 association to related views. It is exposed through 2 OData services (ASQL_F4643, UI_RFM_STORE_PICKPROD). It is used in 1 Fiori application: Process Picking Requests. Part of development package RFM_STORE_PICK_PRODUCTS.

Data Sources (1)

SourceAliasJoin Type
I_StorePickingRequestItemTP I_StorePickingRequestItemTP projection

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_ProductUnitOfMeasureEAN _ProductGTIN $projection.Product = _ProductGTIN.Product and $projection.UnitOfMeasure = _ProductGTIN.AlternativeUnit

Annotations (6)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Store Pick Request Item view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F4643 ASQL_F4643 C2 NOT_RELEASED
UI_RFM_STORE_PICKPROD UI_RFM_STORE_PICKPROD V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F4643 Process Picking Requests Transactional

Process Picking Requests

Business Role: Retail Store Associate

This feature enables you to enter serial number for articles that are serial number-managed during picking in Process Picking Requests application.

Fields (24)

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
ReferenceStorePickupOrderItem StoreReferenceOrderItem
ReferenceStorePickUpOrder StoreReferenceOrder
ProductName ProductName Description
RequestedQuantity RequestedQuantity Requested Quantity
ProductPickedQuantity ProductPickedQuantity Picked Item Quantity
UnitOfMeasure UnitOfMeasure Unit Protected Qty
StorePickingRequestItemStatus StorePickingRequestItemStatus Store Picking Request Item Status
RetailStoreImageType RetailStoreImageType
virtualProductImageURLproductimageurl
virtualNodeDescriptionwrf_matgrp_text2
virtualStorePkngReqItmIsDwnPaytRlvtxfeld
ProductStandardID ProductStandardID GTIN
RequestedStorePickingReqItem RequestedStorePickingReqItem Requested Item Num
StorePkngReqItemIsSubstituted StorePkngReqItemIsSubstituted Is Substituted
RetailStoreProdIsPickingCmpltd RetailStoreProdIsPickingCmpltd Picking completed flag for Store Picking Request Item
RetailStoreProdIsNonStock RetailStoreProdIsNonStock Retail Store Non Stock Product flag
StorePkngReqItemIsHigherLvl StorePkngReqItemIsHigherLvl Higher Lvl Item Flag
ProductRemainingQuantity ProductRemainingQuantity Remaining item quantity
SerialNumberProfile SerialNumberProfile SerialNoProfile
_ProductGTIN _ProductGTIN

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 C_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.

CREATE VIEW C_StorePickingRequestItem AS
SELECT
  Store,
  StorePickingRequest,
  StorePickingRequestItem,
  Product,
  StoreReferenceOrderItem AS ReferenceStorePickupOrderItem,
  StoreReferenceOrder AS ReferenceStorePickUpOrder,
  ProductName,
  RequestedQuantity,
  ProductPickedQuantity,
  UnitOfMeasure,
  StorePickingRequestItemStatus,
  RetailStoreImageType,
  virtual ProductImageURL : productimageurl AS virtualProductImageURLproductimageurl,
  virtual NodeDescription : wrf_matgrp_text2 AS virtualNodeDescriptionwrf_matgrp_text2,
  virtual StorePkngReqItmIsDwnPaytRlvt : xfeld AS virtualStorePkngReqItmIsDwnPaytRlvtxfeld,
  ProductStandardID,
  RequestedStorePickingReqItem,
  StorePkngReqItemIsSubstituted,
  RetailStoreProdIsPickingCmpltd,
  RetailStoreProdIsNonStock,
  StorePkngReqItemIsHigherLvl,
  ProductRemainingQuantity,
  SerialNumberProfile
FROM I_StorePickingRequestItemTP
LEFT OUTER JOIN I_ProductUnitOfMeasureEAN AS _ProductGTIN ON Product = _ProductGTIN.Product AND UnitOfMeasure = _ProductGTIN.AlternativeUnit  -- association [1..*]
;

Learn More