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