I_DataMdmExchNodeCalc

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 I_DataMdmExchNodeCalc.
-- 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.

CREATE VIEW I_DataMdmExchNodeCalc AS
SELECT
  cast(tree_type as dme_treetype preserving type) AS HierarchyTreeType,
  cast(tree_id as dme_tree preserving type) AS HierarchyTree,
  cast(version as ifme_hierarchytreeversion) AS HierarchyTreeVersion,
  cast(node_id as dme_node preserving type) AS HierarchyNode,
  sequence AS SortSequence,
  var_name AS HierarchyTreeVariableName,
  var_operation AS HierarchyTreeArithmeticOptr,
  var_value_l AS LeftOperandValue,
  cast(var_calc_src_type_l as dme_leftopertyp preserving type) AS LeftOperandType,
  cast(ref_node_attr_l as dme_leftopernodecnttyp preserving type) AS LeftOperandNodeContentType,
  var_value_r AS RightOperandValue,
  cast(var_calc_src_type_r as dme_rightopertyp preserving type) AS RightOperandType,
  cast(ref_node_attr_r as dme_rightopernodecnttyp preserving type) AS RightOperandNodeContentType,
  _CalcOperText.HierarchyTreeArithmeticOptrTxt AS HierarchyTreeArithmeticOptrTxt
FROM dmee_tree_calc
LEFT OUTER JOIN I_DataMdmExchNodeCalcOpText AS _CalcOperText ON _CalcOperText.HierarchyTreeArithmeticOptr = HierarchyTreeArithmeticOptr AND _CalcOperText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DataMdmExchNode AS _TreeNode ON _TreeNode.HierarchyTreeType = HierarchyTreeType AND _TreeNode.HierarchyTree = HierarchyTree AND _TreeNode.HierarchyTreeVersion = HierarchyTreeVersion  -- association [0..*]
;