I_AllocationTableItem

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_AllocationTableItem.
-- 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: IALLOCTBLITEM

CREATE VIEW I_AllocationTableItem AS
SELECT
  abeln AS AllocationTable,
  abelp AS AllocationTableItem,
  rfktn AS PurchaseContract,
  rfktp AS PurchaseContractItem,
  cast(ebeln as vdm_purchaseorder preserving type) AS PurchaseOrder,
  aktnr AS RetailPromotion,
  cast(matnr as productnumber preserving type) AS Product,
  vzwrk AS DistributionCenter,
  lifnr AS Supplier,
  pmnge AS PlannedQuantity,
  imnge AS ConfirmedQuantity,
  aufme AS QuantityUnit,
  astra AS AllocationStrategy,
  matkl AS MaterialGroup,
  vbeln AS InboundDelivery,
  vbelp AS InboundDeliveryItem,
  ervon AS AllocTableCreatingApplication,
  sapos AS AllocTblItemOfConfigblProduct,
  attyp AS ArticleCategory,
  sperr AS AllocTblItmBlockReason,
  erdat AS CreationDate,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aenam AS LastChangedByUser
FROM aupo
LEFT OUTER JOIN I_AllocationTable AS _AllocationTable ON AllocationTable = _AllocationTable.AllocationTable  -- association [1..1]
LEFT OUTER JOIN I_AllocationTableItemRcpntGrp AS _AllocationTableItemRcpntGrp ON AllocationTable = _AllocationTableItemRcpntGrp.AllocationTable AND AllocationTableItem = _AllocationTableItemRcpntGrp.AllocationTableItem  -- association [0..*]
LEFT OUTER JOIN I_AllocationTableItemRecipient AS _AllocationTableItemRecipient ON AllocationTable = _AllocationTableItemRecipient.AllocationTable AND AllocationTableItem = _AllocationTableItemRecipient.AllocationTableItem  -- association [0..*]
LEFT OUTER JOIN I_AllocTableItemSuplgDistrCtr AS _AllocTableItemSuplgDistrCtr ON AllocationTable = _AllocTableItemSuplgDistrCtr.AllocationTable AND AllocationTableItem = _AllocTableItemSuplgDistrCtr.AllocationTableItem  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _QuantityUnit ON QuantityUnit = _QuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_RetailPromotion AS _RetailPromotion ON RetailPromotion = _RetailPromotion.RetailPromotion  -- association [0..1]
LEFT OUTER JOIN I_AllocTableBlockingReason AS _AllocTableBlockingReason ON AllocTblItmBlockReason = _AllocTableBlockingReason.AllocTblBlockReason  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
;