I_AllocationTableItemRecipient

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_AllocationTableItemRecipient.
-- 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: IALLOCTBLITRCPNT

CREATE VIEW I_AllocationTableItemRecipient AS
SELECT
  abeln AS AllocationTable,
  abelp AS AllocationTableItem,
  abelg AS AllocationTableItemRcpntGrp,
  abelf AS AllocationTableItemRecipient,
  fiwrk AS Site,
  filnr AS Customer,
  vzwrk AS DistributionCenter,
  cast(lfnru as md_supplier preserving type) AS Supplier,
  cast(vblnu as outbound_delivery preserving type) AS OutboundDelivery,
  cast(vblpu as outbound_delivery_item preserving type) AS OutboundDeliveryItem,
  cast(eblnu as vdm_purchaseorder preserving type) AS PurchaseOrder,
  cast(eblpu as vdm_purchaseorderitem preserving type ) AS PurchaseOrderItem,
  cast(ubstn as vdm_stocktransportorder preserving type ) AS StockTransportOrder,
  cast(ubstp as vdm_stocktransportorderitem preserving type ) AS StockTransportOrderItem,
  pmngu AS PlannedQuantity,
  imngu AS ConfirmedQuantity,
  aufme AS QuantityUnit
FROM aufi
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_AllocationTableItemRcpntGrp AS _AllocationTableItemRcpntGrp ON AllocationTable = _AllocationTableItemRcpntGrp.AllocationTable AND AllocationTableItem = _AllocationTableItemRcpntGrp.AllocationTableItem AND AllocationTableItemRcpntGrp = _AllocationTableItemRcpntGrp.AllocationTableItemRcpntGrp  -- association [1..1]
LEFT OUTER JOIN I_AllocationTableItemRcpntSts AS _AllocationTableItemRcpntSts ON AllocationTable = _AllocationTableItemRcpntSts.AllocationTable AND AllocationTableItem = _AllocationTableItemRcpntSts.AllocationTableItem AND AllocationTableItemRcpntGrp = _AllocationTableItemRcpntSts.AllocationTableItemRcpntGrp AND AllocationTableItemRecipient = _AllocationTableItemRcpntSts.AllocationTableItemRecipient  -- association [0..1]
LEFT OUTER JOIN I_AllocationTableDeliveryPhase AS _AllocationTableDeliveryPhase ON AllocationTable = _AllocationTableDeliveryPhase.AllocationTable AND AllocationTableItem = _AllocationTableDeliveryPhase.AllocationTableItem AND AllocationTableItemRcpntGrp = _AllocationTableDeliveryPhase.AllocationTableItemRcpntGrp AND AllocationTableItemRecipient = _AllocationTableDeliveryPhase.AllocationTableItemRecipient  -- association [0..*]
LEFT OUTER JOIN I_Site AS _Site ON Site = _Site.Site  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Site AS _DistributionCenter ON DistributionCenter = _DistributionCenter.Site  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_OutboundDelivery AS _OutboundDelivery ON OutboundDelivery = _OutboundDelivery.OutboundDelivery  -- association [0..1]
LEFT OUTER JOIN I_OutboundDeliveryItem AS _OutboundDeliveryItem ON OutboundDelivery = _OutboundDeliveryItem.OutboundDelivery AND OutboundDeliveryItem = _OutboundDeliveryItem.OutboundDeliveryItem  -- association [0..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]
LEFT OUTER JOIN I_StockTransportOrder AS _StockTransportOrder ON StockTransportOrder = _StockTransportOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_StockTransportOrderItem AS _StockTransportOrderItem ON StockTransportOrder = _StockTransportOrderItem.PurchaseOrder AND StockTransportOrderItem = _StockTransportOrderItem.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _QuantityUnit ON QuantityUnit = _QuantityUnit.UnitOfMeasure  -- association [0..1]
;