P_HierclModifiedDurationVal

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_HierclModifiedDurationVal.
-- 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: PHIERMODDURNVAL
-- Parameters: P_KeyDate : vdm_v_key_date, P_FreeAttributeLi02 : ftr_mrkf_modified_durn_sel

CREATE VIEW P_HierclModifiedDurationVal AS
SELECT
  HierarchicalRiskAnalysiskf.RiskAnalyzerPortfolioHierarchy AS RiskAnalyzerPortfolioHierarchy,
  HierarchicalRiskAnalysiskf.ParentHierarchyNode AS ParentHierarchyNode,
  HierarchicalRiskAnalysiskf.PortfolioHierarchyNode AS PortfolioHierarchyNode,
  HierarchicalRiskAnalysiskf.RiskAnalyzerKeyFigure AS RiskAnalyzerKeyFigure,
  HierarchicalRiskAnalysiskf.KeyDate AS KeyDate,
  ParentHierarchyNode.CharacteristicInternalID AS Level1Characteristic,
  ParentHierarchyNode.CharacteristicValue AS Level1HierarchyNodeValue,
  cast('' as scrtext_l) AS Level1HierarchyNodeName,
  cast('' as scrtext_l) AS Level1HierarchyNodeLabel,
  ParentHierarchyNode.DataElement AS Level1DataElement,
  HierarchicalRiskAnalysiskf.CharacteristicInternalID AS Level2Characteristic,
  HierarchicalRiskAnalysiskf.CharacteristicValue AS Level2HierarchyNodeValue,
  cast('' as scrtext_l) AS Level2HierarchyNodeName,
  cast('' as scrtext_l) AS Level2HierarchyNodeLabel,
  HierarchicalRiskAnalysiskf.DataElement AS Level2DataElement,
  HierarchicalRiskAnalysiskf.RiskAnalyzerKeyFigureValue AS RiskAnalyzerKeyFigureValue,
  cast('' as char30) AS PackedKeyFigureValue,
  HierarchicalRiskAnalysiskf.StatusCode AS StatusCode,
  abs(HierarchicalRiskAnalysiskf.RiskAnalyzerKeyFigureValue) AS SortField
FROM P_MRHierarchicalNonAddKFVal
INNER JOIN P_PortfolioHierarchyNode AS ParentHierarchyNode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MktRskKeyFigModifiedDuration AS _ModifiedDuration ON _ModifiedDuration.RiskAnalyzerKeyFigure = RiskAnalyzerKeyFigure AND _ModifiedDuration.EffectiveValidityStartDate <= KeyDate AND _ModifiedDuration.EffectiveValidityEndDate > KeyDate  -- association [1..1]
;