I_DataMdmExchCustTreePrpty

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_DataMdmExchCustTreePrpty.
-- 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_DataMdmExchCustTreePrpty 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(param_struc as dme_treeparamstruc preserving type) AS HierarchyTreeParametersStruc,
  cast(fm_fieldtp as dme_outpstructdelimtype preserving type) AS OutputStructureDelimiterType,
  cast(sgmg_delim as dme_sgmtgrpdelimiterval preserving type) AS SegmentGroupDelimiterCharValue,
  cast(segm_delim as dme_sgmtdelimiterval preserving type) AS SegmentDelimiterCharacterValue,
  cast(comp_delim as dme_compdelimiterval preserving type) AS CompositeDelimiterCharValue,
  cast(escape_symb as dme_delimiterescval preserving type) AS DelimiterEscapeCharacterValue,
  cast(firstnode_id as dme_rootnode preserving type) AS HierarchyRootNode,
  cast(sgmg_cr as dme_segmgrpcrsep preserving type) AS SgmtGrpIsCarriageRetSeparated,
  cast(sgmg_lf as dme_segmgrplfsep preserving type) AS SegmentGrpIsLineFeedSeparated,
  cast(segm_cr as dme_segmcrsep preserving type) AS SegmentIsCarriageRetSeparated,
  cast(segm_lf as dme_segmlfsep preserving type) AS SegmentIsLineFeedSeparated,
  cast(filesheet as dme_shttype preserving type) AS AccompanyingSheetType,
  cast(vers_user as vdm_lastchangedbyuserid preserving type) AS LastChangedByUser,
  cast(vers_date as dme_changeddate preserving type) AS LastChangeDate,
  cast(vers_time as dme_changedtime preserving type) AS LastChangeTime,
  cast(charset as dme_spclhndlgchar preserving type) AS SpecialHandlingCharacter,
  cast(charset_excl as dme_spechandlcharexcl preserving type) AS SpecialHandlingCharacterIsExcl,
  cast(xsltdesc as dme_postprocgpgm preserving type) AS PostProcessingProgramName,
  cast(handle_bytes as dme_lengthbytes preserving type) AS LengthIsBytes,
  request_id AS DataReleaseRequestID,
  version_type AS HierarchyTreeVersionType,
  XMLEmptyElementProcessingType,
  charset_options AS HierTreeSpclCharHndlgOptions,
  character_regex AS HierTreeSpclCharRegularExprVal,
  msgtype AS XMLSchemaDefinitionIdentifier,
  detailed_description AS HierarchyTreeDetailedText
FROM dmec_tree_head
LEFT OUTER JOIN I_DataMdmExchCustNode AS _TreeNode ON _TreeNode.HierarchyTreeType = HierarchyTreeType AND _TreeNode.HierarchyTree = HierarchyTree AND _TreeNode.HierarchyTreeVersion = HierarchyTreeVersion  -- association [0..*]
LEFT OUTER JOIN I_DataMdmExchCustTreeLevel AS _TreeLevel ON _TreeLevel.HierarchyTreeType = HierarchyTreeType AND _TreeLevel.HierarchyTree = HierarchyTree AND _TreeLevel.HierarchyTreeVersion = HierarchyTreeVersion  -- association [0..*]
LEFT OUTER JOIN I_DataMdmExchCustDataSorting AS _TreeDataSorting ON _TreeDataSorting.HierarchyTreeType = HierarchyTreeType AND _TreeDataSorting.HierarchyTree = HierarchyTree AND _TreeDataSorting.HierarchyTreeVersion = HierarchyTreeVersion  -- association [0..*]
LEFT OUTER JOIN I_DataMdmExchCustTreeSheet AS _TreeSheet ON _TreeSheet.HierarchyTreeType = HierarchyTreeType AND _TreeSheet.HierarchyTree = HierarchyTree AND _TreeSheet.HierarchyTreeVersion = HierarchyTreeVersion  -- association [0..*]
LEFT OUTER JOIN I_DataMdmExchCustTreeVarbl AS _TreeVariable ON _TreeVariable.HierarchyTreeType = HierarchyTreeType AND _TreeVariable.HierarchyTree = HierarchyTree AND _TreeVariable.HierarchyTreeVersion = HierarchyTreeVersion  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON LastChangedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
;