I_ConversionObjectHierarchy

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_ConversionObjectHierarchy.
-- 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_ConversionObjectHierarchy AS
SELECT
  ConversionPackage,
  ConversionObject,
  cast('Conversion Object' as abap.char(65) ) AS CnvrsnObjectHierarchyNodeAlias,
  cast('' as abap.char(65)) AS CnvrsnObjHierParentNodeAlias,
  cast('Conversion Object' as abap.char(30)) AS CnvrsnObjectHierarchyNodeName,
  cast('' as abap.char(30)) AS CnvrsnObjHierParentNodeName,
  cast('Conversion Object' as abap.char(65) ) AS CnvrsnObjectHierNodeFullName,
  'C' AS CnvrsnObjHierarchyNodeCategory,
  ConversionObjectDataSource,
  CnvrsnFunctionAssignmentID,
  CnvrsnFunctionAssignmentType,
  ConversionObjectCreatedBy,
  CnvrsnObjectCreatedOnDateTime,
  ConversionObjectChangedBy,
  case TableRelationship.ConversionParentTableAlias when '' then cast('Conversion Object' as abap.char(65) ) else cast(TableRelationship.ConversionParentTableAlias as abap.char(65) ) end as CnvrsnObjHierParentNodeAlias AS char65endasCnvrsnObjHierParentNodeAlias,
  TableField.CnvrsnObjLoclLastChgdOnDteTme AS CnvrsnObjLoclLastChgdOnDteTme
FROM I_ConversionHeader
LEFT OUTER JOIN I_ConversionTable AS Table ON TableRelationship.ConversionPackage = Table.ConversionPackage AND TableRelationship.ConversionObject = Table.ConversionObject AND TableRelationship.ConversionTableAlias = Table.ConversionTableAlias  -- association [1..1]
LEFT OUTER JOIN I_ConversionTable AS Table2 ON TableRelationship.ConversionPackage = Table2.ConversionPackage AND TableRelationship.ConversionObject = Table2.ConversionObject AND TableRelationship.ConversionParentTableAlias = Table2.ConversionTableAlias  -- association [1..1]
LEFT OUTER JOIN I_ConversionTable AS _Table ON TableField.ConversionPackage = _Table.ConversionPackage AND TableField.ConversionObject = _Table.ConversionObject AND TableField.ConversionTableAlias = _Table.ConversionTableAlias  -- association [0..1]
-- UNION with additional select branch(es): I_ConversionTableRelationship, I_ConversionTableField
;