C_StatKeyFigCostAllocSgmt

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_StatKeyFigCostAllocSgmt.
-- 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: CWUSKFCAS

CREATE VIEW C_StatKeyFigCostAllocSgmt AS
SELECT
  cast ('4CAS' as statkeyfigwhereusedobjtypevh) AS StatKeyFigWhereUsedObjType,
  StatisticalKeyFigure,
  AllocationCycle,
  AllocationCycleSegment,
  AllocationCycleName,
  SegmentName,
  AllocationPostingType,
  AllocationSegmentIsLocked,
  AllocationCycleNameText,
  cast (AllocationType as fco_allocation_context preserving type) AS AllocationType,
  cast (AssessmentCostElement as fco_assessment_cost_element preserving type) AS AssessmentCostElement,
  AllocationReceiverRule,
  cast (AllocationCycleStartDate as fco_alloc_valid_from preserving type) AS AllocationCycleStartDate,
  cast (AllocationCycleEndDate as fco_alloc_valid_to preserving type) AS AllocationCycleEndDate,
  _StatisticalKeyFigure.ControllingArea AS ControllingArea,
  _StatisticalKeyFigure._ControllingArea.ControllingAreaName AS ControllingAreaName,
  _StatisticalKeyFigure._Text[1: Language = $session.system_language ].StatisticalKeyFigureName AS StatisticalKeyFigureName,
  _AllocationPostingType.AllocationPostingTypeText AS AllocationPostingTypeText,
  _AllocationContextTypeText.AllocationContextTypeText AS AllocationContextTypeText,
  _AllocationReceiverRuleText.AllocationReceiverRuleText AS AllocationReceiverRuleText,
  AllocationCycleStartDate AS ValidityStartDate,
  AllocationCycleEndDate AS ValidityEndDate
;