I_MRPOutboundDelivery

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_MRPOutboundDelivery.
-- 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: IMRPOUTBNDDEL

CREATE VIEW I_MRPOutboundDelivery AS
SELECT
  OutboundDelivery AS Delivery,
  OutboundDeliveryItem AS DeliveryItem,
  _OutboundDelivery.DeliveryDocumentType AS DeliveryType,
  _OutboundDelivery.DocumentDate AS DocumentDate,
  ReferenceSDDocument AS ReferenceDocument,
  ReferenceSDDocumentItem AS ReferenceDocumentItem,
  Plant AS MRPPlant,
  _Plant.PlantName AS MRPPlantName,
  Material,
  _Material._Text[1: Language = $session.system_language ].MaterialName AS MaterialName,
  MaterialGroup,
  StorageLocation,
  Batch,
  InventorySpecialStockType,
  ReferenceSDDocumentCategory,
  WBSElementInternalID,
  cast ( _WBSElement.WBSElement as ps_posid_edit preserving type ) AS WBSElementExternalID,
  _WBSElement.WBSElementObject AS WBSElementObject,
  _WBSElement._WBSElementLangBsdDesc[1: Language = $session.system_language ].WBSElementLangBsdDescription AS WBSElementDescription,
  _WBSElement.WBSDescription AS WBSDescription,
  cast ( _WBSElement.Project as ps_pspid_edit preserving type ) AS ProjectExternalID,
  _WBSElement._Project.ProjectDescription AS ProjectDescription,
  MaterialByCustomer,
  '' AS SalesOrder,
  0 AS SalesOrderItem,
  '' AS SalesOrderType,
  '' AS SalesOrderItemMaterial,
  _OutboundDelivery.SalesOrganization AS SalesOrganization,
  DistributionChannel,
  Division,
  _OutboundDelivery.CustomerGroup AS CustomerGroup,
  _OutboundDelivery.ShipToParty AS Customer,
  _OutboundDelivery._ShipToParty.CustomerName AS CustomerName,
  _OutboundDelivery._ShipToParty.CustomerFullName AS ContactPersonName,
  _OutboundDelivery._ShipToParty._StandardAddress.PhoneNumber AS ContactPersonPhoneNumber,
  _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,
  ReferenceSDDocument,
  _OutboundDelivery._DeliveryPriority AS _DeliveryPriority,
  _OutboundDelivery._DeliveryBlockReason AS _DeliveryBlockReason,
  _OutboundDelivery._ShipToParty AS _ShipToParty,
  _OutboundDelivery._DeliveryDocumentType AS _DeliveryDocumentType
FROM I_OutboundDeliveryItem
LEFT OUTER JOIN I_OutboundDelivery AS _OutboundDelivery ON Delivery = _OutboundDelivery.OutboundDelivery  -- association [1..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_WBSElement AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
;