I_DataMdmExchNode

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_DataMdmExchNode.
-- 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_DataMdmExchNode AS
SELECT
  cast(dmee_tree_node.tree_type as dme_treetype preserving type) AS HierarchyTreeType,
  cast(dmee_tree_node.tree_id as dme_tree preserving type) AS HierarchyTree,
  cast(dmee_tree_node.version as ifme_hierarchytreeversion) AS HierarchyTreeVersion,
  cast(dmee_tree_node.node_id as dme_node preserving type) AS HierarchyNode,
  cast(dmee_tree_node.tech_name as dme_nodename preserving type) AS NodeName,
  cast(dmee_tree_node.ref_name as dme_noderef preserving type) AS HierarchyNodeReference,
  cast(dmee_tree_node.parent_id as dme_parentnode preserving type) AS ParentNode,
  cast(dmee_tree_node.brother_id as dme_siblingnode preserving type) AS SiblingNode,
  cast(dmee_tree_node.firstchild_id as dme_childnode preserving type) AS ChildNode,
  cast(dmee_tree_node.node_type as dme_nodetype preserving type) AS NodeType,
  cast(dmee_tree_node.length as dme_outpvallen preserving type) AS OutputLengthValue,
  cast(dmee_tree_node.data_type as dme_outpvaldatatype preserving type) AS OutputValueDataType,
  cast(dmee_tree_node.ex_status as dme_outpoblgnsts preserving type) AS OutputObligationStatus,
  cast(dmee_tree_node.lev as dme_hiernodelvl preserving type) AS HierarchyNodeLevel,
  cast(dmee_tree_node.tab_keyfld as dme_tblkeyfld preserving type) AS InternalTableKeyField,
  cast(dmee_tree_node.atom_handl as dme_atomprocgtype preserving type) AS AtomProcessingType,
  cast(dmee_tree_node.mp_offset as dme_outpvaloffset preserving type) AS OutputValueOffset,
  cast(dmee_tree_node.mp_sc_tab as dme_srcestruc preserving type) AS ValueSourceStructure,
  cast(dmee_tree_node.mp_sc_fld as dme_srcestrucfld preserving type) AS ValueSourceStructureField,
  cast(dmee_tree_node.mp_sc_offset as dme_srcestrucfldoffst preserving type) AS ValueSourceStructureFieldOffst,
  cast(dmee_tree_node.mp_if_tp as dme_srcdtaorigintftyp preserving type) AS SourceDataOriglInterfaceType,
  cast(dmee_tree_node.mp_sc_node as dme_referrednode preserving type) AS HierarchyReferredNode,
  cast(dmee_tree_node.mp_sc_node_attr as dme_refnodecnttype preserving type) AS HierarchyReferredNodeCntntType,
  cast(dmee_tree_node.mp_sc_ref_name as dme_referrnoderef preserving type) AS HierarchyReferredNodeReference,
  cast(dmee_tree_node.mp_const as dme_srceconst preserving type) AS SourceConstantValue,
  cast(dmee_tree_node.cv_rule as dme_outputconvfce preserving type) AS OutputConversionFunction,
  cast(dmee_tree_node.mp_exit_func as dme_mappingfunction preserving type) AS MappingFunction,
  cast(dmee_tree_node.mp_selection as dme_mappingtype preserving type) AS MappingType,
  cast(dmee_tree_node.mp_cuky_tab as dme_refunittbl preserving type) AS ReferenceUnitTable,
  cast(dmee_tree_node.mp_cuky_fld as dme_refunittblfld preserving type) AS ReferenceUnitTableField,
  cast(dmee_tree_node.int_data_type as dme_refunittblfldtype preserving type) AS ReferenceUnitTableFieldType,
  cast(dmee_tree_node.tdform_name as dme_sapscriptid preserving type) AS TextOutputID,
  cast(dmee_tree_node.shifted_output as dme_dlydsgmtprocg preserving type) AS DelayedSegmentProcessing,
  cast(dmee_tree_node.segm_end as dme_sgmtclsgrule preserving type) AS SegmentClosingRule,
  cast(dmee_tree_node.segm_cr as dme_segmcrsep preserving type) AS SegmentIsCarriageRetSeparated,
  cast(dmee_tree_node.segm_lf as dme_segmlfsep preserving type) AS SegmentIsLineFeedSeparated,
  cast(dmee_tree_node.crlf_only as dme_sgmtisempty preserving type) AS SegmentIsEmpty,
  cast(dmee_tree_node.ck_exit_func as dme_checkfunction preserving type) AS CheckFunction,
  cast(dmee_tree_node.react_lev_screen as dme_usercheckmsgtyp preserving type) AS UserFileCheckMessageType,
  cast(dmee_tree_node.react_lev_exit as dme_funccheckmsgtyp preserving type) AS FunctionFileCheckMessageType,
  cast(dmee_tree_node.msg_class_screen as dme_usercheckmsgclass preserving type) AS UserFileCheckMessageClass,
  cast(dmee_tree_node.msg_num_screen as dme_usercheckmsgnum preserving type) AS UserFileCheckMessage,
  cast(dmee_tree_node.msg_class_exit as dme_funccheckmsgclass preserving type) AS FunctionFileCheckMessageClass,
  cast(dmee_tree_node.msg_num_exit as dme_funccheckmsgnum preserving type) AS FunctionFileCheckMessage,
  cast(dmee_tree_node.trailer as dme_istrailersgmt preserving type) AS IsTrailerSegment,
  cast(dmee_tree_node.cv_source_format as dme_inputconvfce preserving type) AS InputConversionFunction,
  cast(dmee_tree_node.length_in_bytes as dme_lengthbytes preserving type) AS LengthIsBytes,
  cast(dmee_tree_node_r.node_redefined as dme_nodeisredefined preserving type) AS HierarchyNodeIsRedefined,
  cast(dmee_tree_node_r.node_deactivated as dme_nodeisdactvtd preserving type) AS HierarchyNodeIsDeactivated,
  dmee_tree_node_r.var_name AS HierarchyTreeVariableName,
  I_DataMdmExchTree.HierarchyTreeRedefinitionLevel AS HierarchyTreeRedefinitionLevel,
  I_DataMdmExchTree.HierarchyTreeOriginalLanguage AS HierarchyTreeOriginalLanguage
