I_OutboundDeliveryQuickView

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_OutboundDeliveryQuickView.
-- 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: IOUTBDQV

CREATE VIEW I_OutboundDeliveryQuickView AS
SELECT
  Item.OutboundDelivery AS Delivery,
  Item.OutboundDeliveryItem AS DeliveryItem,
  _OutboundDelivery.DeliveryDocumentType AS DeliveryType,
  _OutboundDelivery.DocumentDate AS DocumentDate,
  ReferenceSDDocument AS ReferenceDocument,
  ReferenceSDDocumentItem AS ReferenceDocumentItem,
  _ReferenceSDDocument.SalesDocumentType AS SalesDocumentType,
  Material,
  Plant AS MRPPlant,
  _Plant.PlantName AS MRPPlantName,
  MaterialGroup,
  StorageLocation,
  Batch,
  InventorySpecialStockType,
  _Customer1.MaterialByCustomer AS MaterialByCustomer,
  _Customer1.BaseUnit AS CustomerMaterialBaseUnit,
  _Customer1.MinDeliveryQtyInBaseUnit AS MinDeliveryQtyInBaseUnit,
  _OutboundDelivery.SalesOrganization AS SalesOrganization,
  DistributionChannel,
  Division,
  _OutboundDelivery.CustomerGroup AS CustomerGroup,
  _OutboundDelivery.ShipToParty AS Customer,
  _OutboundDelivery._ShipToParty.BPCustomerName AS BPCustomerName,
  concat_with_space(_CP._ContactPerson.FirstName, _CP._ContactPerson.LastName,1) AS ContactPersonName,
  case when _CP._Address._DefaultPhoneNumber.PhoneNumber <> '' then concat_with_space(_CP._Address._DefaultPhoneNumber.PhoneNumber,_CP._Address._DefaultPhoneNumber.PhoneNumberExtension,1) else _OutboundDelivery._ShipToParty._StandardAddress.PhoneNumber end as ContactPersonPhoneNumber AS PhoneNumberendasContactPersonPhoneNumber,
  _OutboundDelivery.DeliveryBlockReason AS DeliveryBlockReason,
  _OutboundDelivery._DeliveryBlockReason._Text[1: Language = $session.system_language ].DeliveryBlockReasonText AS DeliveryBlockReasonText,
  _OutboundDelivery.DeliveryPriority AS DeliveryPriority,
  _OutboundDelivery._DeliveryPriority._Text[1: Language = $session.system_language ].DeliveryPriorityDesc AS DeliveryPriorityDesc,
  _OutboundDelivery.CompleteDeliveryIsDefined AS CompleteDeliveryIsDefined,
  _OutboundDelivery.DeliveryDate AS RequestedDeliveryDate,
  _OutboundDelivery.LoadingDate AS RequestedLoadingDate,
  _OutboundDelivery.PlannedGoodsIssueDate AS RequestedGoodsIssueDate,
  ProductAvailabilityDate,
  BaseUnit,
  ActualDeliveredQtyInBaseUnit AS DeliveredQuantityInBaseUnit,
  DeliveryQuantityUnit AS SalesUnit,
  ActualDeliveryQuantity AS DeliveredQuantityInSalesUnit
FROM I_OutboundDeliveryItem AS Item
INNER JOIN I_OutboundDelivery AS _OutboundDelivery ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CustomerMaterial_2 AS _Customer1 ON SalesOrganization = _Customer1.SalesOrganization AND DistributionChannel = _Customer1.DistributionChannel AND Customer = _Customer1.Customer AND Material = _Customer1.Product  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _SalesUnit ON SalesUnit = _SalesUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCompletePartners AS _CP ON Delivery = _CP.SDDocument AND _CP.PartnerFunction = 'AP'  -- association [0..1]
;