I_AllocationKeyField

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_AllocationKeyField.
-- 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: ALLOCKEYFIELD

CREATE VIEW I_AllocationKeyField AS
SELECT
  cast(tab as fco_allocation_type) AS AllocationType,
  cycle AS AllocationCycle,
  cast( sdate as fco_alloc_valid_from ) AS AllocationCycleStartDate,
  seqnr AS AllocationCycleSegment,
  setkind AS AllocationSetType,
  pos AS AllocDocumentSequenceNumber,
  field AS AllocationFieldName,
  setname AS AllocationSetName,
  valmin AS AllocationFieldMinimumValue,
  valmax AS AllocationFieldMaximumValue,
  setid AS AllocationSetId,
  cast( case when valmin = '#' then 'X' else '' end as boolean ) AS AllocKeyFieldIsInitial,
  cast( case when valmin = '*' then 'X' else '' end as boolean ) AS AllocKeyFieldIsAllValues
FROM t811k
LEFT OUTER JOIN I_AllocationCycle AS _Cycle ON AllocationType = _Cycle.AllocationType AND AllocationCycle = _Cycle.AllocationCycle AND AllocationCycleStartDate = _Cycle.AllocationCycleStartDate  -- association [1]
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]
;