fac_cds_ve_group_node

@AbapCatalog.sqlViewName: 'FACV_VE_GPND'
//@ClientHandling.algorithm: #SESSION_VARIABLE

@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Validation Group Node'
@AbapCatalog.preserveKey: true
@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #C,
  sizeCategory: #S
}
define view fac_cds_ve_group_node
  as select from    uhdt_node as node
    left outer join uhdt_ntxt as ntxt on  node.node_id = ntxt.node_id
                                      and ntxt.lang    = $session.system_language
  association [1..1] to fac_cds_uh_version as to_version on $projection.VersionId = to_version.VersionId

{
  key 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,
      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,
      ntxt.lval_txt                as NodeLowText,
      ntxt.hval_txt                as NodeHighText,

      to_version
}
where
  to_version.HierarchyCategory = 'GL05'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAC_CDS_UH_VERSION",
"UHDT_NODE",
"UHDT_NTXT"
],
"ASSOCIATED":
[
"FAC_CDS_UH_VERSION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/