I_EWM_DeliveryBPLocation

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_EWM_DeliveryBPLocation.
-- 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: IEWMBPLOC

CREATE VIEW I_EWM_DeliveryBPLocation AS
SELECT
  EWMWarehouseRequestUUID AS OutboundDeliveryOrderUUID,
  EWMWarehouseRequestItemUUID AS OutboundDeliveryOrderItemUUID,
  BusinessPartnerRole,
  BusinessPartnerUUID,
  EWMWhseRequestDocumentCategory AS DeliveryCategory,
  EWMWhseRequestDocumentCategory AS EWMDeliveryDocumentCategory,
  WarehouseLocation,
  EWMWarehouseRequestOrgUnit AS OrganizationalUnit,
  EWMWarehouseRequestAddress AS AddressNumber,
  _BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  cast( BusinessPartnerNumber as bu_partner ) AS BusinessPartner,
  cast( _BusinessPartner.BusinessPartnerName as abap.char( 40 ) ) AS BusinessPartnerName,
  _BusAddress2.OrganizationName1 AS OrganizationName1,
  _BusAddress2.OrganizationName2 AS OrganizationName2,
  _LocationDetails.LocationUUID AS LocationUUID,
  _LocationDetails._Text AS _Text
FROM I_EWM_WhseReqBPLocation AS _businessPartnerLocation
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON _businessPartnerLocation.BusinessPartnerNumber = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN P_EWM_Address AS _BusAddress2 ON AddressNumber = _BusAddress2.AddressID AND _BusAddress2.AddressPersonID is initial  -- association [0..1]
LEFT OUTER JOIN I_LocationBasic AS _LocationDetails ON WarehouseLocation = _LocationDetails.Location  -- association [0..1]
;