FINCS_UH_UNITNODE

DDL: FINCS_UH_UNITNODE SQL: FINCS_UH_CS17N Type: view Package: FIN_CS_UH_INTEGRATION

Universal Hierarchy - Consolidation Unit Node

FINCS_UH_UNITNODE is a CDS View that provides data about "Universal Hierarchy - Consolidation Unit Node" in SAP S/4HANA. It reads from 4 data sources (FINCS_UH_CONSGROUP, uhdt_node, uhdt_ntxt, uhdt_vrsn) and exposes 9 fields with key field NodeId. It has 1 association to related views. Part of development package FIN_CS_UH_INTEGRATION.

4 data source(s) 9 fields

Data Sources (4)

SourceAliasJoin Type
FINCS_UH_CONSGROUP _Group left_outer
uhdt_node node from
uhdt_ntxt ntxt left_outer
uhdt_vrsn version inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] fac_cds_uh_version to_version $projection.VersionId = to_version.VersionId

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FINCS_UH_CS17N view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Universal Hierarchy - Consolidation Unit Node view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY NodeId uhdt_node node_id
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
NodeText uhdt_ntxt lval_txt
to_version to_version 
@AbapCatalog.sqlViewName: 'FINCS_UH_CS17N'
@ObjectModel.usageType: {
  dataClass: #MIXED,
  serviceQuality: #C,
  sizeCategory: #S
}
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Universal Hierarchy - Consolidation Unit Node'
define view FINCS_UH_UNITNODE
  as select from    uhdt_node          as node
    inner join      uhdt_vrsn          as version on node.ver_id = version.ver_id
    left outer join uhdt_ntxt          as ntxt    on  node.node_id = ntxt.node_id
                                                  and ntxt.lang    = $session.system_language

    left outer join FINCS_UH_CONSGROUP as _Group  on  node.node_entity = 'FINCS_GROUP'
                                                  and node.node_lval   = _Group.ConsolidationGroup
  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,
      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,
      case node.node_entity
      when '' then cast(node.node_lval as ncval)
      else cast (_Group.ConsGroupExternalValue as ncval) end as NodeValue,
      ntxt.lval_txt                                          as NodeText,
      case node.node_entity
      when '' then case ntxt.lval_txt
                   when '' then cast( node.node_lval as nltxt )
                   else cast( concat_with_space( node.node_lval, concat('(',concat( ntxt.lval_txt, ')' ) ),1 ) as nltxt ) end
      else
      case _Group.ConsolidationGroupText
                   when '' then cast( _Group.ConsGroupExternalValue as nltxt )
                   else cast( concat_with_space( _Group.ConsGroupExternalValue, concat('(',concat( _Group.ConsolidationGroupText, ')' ) ),1 ) as nltxt ) end
        end                                                  as NodeValueText,
      to_version
}
where
       version.hier_catg  =  'CS17'
  and(
       node.node_type     =  'N'
    or node.node_type     =  'R'
  )
  and  version.ver_status <> 'T'

Learn More