FAC_SH_UNIVERSALHIERDIRVH

DDL: FAC_SH_UNIVERSALHIERDIRVH SQL: FACUHUNIHIDIRVH Type: view Package: FINS_FI_HRRP

Universal Hierarchy Directory Value Help

FAC_SH_UNIVERSALHIERDIRVH is a CDS View that provides data about "Universal Hierarchy Directory Value Help" in SAP S/4HANA. It reads from 10 data sources and exposes 10 fields with key fields HierarchyID, HierarchyType, HierarchyType, HierarchyType. Part of development package FINS_FI_HRRP.

10 data source(s) 10 fields

Data Sources (10)

SourceAliasJoin Type
hrrp_dirt_n hrrp_dirt_n left_outer
hrrp_typt hrrp_typt left_outer
hrrp_typt hrrp_typt left_outer
hrrp_typt hrrp_typt left_outer
uhdt_catg uhdt_catg inner
uhdt_catg uhdt_catg inner
uhdt_hier uhdt_hier left_outer
uhdt_hier uhdt_hier left_outer
uhdt_node uhdt_node inner
uhdt_vrsn uhdt_vrsn inner

Annotations (10)

NameValueLevelField
ObjectModel.representativeKey HierarchyID view
EndUserText.label Universal Hierarchy Directory Value Help view
AbapCatalog.sqlViewName FACUHUNIHIDIRVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.dataCategory #VALUE_HELP view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY HierarchyID
KEY HierarchyType uhdt_catg hrrp_hrytype
HierarchyName
hryidasHierarchyID
KEY HierarchyType hrrp_dir_n hrytyp
HierarchyName hrrp_dirt_n hrytxt
node_lvalashryid_40asHierarchyID
KEY HierarchyType uhdt_catg hrrp_hrytype
HierarchyName
HierarchyTypeName 
@ObjectModel.representativeKey: 'HierarchyID'
@EndUserText.label: 'Universal Hierarchy Directory Value Help'
@AbapCatalog.sqlViewName: 'FACUHUNIHIDIRVH'

@AbapCatalog.compiler.compareFilter:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.dataCategory: #VALUE_HELP
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #C,
  sizeCategory: #XL
}

define view FAC_SH_UNIVERSALHIERDIRVH
 as select distinct from uhdt_hid
    inner join            uhdt_catg on  uhdt_hid.hier_catg = uhdt_catg.catg_key
    left outer join       hrrp_typt on  uhdt_catg.hrrp_hrytype = hrrp_typt.hrytyp
                                    and hrrp_typt.spras        = $session.system_language
    left outer join       uhdt_hier  on uhdt_hier.hier_hid  =  uhdt_hid.hier_hid
                                    and uhdt_hier.hier_catg = uhdt_hid.hier_catg
                                    and uhdt_hier.lang     = $session.system_language
 
{
  key   cast(uhdt_hid.hier_hid as hryid_40)  as HierarchyID,
  key   uhdt_catg.hrrp_hrytype               as HierarchyType,
        @Semantics.text
        coalesce( uhdt_hier.hier_desc,'')                  as HierarchyName,
        coalesce(hrrp_typt.text ,'')                      as HierarchyTypeName
}
where uhdt_catg.hrrp_hrytype <> 'GL05'

union

select distinct from hrrp_dir_n
  left outer join    hrrp_dirt_n on  hrrp_dir_n.hrytyp   = hrrp_dirt_n.hrytyp
                                 and hrrp_dir_n.hryid    = hrrp_dirt_n.hryid
                                 and hrrp_dir_n.hryvalto = hrrp_dirt_n.hryvalto
                                 and hrrp_dirt_n.spras   = $session.system_language
  left outer join    hrrp_typt   on  hrrp_dir_n.hrytyp = hrrp_typt.hrytyp
                                 and hrrp_typt.spras   = $session.system_language

{
  key   hrrp_dir_n.hryid   as HierarchyID,
  key   hrrp_dir_n.hrytyp  as HierarchyType,
        @Semantics.text
        hrrp_dirt_n.hrytxt as HierarchyName,
        hrrp_typt.text     as HierarchyTypeName
}
where hrrp_dir_n.hrytyp <> 'GL05'

union

select distinct from uhdt_hid
    inner join            uhdt_catg on  uhdt_hid.hier_catg = uhdt_catg.catg_key
    inner join            uhdt_vrsn on uhdt_vrsn.hier_catg = uhdt_hid.hier_catg
                                    and uhdt_vrsn.hier_hid = uhdt_hid.hier_hid
    inner join            uhdt_node on uhdt_node.ver_id = uhdt_vrsn.ver_id
                                    and uhdt_node.node_type = 'R'
    left outer join       hrrp_typt on  uhdt_catg.hrrp_hrytype = hrrp_typt.hrytyp
                                    and hrrp_typt.spras        = $session.system_language
    left outer join       uhdt_hier  on uhdt_hier.hier_hid  =  uhdt_hid.hier_hid
                                    and uhdt_hier.hier_catg = uhdt_hid.hier_catg
                                    and uhdt_hier.lang     = $session.system_language                                
{
  key   cast(uhdt_node.node_lval as hryid_40) as HierarchyID,
  key   uhdt_catg.hrrp_hrytype               as HierarchyType,
        @Semantics.text
        coalesce( uhdt_hier.hier_desc,'')                   as HierarchyName,
        coalesce( hrrp_typt.text ,'')                       as HierarchyTypeName
}
where uhdt_catg.hrrp_hrytype = 'GL05'

Learn More