I_AllocationElement

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_AllocationElement.
-- 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: ALLOCELEMENT

CREATE VIEW I_AllocationElement AS
SELECT
  cast(tab as fco_allocation_type) AS AllocationType,
  cycle AS AllocationCycle,
  sdate AS AllocationCycleStartDate,
  seqnr AS AllocationCycleSegment,
  srflag AS AllocSenderReceiverVariant,
  fpos AS AllocElementSequenceNumber,
  element1 AS AllocationElement1,
  element2 AS AllocationElement2,
  element3 AS AllocationElement3,
  element4 AS AllocationElement4,
  element5 AS AllocationElement5,
  element6 AS AllocationElement6,
  element7 AS AllocationElement7,
  element8 AS AllocationElement8,
  element9 AS AllocationElement9,
  element10 AS AllocationElement10,
  value AS AllocationElementValue
FROM t811f
LEFT OUTER JOIN I_AllocationSegment AS _Segment ON AllocationType = _Segment.AllocationType AND AllocationCycle = _Segment.AllocationCycle AND AllocationCycleStartDate = _Segment.AllocationCycleStartDate AND AllocationCycleSegment = _Segment.AllocationCycleSegment  -- association [1]
;