I_AllocTableItemSuplgDistrCtr

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_AllocTableItemSuplgDistrCtr.
-- 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: IALLOCTBLITMSUDC

CREATE VIEW I_AllocTableItemSuplgDistrCtr AS
SELECT
  abeln AS AllocationTable,
  abelp AS AllocationTableItem,
  vzwrk AS DistributionCenter,
  lifnr AS Supplier,
  pmngv AS PlannedQuantity,
  imngv AS ConfirmedQuantity,
  aufme AS QuantityUnit,
  waflu_vz AS DistributionProcessingMethod
FROM auvz
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_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _QuantityUnit ON QuantityUnit = _QuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_AllocTableItemProcgMethod AS _ProcessingMethod ON DistributionProcessingMethod = _ProcessingMethod.DistributionProcessingMethod  -- association [0..1]
;