I_AllocRunReferenceMapping

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_AllocRunReferenceMapping.
-- 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: IALLOCNREFMAP

CREATE VIEW I_AllocRunReferenceMapping AS
SELECT
  run_id AS UniversalAllocationRun,
  cycle AS AllocationCycle,
  sdate AS AllocationCycleStartDate,
  segment AS AllocationCycleSegment,
  receiver_pos AS AllocationRunReceiverItem,
  reference_pos AS AllocationRunReferenceItem,
  cast(substring(cycle, 3, 8) as fco_alloc_cycle) AS AllocationCycleName,
  _AllocationRun.AllocationType AS AllocationType,
  _AllocationRun.Ledger AS Ledger,
  _AllocationRun.AllocationActualPlanVariant AS AllocationActualPlanVariant,
  _AllocationRun.AllocationPostingType AS AllocationPostingType
FROM alloc_run_refmap
LEFT OUTER JOIN I_AllocationRun AS _AllocationRun ON UniversalAllocationRun = _AllocationRun.UniversalAllocationRun  -- association [1]
;