FINCS_UH_UNITHIER

DDL: FINCS_UH_UNITHIER SQL: FINCS_UH_CS17H Type: view Package: FIN_CS_UH_INTEGRATION

Universal Hierarchy - Consolidation Unit Hierarchy

FINCS_UH_UNITHIER is a CDS View that provides data about "Universal Hierarchy - Consolidation Unit Hierarchy" in SAP S/4HANA. It reads from 2 data sources (uhdt_hier, uhdt_vrsn) and exposes 11 fields. It has 1 association to related views. Part of development package FIN_CS_UH_INTEGRATION.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
uhdt_hier hier left_outer
uhdt_vrsn version from

Associations (1)

CardinalityTargetAliasCondition
[1..1] fac_cds_uh_category to_category $projection.HierarchyCategory = to_category.CategoryKey

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FINCS_UH_CS17H 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 Hierarchy view

Fields (11)

KeyFieldSource TableSource FieldDescription
VersionId uhdt_vrsn ver_id
ValidityStartDate uhdt_vrsn ver_vldfm
ValidityEndDate uhdt_vrsn ver_vldto
VersionMessage uhdt_vrsn ver_msg
ver_statusendasVersionStatus
VersionStatusText
HierarchyCategory uhdt_vrsn hier_catg
HierarchyId uhdt_vrsn hier_hid
HierarchyText uhdt_hier hier_desc
HierarchyVersionText
to_category to_category 
@AbapCatalog.sqlViewName: 'FINCS_UH_CS17H'
@ObjectModel.usageType: {
  dataClass: #MIXED,
  serviceQuality: #C,
  sizeCategory: #S
}
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Universal Hierarchy - Consolidation Unit Hierarchy'
define view FINCS_UH_UNITHIER as select from uhdt_vrsn as version
left outer join uhdt_hier as hier on version.hier_hid = hier.hier_hid and
                                version.hier_catg = hier.hier_catg and
                                hier.lang = $session.system_language
//inner join uhdt_clfd_val as clfdvalue on version.ver_id = clfdvalue.obj_id

association [1..1] to fac_cds_uh_category   as to_category   on $projection.HierarchyCategory = to_category.CategoryKey
{
  version.ver_id as VersionId,
  version.ver_vldfm as ValidityStartDate,
  version.ver_vldto as ValidityEndDate,
  version.ver_msg as VersionMessage,
  case
  when ( ver_status = 'R' or ver_status = 'A' ) and locked_by = $session.user
  then 'I' 
  else version.ver_status end as VersionStatus,
  cast( '' as vrstxt) as VersionStatusText,
  version.hier_catg as HierarchyCategory,
  version.hier_hid as HierarchyId,
  hier.hier_desc as HierarchyText,
  cast( concat(concat(version.hier_hid, concat(' (',version.ver_vldfm) ), concat(concat('~',version.ver_vldto), ')') ) as vhdec) as HierarchyVersionText,
  to_category
}
where version.hier_catg = 'CS17'
and version.ver_status <> 'T'

Learn More