P_MRHierarchicalNonAddKFVal

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_MRHierarchicalNonAddKFVal.
-- 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: PMRHIERNADDKF
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW P_MRHierarchicalNonAddKFVal AS
SELECT
  $parameters.P_KeyDate AS KeyDate,
  PortfolioHierarchyNode.RiskAnalyzerPortfolioHierarchy AS RiskAnalyzerPortfolioHierarchy,
  PortfolioHierarchyNode.ParentHierarchyNode AS ParentHierarchyNode,
  FinalResultsNonAdd.RiskAnalyzerKeyFigure AS RiskAnalyzerKeyFigure,
  _RiskAnalyzerPortfolioHier.AuthorizationGroup AS AuthorizationGroup,
  PortfolioHierarchyNode.PortfolioHierarchyNode AS PortfolioHierarchyNode,
  FinalResultsNonAdd.RiskAnalyzerKeyFigureValue AS RiskAnalyzerKeyFigureValue,
  PortfolioHierarchyNode.CharacteristicInternalID AS CharacteristicInternalID,
  PortfolioHierarchyNode.CharacteristicValue AS CharacteristicValue,
  PortfolioHierarchyNode.DataElement AS DataElement
FROM P_PortfolioHierarchyNode AS PortfolioHierarchyNode
LEFT OUTER JOIN P_MRFinalResultsNonAdditiveKF 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]
;