FROM dmee_tree_node
LEFT OUTER JOIN I_DataMdmExchTreePrpty AS _TreePrpty ON _TreePrpty.HierarchyTreeType = HierarchyTreeType AND _TreePrpty.HierarchyTree = HierarchyTree AND _TreePrpty.HierarchyTreeVersion = HierarchyTreeVersion  -- association [0..1]
LEFT OUTER JOIN I_DataMdmExchNodeAggrgn AS _NodeAggrgn ON _NodeAggrgn.HierarchyTreeType = HierarchyTreeType AND _NodeAggrgn.HierarchyTree = HierarchyTree AND _NodeAggrgn.HierarchyTreeVersion = HierarchyTreeVersion AND _NodeAggrgn.HierarchyNode = HierarchyNode  -- association [1..*]
LEFT OUTER JOIN I_DataMdmExchNodeCndn AS _NodeCndn ON _NodeCndn.HierarchyTreeType = HierarchyTreeType AND _NodeCndn.HierarchyTree = HierarchyTree AND _NodeCndn.HierarchyTreeVersion = HierarchyTreeVersion AND _NodeCndn.HierarchyNode = HierarchyNode  -- association [1..*]
LEFT OUTER JOIN I_DataMdmExchNodeCalc AS _NodeCalc ON _NodeCalc.HierarchyTreeType = HierarchyTreeType AND _NodeCalc.HierarchyTree = HierarchyTree AND _NodeCalc.HierarchyTreeVersion = HierarchyTreeVersion AND _NodeCalc.HierarchyNode = HierarchyNode  -- association [1..*]
LEFT OUTER JOIN I_DataMdmExchNodeText AS _NodeText ON _NodeText.Language = $session.system_language AND _NodeText.HierarchyTreeType = HierarchyTreeType AND _NodeText.HierarchyTree = HierarchyTree AND _NodeText.HierarchyTreeVersion = HierarchyTreeVersion AND _NodeText.HierarchyNode = HierarchyNode  -- association [0..1]
LEFT OUTER JOIN I_DataMdmExchNodeText AS _NodeTextOriglLang ON _NodeTextOriglLang.Language = HierarchyTreeOriginalLanguage AND _NodeTextOriglLang.HierarchyTreeType = HierarchyTreeType AND _NodeTextOriglLang.HierarchyTree = HierarchyTree AND _NodeTextOriglLang.HierarchyTreeVersion = HierarchyTreeVersion AND _NodeTextOriglLang.HierarchyNode = HierarchyNode  -- association [0..1]
LEFT OUTER JOIN I_DataMediumExchangeNodeTrace AS _NodeTrace ON _NodeTrace.HierarchyTreeType = HierarchyTreeType AND _NodeTrace.HierarchyTree = HierarchyTree AND _NodeTrace.HierarchyNode = HierarchyNode  -- association [0..*]
;