C_StorePickupOrderPickedItem

DDL: C_STOREPICKUPORDERPICKEDITEM Type: view_entity CONSUMPTION
10 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

Store Pickup Order Items

C_StorePickupOrderPickedItem is a Consumption CDS View that provides data about "Store Pickup Order Items" in SAP S/4HANA. It reads from 1 data source (I_StorePickupOrderPickedItemTP) and exposes 10 fields with key fields Store, StorePickUpOrder, Product, ProductStandardID, UnitOfMeasure. It is exposed through 1 OData service (UI_RFM_STORE_HANDOVERORDER). It is used in 1 Fiori application: Hand Over Orders.

Data Sources (1)

SourceAliasJoin Type
I_StorePickupOrderPickedItemTP I_StorePickupOrderPickedItemTP projection

Annotations (6)

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

OData Services (1)

ServiceBindingVersionContractRelease
UI_RFM_STORE_HANDOVERORDER UI_RFM_STORE_HANDOVERORDER V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F4639 Hand Over Orders Transactional

Hand Over Orders

Business Role: Retail Store Associate

This feature allows you to hand over click-and-reserve orders without cancellation of sales order. Instead, a billing document is created in the system for further processing.

Fields (10)

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
RetailStoreImageType RetailStoreImageType
virtualProductImageURLproductimageurl
ProductName ProductName Description

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_StorePickupOrderPickedItem.
-- 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_StorePickupOrderPickedItem AS
SELECT
  Store,
  StorePickUpOrder,
  Product,
  ProductStandardID,
  UnitOfMeasure,
  RequestedQuantity,
  ProductPickedQuantity,
  RetailStoreImageType,
  virtual ProductImageURL : productimageurl AS virtualProductImageURLproductimageurl,
  ProductName
FROM I_StorePickupOrderPickedItemTP
;

Learn More