P_MRHierarchicalAdditiveKFVal

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 P_MRHierarchicalAdditiveKFVal.
-- 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: PMRHIERADDKF
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW P_MRHierarchicalAdditiveKFVal AS
SELECT
  $parameters.P_KeyDate AS KeyDate,
  PortfolioHierarchyNode.RiskAnalyzerPortfolioHierarchy AS RiskAnalyzerPortfolioHierarchy,
  PortfolioHierarchyNode.PortfolioHierarchyNode AS PortfolioHierarchyNode,
  AdditiveFinalResult.RiskAnalyzerKeyFigure AS RiskAnalyzerKeyFigure,
  _RiskAnalyzerPortfolioHier.AuthorizationGroup AS AuthorizationGroup,
  PortfolioHierarchyNode.NodeType AS NodeType,
  PortfolioHierarchyNode.ParentHierarchyNode AS ParentHierarchyNode,
  PortfolioHierarchyNode.CharacteristicInternalID AS CharacteristicInternalID,
  PortfolioHierarchyNode.CharacteristicValue AS CharacteristicValue,
  case when AdditiveFinalResult.PortfolioHierarchyNode = PortfolioHierarchyNode.PortfolioHierarchyNode then sum(AdditiveFinalResult.RiskAnalyzerKeyFigureValue) else 0.0 end as RiskAnalyzerKeyFigureValue AS 0endasRiskAnalyzerKeyFigureValue,
  PortfolioHierarchyNode.DataElement AS DataElement
FROM P_PortfolioHierarchyNode AS PortfolioHierarchyNode
INNER JOIN P_MRFinalResultsAdditiveKF ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RiskAnalyzerKeyFigure AS _RiskAnalyzerKeyFigure ON _RiskAnalyzerKeyFigure.RiskAnalyzerKeyFigure = RiskAnalyzerKeyFigure  -- association [1..1]
LEFT OUTER JOIN I_RiskAnalyzerPortfolioHier AS _RiskAnalyzerPortfolioHier ON _RiskAnalyzerPortfolioHier.RiskAnalyzerPortfolioHierarchy = RiskAnalyzerPortfolioHierarchy  -- association [1..1]
LEFT OUTER JOIN P_HierclRiskAnalyzerKFFilter AS _Filter ON _Filter.RiskAnalyzerPortfolioHierarchy = RiskAnalyzerPortfolioHierarchy AND _Filter.RiskAnalyzerKeyFigure = RiskAnalyzerKeyFigure AND _Filter.EffectiveValidityStartDate <= KeyDate AND _Filter.EffectiveValidityEndDate > KeyDate  -- association [1..1]
;