P_AllocRunReceiverSenderResult

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 P_AllocRunReceiverSenderResult.
-- 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: PALLOCRECSEN

CREATE VIEW P_AllocRunReceiverSenderResult AS
SELECT
  UniversalAllocationRun,
  AllocationCycle,
  AllocationCycleStartDate,
  AllocationCycleSegment,
  AllocationRunSenderItem,
  AllocationRunReceiverItem,
  _TargetResult.AllocationRunDataCategory AS AllocationRunDataCategory
LEFT OUTER JOIN C_AllocationRunResult AS _SourceResult ON _SourceResult.UniversalAllocationRun = UniversalAllocationRun AND _SourceResult.AllocationCycle = AllocationCycle AND _SourceResult.AllocationCycleStartDate = AllocationCycleStartDate AND _SourceResult.AllocationCycleSegment = AllocationCycleSegment AND _SourceResult.AllocationRunDataCategory = 'R' AND _SourceResult.AllocationRunResultItem = AllocationRunReceiverItem  -- association [0..1]
LEFT OUTER JOIN C_AllocationRunResult AS _TargetResult ON _TargetResult.UniversalAllocationRun = UniversalAllocationRun AND _TargetResult.AllocationCycle = AllocationCycle AND _TargetResult.AllocationCycleStartDate = AllocationCycleStartDate AND _TargetResult.AllocationCycleSegment = AllocationCycleSegment AND _TargetResult.AllocationRunDataCategory = 'S' AND _TargetResult.AllocationRunResultItem = AllocationRunSenderItem  -- association [0..1]
;