fac_cds_uh_node

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 fac_cds_uh_node.
-- 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.
-- SQL view name: FACV_UH_EDGE

CREATE VIEW fac_cds_uh_node AS
SELECT
  node.node_id AS NodeId,
  node.ver_id AS VersionId,
  node_pid AS NodeParentId,
  node_rid AS NodeRefId,
  node.node_id AS JoinId,
  node_type AS NodeType,
  node_entity AS NodeEntity,
  node_level AS NodeLevel,
  node_ind AS NodeIndicator,
  node_seq AS NodeSequence,
  node_order AS NodeDisplayOrder,
  node_sgn AS NodeSign,
  node_vldfm AS NodeValidFrom,
  node_vldto AS NodeValidTo,
  node_lval AS NodeLowValue,
  node_hval AS NodeHighValue,
  node.created_at AS CreatedAt,
  node.created_by AS CreatedBy,
  node.updated_at AS UpdatedAt,
  node.updated_by AS UpdatedBy,
  ref_verid AS ReferenceVersionID,
  ref_t_group_id AS ReferenceGroupID,
  origin_verid AS OriginVersionID,
  ntxt.lval_txt AS NodeLowText,
  ntxt.hval_txt AS NodeHighText,
  case when node_type = 'Z' then r.hier_hid end as RefHierarchyID AS hier_hidendasRefHierarchyID,
  case when node_type = 'Z' then r.ver_vldfm end as RefValidFromDate AS ver_vldfmendasRefValidFromDate,
  case when node_type = 'Z' then r.ver_vldto end as RefValidToDate AS ver_vldtoendasRefValidToDate,
  r.hier_hid AS OriginHierarchyID,
  to_merged_semtag.SemanticTags AS SemanticTags,
  to_merged_semtag.SemanticTagsTextJson AS SemanticTagsTextJson,
  case when ref_t_group_id <> '' then 'X' else to_node_action.Forbid_Add_Leaf end as ForbidAddLeaf AS Forbid_Add_LeafendasForbidAddLeaf,
  case when ref_t_group_id <> '' then 'X' else to_node_action.Forbid_Add_Node end as ForbidAddNode AS Forbid_Add_NodeendasForbidAddNode,
  case when ( ref_t_group_id <> '' and node_type <> 'Z' ) then 'X' else to_node_action.Forbid_Delete end as ForbidDelete AS Forbid_DeleteendasForbidDelete,
  case when ref_t_group_id <> '' then 'X' else to_node_action.Forbid_Update end as ForbidUpdate AS Forbid_UpdateendasForbidUpdate,
  case when ref_t_group_id <> '' or node_type = 'R' then 'X' else to_node_action.Forbid_Add_Semtag end as ForbidAddSemTag AS Forbid_Add_SemtagendasForbidAddSemTag,
  case when ( ref_t_group_id <> '' and node_type <> 'Z' ) then 'X' else to_node_action.Forbid_Move end as ForbidMove AS Forbid_MoveendasForbidMove,
  to_version,
  to_semtag
FROM uhdt_node AS node
LEFT OUTER JOIN uhdt_ntxt AS ntxt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN uhdt_vrsn AS r ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fac_cds_uh_clfd_value AS to_clfd_value ON JoinId = to_clfd_value.ObjectId  -- association [1..*]
LEFT OUTER JOIN fac_cds_uh_version AS to_version ON VersionId = to_version.VersionId  -- association [1..1]
LEFT OUTER JOIN FAC_CDS_UH_NODESEMTAG AS to_semtag ON JoinId = to_semtag.NodeId  -- association [1..*]
LEFT OUTER JOIN FAC_CDS_UH_FUNCTBL_SEMTAG AS to_merged_semtag ON JoinId = to_merged_semtag.NodeId  -- association [1..1]
LEFT OUTER JOIN FAC_CDS_UH_FUNCTBL_MULTIATTR AS to_merged_attrvals ON JoinId = to_merged_attrvals.NodeId  -- association [1..1]
LEFT OUTER JOIN FAC_CDS_UH_NODE_ATTR_VALUE AS to_attribute_values ON JoinId = to_attribute_values.NodeId  -- association [0..*]
LEFT OUTER JOIN FAC_CDS_UH_NODE_ACTION AS to_node_action ON JoinId = to_node_action.NodeId  -- association [1..1]
;