FAC_CDS_UH_STSTCLKEYFIGNODE

DDL: FAC_CDS_UH_STSTCLKEYFIGNODE SQL: FACV_UH_STKFEDGE Type: view

Universal Hier Stat Key Figure Node

FAC_CDS_UH_STSTCLKEYFIGNODE is a CDS View that provides data about "Universal Hier Stat Key Figure Node" in SAP S/4HANA. It reads from 4 data sources (uhdt_clfd_val, uhdt_node, uhdt_ntxt, uhdt_vrsn) and exposes 14 fields with key field NodeId.

4 data source(s) 14 fields

Data Sources (4)

SourceAliasJoin Type
uhdt_clfd_val clfdvalue inner
uhdt_node node from
uhdt_ntxt ntxt left_outer
uhdt_vrsn version inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FACV_UH_STKFEDGE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Universal Hier Stat Key Figure Node view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY NodeId uhdt_node node_id
NodeType uhdt_node node_type
VersionId uhdt_node ver_id
HierarchyId uhdt_vrsn hier_hid
VersionNumber uhdt_vrsn ver_nbr
VersionMessage uhdt_vrsn ver_msg
ValidFrom uhdt_vrsn ver_vldfm
ver_statusendasVersionStatus
NodeValue
NodeText uhdt_ntxt lval_txt
node_hvalasnltxtendasNodeValueText
val_lowascctrlendasControllingArea
NodeTextUpper
to_version to_version 
@AbapCatalog.sqlViewName: 'FACV_UH_STKFEDGE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ObjectModel.usageType: {
  dataClass: #MIXED,
  serviceQuality: #C,
  sizeCategory: #S
}
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Universal Hier Stat Key Figure Node'
define view FAC_CDS_UH_STSTCLKEYFIGNODE as select from uhdt_node as node
inner join uhdt_vrsn as version on node.ver_id = version.ver_id
inner join uhdt_clfd_val as clfdvalue on node.ver_id = clfdvalue.obj_id
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.node_type as NodeType,
  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 cast ( 'I' as vrsst ) 
  else version.ver_status end as VersionStatus,
  cast(node.node_lval as ncval) as NodeValue,
  ntxt.lval_txt as NodeText,
  case 
  when node.node_hval = '' then case 
               when ntxt.lval_txt is null or ntxt.lval_txt = '' 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,
  case clfdvalue.val_sign
  when 'S' then cast( clfdvalue.val_low as cctrl)
  when 'R' then cast( concat(clfdvalue.val_low,concat('~',clfdvalue.val_high)) as cctrl) 
  else cast( clfdvalue.val_low as cctrl) end as ControllingArea,
  cast( upper(ntxt.lval_txt) as nltxt ) as NodeTextUpper,
  to_version
}
where version.hier_catg = '0104'
and clfdvalue.fld_name = 'CONTROLLINGAREA'
and (node.node_type = 'N' or node.node_type = 'R' or node.node_type = 'Z')
and version.ver_status <> 'T'
and version.ver_status <> 'B' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"UHDT_CLFD_VAL",
"UHDT_NODE",
"UHDT_NTXT",
"UHDT_VRSN"
],
"ASSOCIATED":
[
"FAC_CDS_UH_VERSION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More