I_DataMdmExchTreeType

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_DataMdmExchTreeType.
-- 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_DataMdmExchTreeType AS
SELECT
  cast(tree_type as dme_treetype preserving type) AS HierarchyTreeType,
  cast(if_type as dme_iftype preserving type) AS InputStructureName,
  cast(if_param as dme_ifparam preserving type) AS ParametricInputStructureName,
  cast(if_tab as dme_iftab preserving type) AS InputTableName,
  cast(sortfld_length as dme_srtfldlen preserving type) AS SortFieldLength,
  cast(sheetstruc as dme_acshtstruc preserving type) AS AccompanyingSheetStructure,
  cast(x_filesheet as dme_acshtallowed preserving type) AS AccompanyingSheetIsAllowed,
  cast(category as dme_treetypcat preserving type) AS HierarchyTreeTypeCategory,
  cast(test_report as dme_tstrepname preserving type) AS TestReportName,
  cast(field_delim as dme_flddelimconvfrmt preserving type) AS OutputFileFieldDelimiter,
  cast(rec_delim as dme_recdelimconvfrmt preserving type) AS OutputFileRecordDelimiter,
  cast(group_delim as dme_grpdelimconvfrmt preserving type) AS OutputFileGroupDelimiter,
  cast(docu_template as doku_obj preserving type) AS DocumentationObject,
  cast(auth_group as brgru preserving type) AS AuthorizationGroup,
  cast(x_keyonly as dme_keynotsort preserving type) AS KeyWithoutSortingIsAllowed,
  _TypeText.HierarchyTreeTypeShortText AS HierarchyTreeTypeShortText
FROM dmee_tree_type
LEFT OUTER JOIN I_DataMdmExchTreeTypeText AS _TypeText ON _TypeText.Language = $session.system_language AND _TypeText.HierarchyTreeType = HierarchyTreeType  -- association [0..1]
LEFT OUTER JOIN I_DataMdmExchFunction AS _Function ON _Function.HierarchyTreeType = HierarchyTreeType  -- association [1..*]
LEFT OUTER JOIN I_DataMdmExchTechSourceField AS _TechSourceField ON _TechSourceField.HierarchyTreeType = HierarchyTreeType  -- association [1..*]
LEFT OUTER JOIN I_DataMdmExchTree AS _Tree ON _Tree.HierarchyTreeType = HierarchyTreeType  -- association [1..*]
;