A_StorePickupOrder

DDL: A_STOREPICKUPORDER Type: view_entity CONSUMPTION
15 Fields 1 Data Sources 1 OData Services

Store Pickup Orders

A_StorePickupOrder is a Consumption CDS View that provides data about "Store Pickup Orders" in SAP S/4HANA. It reads from 1 data source (I_StorePickupOrderTP) and exposes 15 fields with key fields Store, StorePickUpOrder. It is exposed through 1 OData service (API_STOREPICKUPORDER).

Data Sources (1)

SourceAliasJoin Type
I_StorePickupOrderTP I_StorePickupOrderTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Store Pickup Orders view
OData.entitySet.name StorePickupOrder view
OData.entityType.name StorePickupOrder_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_STOREPICKUPORDER API_STOREPICKUPORDER V4 C2 C1

Fields (15)

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
StoreOrderPickingStatusText _PickingStatusText StoreOrderPickingStatusText
StoreOrderPaymentStatus StoreOrderPaymentStatus Order Payment Status
StoreOrderPaymentStatusText StoreOrderPaymentStatusText
NmbrOfFullyPickedItems NmbrOfFullyPickedItems Fully Picked Items
NmbrOfPartiallyPickedItems NmbrOfPartiallyPickedItems Part. Picked items
NmbrOfUnavailableItems NmbrOfUnavailableItems Unavailable Items
NmbrOfSubstitutedItems NmbrOfSubstitutedItems Count of Substituted Items
_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 A_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 A_StorePickupOrder AS
SELECT
  Store,
  StorePickUpOrder,
  StoreOrderExpdHandoverDteTme,
  Customer,
  CustomerName,
  TelephoneNumber1,
  StoreOrderPickingStatus,
  _PickingStatusText.StoreOrderPickingStatusText AS StoreOrderPickingStatusText,
  StoreOrderPaymentStatus,
  StoreOrderPaymentStatusText,
  NmbrOfFullyPickedItems,
  NmbrOfPartiallyPickedItems,
  NmbrOfUnavailableItems,
  NmbrOfSubstitutedItems
FROM I_StorePickupOrderTP
;

Learn More