I_AllocTopDwnDistrRefFld

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_AllocTopDwnDistrRefFld.
-- 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: ALOTDDREFFLD

CREATE VIEW I_AllocTopDwnDistrRefFld AS
SELECT
  tab AS AllocationType,
  cycle AS AllocationCycle,
  sdate AS AllocationCycleStartDate,
  seqnr AS AllocationCycleSegment,
  setkind AS AllocationSetType,
  pos AS AllocDocumentSequenceNumber,
  field AS AllocationFieldName,
  field_pos AS AllocRefDocumentSequenceNumber,
  ref_setname AS AllocationSetName,
  ref_valmin AS AllocReferenceFromValue,
  ref_valmax AS AllocReferenceToValue,
  sender AS AllocReferenceSourceFromValue,
  sender_to AS AllocReferenceSourceToValue,
  setid AS AllocationSetId,
  cast( case when ref_valmin = '#' then 'X' else '' end as boolean ) AS AllocRefKeyFieldIsInitial,
  cast( case when ref_valmin = '*' then 'X' else '' end as boolean ) AS AllocRefKeyFieldIsAllValues,
  cast( case when sender = '#' then 'X' else '' end as boolean ) AS AllocSourceKeyFieldIsInitial,
  cast( case when sender = '*' then 'X' else '' end as boolean ) AS AllocSourceKeyFieldIsAllValues
FROM t811km
;