I_DataMdmExchCustNodeCndn

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_DataMdmExchCustNodeCndn.
-- 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_DataMdmExchCustNodeCndn 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,
  cast(cond_number as dme_cndnstp preserving type) AS ConditionStep,
  cast(par_open as dme_preexproper preserving type) AS PreexpressionOperator,
  cast(arg1_fld as dme_leftoperfldname preserving type) AS LeftOperandFieldName,
  cast(arg1_tab as dme_leftoperstruct preserving type) AS LeftOperandStructure,
  cast(arg1_xparam as dme_leftoperiftyp preserving type) AS LeftOperandInterfaceType,
  cast(arg1_const as dme_leftopercmpval preserving type) AS LeftOperandComparisonValue,
  cast(arg1_node as dme_leftopernode preserving type) AS LeftOperandNode,
  cast(arg1_node_attr as dme_leftopernodecnttyp preserving type) AS LeftOperandNodeContentType,
  cast(arg1_ref_name as dme_leftopernoderef preserving type) AS LeftOperandNodeReference,
  cast(arg1_type as dme_leftopertyp preserving type) AS LeftOperandType,
  arg1_var AS LeftOperandVariableName,
  cast(arg2_fld as dme_rightoperfldname preserving type) AS RightOperandFieldName,
  cast(arg2_tab as dme_rightoperstruct preserving type) AS RightOperandStructure,
  cast(arg2_xparam as dme_rightoperiftyp preserving type) AS RightOperandInterfaceType,
  cast(arg2_const as dme_rightopercmpval preserving type) AS RightOperandComparisonValue,
  cast(arg2_node as dme_rightopernode preserving type) AS RightOperandNode,
  cast(arg2_node_attr as dme_rightopernodecnttyp preserving type) AS RightOperandNodeContentType,
  cast(arg2_ref_name as dme_rightopernoderef preserving type) AS RightOperandNodeReference,
  cast(arg2_type as dme_rightopertyp preserving type) AS RightOperandType,
  arg2_var AS RightOperandVariableName,
  cast(operator as dme_compoper preserving type) AS ComparisonOperator,
  cast(par_close as dme_postexproper preserving type) AS PostexpressionOperator,
  cast(link_operator as dme_logicoper preserving type) AS LogicalOperator
FROM dmec_tree_cond
LEFT OUTER JOIN I_DataMdmExchCustNode AS _Node ON _Node.HierarchyTreeType = HierarchyTreeType AND _Node.HierarchyTree = HierarchyTree AND _Node.HierarchyTreeVersion = HierarchyTreeVersion AND _Node.HierarchyNode = HierarchyNode  -- association [0..1]
;