I_StatKeyFigCostAllocCyc

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_StatKeyFigCostAllocCyc.
-- 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: IWUSKFCAC

CREATE VIEW I_StatKeyFigCostAllocCyc AS
SELECT
  cast (AllocationFieldMinimumValue as fis_stagr) AS StatisticalKeyFigure,
  _Cycle.AllocationCycle AS AllocationCycle,
  ControllingArea,
  _Cycle._Text[1: LanguageCode = $session.system_language ].AllocationCycleNameText AS AllocationCycleNameText,
  _Cycle.AllocationCycleStartDate AS AllocationCycleStartDate,
  _Cycle.AllocationCycleEndDate AS AllocationCycleEndDate,
  _Cycle.LastChangeDate AS LastChangeDate,
  _Cycle.LastChangedByUser AS LastChangedByUser,
  _Cycle.AllocationLastExecutedDate AS AllocationLastExecutedDate,
  _Cycle.AllocationLastExecutedByUser AS AllocationLastExecutedByUser,
  _Cycle.AllocationType AS AllocationType,
  _Cycle.AllocationStatus AS AllocationStatus,
  _Cycle.AllocationActualPlanVariant AS AllocationActualPlanVariant,
  _Cycle._ActualPlanText[1: Language = $session.system_language ].AllocActualPlanVariantText AS AllocActualPlanVariantText,
  _Cycle.AllocationPostingType AS AllocationPostingType,
  case left(_Cycle.AllocationType, 5) when 'ACDOC' then _Cycle.Ledger else '' end as Ledger AS LedgerelseendasLedger
INNER JOIN I_StatisticalKeyFigure ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_StatisticalKeyFigure AS _StatisticalKeyFigure ON StatisticalKeyFigure = _StatisticalKeyFigure.StatisticalKeyFigure AND ControllingArea = _StatisticalKeyFigure.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_AllocationKeyField AS _PlanningCategory ON _PlanningCategory.AllocationType = allocationtype AND _PlanningCategory.AllocationCycle = allocationcycle AND _PlanningCategory.AllocationCycleStartDate = allocationcyclestartdate AND _PlanningCategory.AllocationCycleSegment = '0000' AND _PlanningCategory.AllocationSetType = '0' AND _PlanningCategory.AllocationFieldName = 'CATEGORY'  -- association [0..1]
LEFT OUTER JOIN I_StatKeyFigWhereUsedAllocType AS _AllocationPostingType ON _AllocationPostingType.AllocationPostingType = allocationpostingtype AND _AllocationPostingType.AllocationPostingTypeContext = AllocationPostingTypeContext  -- association [0..1]
LEFT OUTER JOIN I_AllocationContextTypeText AS _AllocationContextTypeText ON _AllocationContextTypeText.AllocationType = allocationtype AND _AllocationContextTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AllocationStateText AS _AllocationStatusText ON _AllocationStatusText.AllocationStatus = allocationstatus  -- association [0..1]
;