I_StorePickupOrderTP

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_StorePickupOrderTP.
-- 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: ISTPICKUPORDTP

CREATE VIEW I_StorePickupOrderTP AS
SELECT
  Store,
  StorePickUpOrder,
  StoreOrderExpdHandoverDteTme,
  Customer,
  _Customer._Address.PhoneNumber AS TelephoneNumber1,
  _Customer._Address.FullName AS CustomerName,
  StoreOrderPaymentStatus,
  _PaymentStatusText.StoreOrderPaymentStatusText AS StoreOrderPaymentStatusText,
  StoreOrderOverallStatus,
  StoreOrderRejectionReason,
  cast(' ' as char256) AS StoreOrderRejectionComment,
  NmbrOfFullyPickedItems,
  NmbrOfPartiallyPickedItems,
  NmbrOfUnavailableItems,
  NmbrOfSubstitutedItems,
  StorePickUpOrderIsSubstnEnbld,
  _RetailStoreUserAssignment.AssignedUser AS AssignedUser,
  _RetailStoreOrderBusinessData.RetailStoreCustomerReference AS RetailStoreCustomerReference,
  _RetailStoreOrderBusinessData.RetailStoreExternalReference AS RetailStoreExternalReference
FROM I_StorePickupOrdWthConfign
LEFT OUTER JOIN I_SDDocumentCompletePartners AS _Customer ON StorePickUpOrder = _Customer.SDDocument AND Customer = _Customer.Customer AND _Customer.PartnerFunction = 'AG'  -- association [0..1]
LEFT OUTER JOIN I_StoreOrderPickingStatusText AS _PickingStatusText ON StoreOrderPickingStatus = _PickingStatusText.StoreOrderPickingStatus AND _PickingStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_StoreOrderPaymentStatusText AS _PaymentStatusText ON StoreOrderPaymentStatus = _PaymentStatusText.StoreOrderPaymentStatus AND _PaymentStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RetailStoreUserAssignment AS _RetailStoreUserAssignment ON _RetailStoreUserAssignment.Store = Store AND _RetailStoreUserAssignment.AssignedUser = $session.user  -- association [0..1]
LEFT OUTER JOIN I_RetailStoreOrderBusinessData AS _RetailStoreOrderBusinessData ON _RetailStoreOrderBusinessData.ReferenceStorePickUpOrder = StorePickUpOrder AND _RetailStoreOrderBusinessData.ReferenceStorePickupOrderItem = '000000'  -- association [0..1]
LEFT OUTER JOIN I_StorePickupOrderPickReqTP AS _StorePickupOrdPickingReq ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_StorePickupOrderPickedItemTP AS _StorePickupOrdPickedItem ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_StorePickupOrdExcptnItemTP AS _StorePickupOrdExcptnItem ON /* condition not available in parsed metadata */  -- association [0..*]
;