C_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 C_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: CMRPOUTBNDDEL

CREATE VIEW C_MRPOutboundDelivery AS
SELECT
  I_MRPOutboundDelivery.Delivery AS Delivery,
  I_MRPOutboundDelivery.DeliveryItem AS DeliveryItem,
  I_MRPOutboundDelivery.DeliveryType AS DeliveryType,
  I_MRPOutboundDelivery.MRPPlant AS MRPPlant,
  I_MRPOutboundDelivery.MRPPlantName AS MRPPlantName,
  I_MRPOutboundDelivery.Material AS Material,
  I_MRPOutboundDelivery.MaterialName AS MaterialName,
  I_MRPOutboundDelivery.BaseUnit AS BaseUnit,
  I_MRPOutboundDelivery.SalesUnit AS SalesUnit,
  I_MRPOutboundDelivery.DeliveredQuantityInSalesUnit AS DeliveredQuantityInSalesUnit,
  I_MRPOutboundDelivery.Customer AS Customer,
  I_MRPOutboundDelivery.CustomerName AS CustomerName,
  cast('' as ad_namtext) AS ContactPersonName,
  cast('' as ad_tlnmbr1) AS ContactPersonPhoneNumber,
  cast('' as ad_smtpadr) AS InternalContactEmailAddress,
  I_MRPOutboundDelivery.DocumentDate AS DocumentDate,
  I_MRPOutboundDelivery.ProductAvailabilityDate AS ProductAvailabilityDate,
  I_MRPOutboundDelivery.RequestedLoadingDate AS RequestedLoadingDate,
  I_MRPOutboundDelivery.RequestedDeliveryDate AS RequestedDeliveryDate,
  I_MRPOutboundDelivery.DeliveredQuantityInBaseUnit AS DeliveredQuantityInBaseUnit,
  cast(0 as mng01) AS OpenDeliveryQuantity,
  cast(0 as mng01) AS OrderQuantityInBaseUnit,
  I_MRPOutboundDelivery.ReferenceDocument AS ReferenceDocument,
  I_MRPOutboundDelivery.DeliveryPriority AS DeliveryPriority,
  I_MRPOutboundDelivery.DeliveryPriorityDesc AS DeliveryPriorityDesc,
  I_MRPOutboundDelivery.DeliveryBlockReason AS DeliveryBlockReason,
  I_MRPOutboundDelivery.DeliveryBlockReasonText AS DeliveryBlockReasonText,
  I_MRPOutboundDelivery.ReferenceDocumentItem AS ReferenceDocumentItem,
  I_MRPOutboundDelivery.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  I_MRPOutboundDelivery.ReferenceSDDocument AS ReferenceSDDocument,
  MaterialByCustomer,
  WBSElementExternalID,
  WBSElementObject,
  WBSElementDescription,
  WBSDescription,
  ProjectExternalID,
  ProjectDescription,
  ResponsiblePerson,
  ResponsiblePersonName
FROM I_MRPOutboundDelivery
LEFT OUTER JOIN C_OutboundDeliveryFs AS _OutboundDelivery ON Delivery = _OutboundDelivery.OutboundDelivery  -- association [1..1]
;