fac_cds_ve_group_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_ve_group_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_VE_GPND

CREATE VIEW fac_cds_ve_group_node AS
SELECT
  node.node_id AS NodeId,
  node.ver_id AS VersionId,
  node_pid AS NodeParentId,
  node.node_id AS JoinId,
  node_type AS NodeType,
  to_version.HierarchyId AS HierarchyId,
  to_version.HierarchyCategory AS HierarchyCategory,
  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,
  case when ntxt.lval_txt is not null then ntxt.lval_txt else ntxt_e.lval_txt end as NodeLowText AS lval_txtendasNodeLowText,
  case when ntxt.hval_txt is not null then ntxt.hval_txt else ntxt_e.hval_txt end as NodeHighText AS hval_txtendasNodeHighText,
  node.node_rid AS NodeRefId,
  node.ref_verid AS ReferenceVersionID,
  node.ref_t_group_id AS ReferenceGroupID,
  node.origin_verid AS OriginVersionID,
  r.hier_hid AS OriginHierarchyID,
  case when node_type = 'Z' then r.hier_hid end as RefHierarchyID AS hier_hidendasRefHierarchyID,
  case when node.ref_t_group_id <> '' then 'R' else '' end as VirtualFlag AS ref_t_group_idthenRelseendasVirtualFlag,
  case when node.ref_t_group_id <> '' then 'X' else to_node_action.Forbid_Add_Leaf end as ForbidAddLeaf AS Forbid_Add_LeafendasForbidAddLeaf,
  case when node.ref_t_group_id <> '' then 'X' else to_node_action.Forbid_Add_Node end as ForbidAddNode AS Forbid_Add_NodeendasForbidAddNode,
  case when ( node.ref_t_group_id <> '' and node_type <> 'Z' ) then 'X' else to_node_action.Forbid_Delete end as ForbidDelete AS Forbid_DeleteendasForbidDelete,
  case when node.ref_t_group_id <> '' then 'X' else to_node_action.Forbid_Update end as ForbidUpdate AS Forbid_UpdateendasForbidUpdate,
  case when ( node.ref_t_group_id <> '' and node_type <> 'Z' ) then 'X' else to_node_action.Forbid_Move end as ForbidMove AS Forbid_MoveendasForbidMove,
  to_version
FROM uhdt_node AS node
LEFT OUTER JOIN uhdt_ntxt AS ntxt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN uhdt_ntxt AS ntxt_e 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_version AS to_version ON VersionId = to_version.VersionId  -- association [1..1]
LEFT OUTER JOIN FAC_CDS_UH_NODE_ACTION AS to_node_action ON JoinId = to_node_action.NodeId  -- association [1..1]
;