FINCS_UH_SEGMENTNode

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 FINCS_UH_SEGMENTNode.
-- 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: FINCS_UH_CS01N

CREATE VIEW FINCS_UH_SEGMENTNode AS
SELECT
  node.node_id AS NodeId,
  node.ver_id AS VersionId,
  version.hier_hid AS HierarchyId,
  version.ver_nbr AS VersionNumber,
  version.ver_msg AS VersionMessage,
  version.ver_vldfm AS ValidFrom,
  case when ( ver_status = 'R' or ver_status = 'A' ) and locked_by = $session.user then 'I' else version.ver_status end as VersionStatus AS ver_statusendasVersionStatus,
  case node.node_hval when '' then cast(node.node_lval as ncval) else cast (concat(node.node_lval,concat('~',node.node_hval)) as ncval) end as NodeValue AS node_hvalasncvalendasNodeValue,
  ntxt.lval_txt AS NodeText,
  case node.node_hval when '' then case ntxt.lval_txt when '' then cast( node.node_lval as nltxt ) else cast( concat( node.node_lval, concat('(',concat( ntxt.lval_txt, ')' ) ) ) as nltxt ) end else cast (concat(node.node_lval,concat('~',node.node_hval)) as nltxt) end as NodeValueText AS node_hvalasnltxtendasNodeValueText,
  to_version
FROM uhdt_node AS node
INNER JOIN uhdt_vrsn AS version ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN uhdt_ntxt AS ntxt ON /* join condition not captured in parsed metadata */
;