I_UnivAllocCycleCalculation

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_UnivAllocCycleCalculation.
-- 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.

CREATE VIEW I_UnivAllocCycleCalculation AS
SELECT
  AllocationType,
  AllocationCycle,
  AllocationCycleStartDate,
  _TDDTemplate.TopDwnDistrTmplName AS TopDwnDistrTmplName,
  _TDDTemplate.UnivAllocTopDwnDistrCycleHash AS UnivAllocTopDwnDistrCycleHash,
  _TDDTemplate.TopDwnDistrTmplHash AS TopDwnDistrTmplHash,
  _TDDTemplate.OperatingConcern AS OperatingConcern,
  cast( $session.system_language as spras) AS LanguageCode
FROM I_UniversalAllocationCycle
LEFT OUTER JOIN P_UnivAllocCycleLockCounter AS _CycleLockCounter ON _CycleLockCounter.AllocationCycle = AllocationCycle AND _CycleLockCounter.AllocationType = AllocationType AND _CycleLockCounter.AllocationCycleStartDate = AllocationCycleStartDate  -- association [1..*]
LEFT OUTER JOIN P_UnivAllocTopDwnDistrTmplCalc AS _TDDTemplate ON _TDDTemplate.AllocationCycle = AllocationCycle AND _TDDTemplate.AllocationType = AllocationType AND _TDDTemplate.AllocationCycleStartDate = AllocationCycleStartDate  -- association [0..1]
;