I_AllocTableDistrCtrDelivPhase

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_AllocTableDistrCtrDelivPhase.
-- 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: IALLOCTBLDCDLVPH

CREATE VIEW I_AllocTableDistrCtrDelivPhase AS
SELECT
  abeln AS AllocationTable,
  abelp AS AllocationTableItem,
  vzwrk AS DistributionCenter,
  lfnum AS AllocationTableDeliveryPhase,
  cast(wevdt as deliverydate preserving type) AS DeliveryDate,
  cast(eblnu as vdm_purchaseorder preserving type) AS PurchaseOrder,
  cast(eblpu as vdm_purchaseorderitem preserving type ) AS PurchaseOrderItem
FROM auvw
LEFT OUTER JOIN I_AllocationTable AS _AllocationTable ON AllocationTable = _AllocationTable.AllocationTable  -- association [1..1]
LEFT OUTER JOIN I_AllocationTableItem AS _AllocationTableItem ON AllocationTable = _AllocationTableItem.AllocationTable AND AllocationTableItem = _AllocationTableItem.AllocationTableItem  -- association [1..1]
LEFT OUTER JOIN I_Site AS _DistributionCenter ON DistributionCenter = _DistributionCenter.Site  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrder AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [0..1]
;