C_StorePickupOrder

DDL: C_STOREPICKUPORDER Type: view_entity CONSUMPTION
20 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

Store Pickup Order

C_StorePickupOrder is a Consumption CDS View that provides data about "Store Pickup Order" in SAP S/4HANA. It reads from 1 data source (I_StorePickupOrderTP) and exposes 20 fields with key fields Store, StorePickUpOrder. 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_StorePickupOrderTP I_StorePickupOrderTP projection

Annotations (6)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Store Pickup Order 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 (20)

KeyFieldSource TableSource FieldDescription
KEY Store Store Plant
KEY StorePickUpOrder StorePickUpOrder Store Pickup Order
StoreOrderExpdHandoverDteTme StoreOrderExpdHandoverDteTme Handover Date Time
Customer Customer Sold-to Party
CustomerName CustomerName Name of Customer
TelephoneNumber1 TelephoneNumber1
StoreOrderPickingStatus StoreOrderPickingStatus Order Picking Status
StoreOrderOverallStatus StoreOrderOverallStatus Order Overall Status
StoreOrderPaymentStatus StoreOrderPaymentStatus Order Payment Status
StoreOrderPaymentStatusText StoreOrderPaymentStatusText
StoreOrderRejectionReason StoreOrderRejectionReason Order Reject. Reason
StoreOrderRejectionComment StoreOrderRejectionComment
NmbrOfFullyPickedItems NmbrOfFullyPickedItems Fully Picked Items
NmbrOfPartiallyPickedItems NmbrOfPartiallyPickedItems Part. Picked items
NmbrOfUnavailableItems NmbrOfUnavailableItems Unavailable Items
NmbrOfSubstitutedItems NmbrOfSubstitutedItems Count of Substituted Items
RetailStoreCustomerReference RetailStoreCustomerReference
RetailStoreExternalReference RetailStoreExternalReference
_Customer _Customer
_SalesOrder _SalesOrder

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_StorePickupOrder.
-- 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_StorePickupOrder AS
SELECT
  Store,
  StorePickUpOrder,
  StoreOrderExpdHandoverDteTme,
  Customer,
  CustomerName,
  TelephoneNumber1,
  StoreOrderPickingStatus,
  StoreOrderOverallStatus,
  StoreOrderPaymentStatus,
  StoreOrderPaymentStatusText,
  StoreOrderRejectionReason,
  StoreOrderRejectionComment,
  NmbrOfFullyPickedItems,
  NmbrOfPartiallyPickedItems,
  NmbrOfUnavailableItems,
  NmbrOfSubstitutedItems,
  RetailStoreCustomerReference,
  RetailStoreExternalReference
FROM I_StorePickupOrderTP
;

Learn More