C_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 C_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: CWUSKFCAC

CREATE VIEW C_StatKeyFigCostAllocCyc AS
SELECT
  cast ('3CAC' as statkeyfigwhereusedobjtypevh) AS StatKeyFigWhereUsedObjType,
  StatisticalKeyFigure,
  AllocationCycle,
  AllocationCycleName,
  AllocationCycleNameText,
  AllocationPostingType,
  cast (_PlanningCategory.AllocationFieldMinimumValue as fcom_category) AS PlanningCategory,
  Ledger,
  _LedgerText.LedgerName AS LedgerName,
  cast (AllocationCycleStartDate as fco_alloc_valid_from preserving type) AS AllocationCycleStartDate,
  cast (AllocationCycleEndDate as fco_alloc_valid_to preserving type) AS AllocationCycleEndDate,
  cast (LastChangeDate as changedon preserving type) AS LastChangeDate,
  LastChangedByUser,
  cast (AllocationLastExecutedDate as executedon preserving type) AS AllocationLastExecutedDate,
  AllocationLastExecutedByUser,
  AllocationActualPlanVariant,
  cast (AllocationType as fco_allocation_context preserving type) AS AllocationType,
  cast (AllocationStatus as fco_allocation_status preserving type) AS AllocationStatus,
  _StatisticalKeyFigure.ControllingArea AS ControllingArea,
  _StatisticalKeyFigure._ControllingArea.ControllingAreaName AS ControllingAreaName,
  _StatisticalKeyFigure._Text[1: Language = $session.system_language ].StatisticalKeyFigureName AS StatisticalKeyFigureName,
  AllocActualPlanVariantText,
  cast(_AllocationPostingType.AllocationPostingTypeText as fcu_wucc_alart_text) AS AllocationPostingTypeText,
  _AllocationContextTypeText.AllocationContextTypeText AS AllocationContextTypeText,
  cast(_AllocationStatusText.AllocationStatusText as fco_wucc_cac_status_txt) AS AllocationStatusText,
  AllocationCycleStartDate AS ValidityStartDate,
  AllocationCycleEndDate AS ValidityEndDate
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastExecutedByUser ON AllocationLastExecutedDate = _LastExecutedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger AND _LedgerText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PlanningCategoryText AS _PlanningCategoryText ON PlanningCategory = _PlanningCategoryText.PlanningCategory AND _PlanningCategoryText.Language = $session.system_language  -- association [0..1]
;