FAC_CDS_UH_PRFTCENTERHIER

DDL: FAC_CDS_UH_PRFTCENTERHIER SQL: FACV_UH_CEPCHIER Type: view Package: FINS_FI_UH

Universal Profit Center Hierarchy

FAC_CDS_UH_PRFTCENTERHIER is a CDS View that provides data about "Universal Profit Center Hierarchy" in SAP S/4HANA. It reads from 3 data sources (uhdt_clfd_val, uhdt_hier, uhdt_vrsn) and exposes 13 fields. It has 1 association to related views. Part of development package FINS_FI_UH.

3 data source(s) 13 fields

Data Sources (3)

SourceAliasJoin Type
uhdt_clfd_val clfdvalue inner
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 FACV_UH_CEPCHIER view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Universal Profit Center Hierarchy view

Fields (13)

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
HierarchyText uhdt_hier hier_desc
HierarchyVersionText
val_lowascctrlendasControllingArea
hier_descasvhdecendasHierarchyTextUpper
to_category to_category 
@AbapCatalog.sqlViewName: 'FACV_UH_CEPCHIER'
//@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {
  dataClass: #MIXED,
  serviceQuality: #C,
  sizeCategory: #S
}
@EndUserText.label: 'Universal Profit Center Hierarchy'
define view FAC_CDS_UH_PRFTCENTERHIER
  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 cast ( 'I' as vrsst )
  else version.ver_status end                                                                                                    as VersionStatus,
  cast( '' as vrstxt)                                                                                                            as VersionStatusText,
  version.hier_catg                                                                                                              as HierarchyCategory,
  cast( version.hier_hid as vhrid)                                                                                               as HierarchyId, //remove value help

  hier.hier_desc                                                                                                                 as HierarchyText,
  cast( concat(concat(version.hier_hid, concat(' (',version.ver_vldfm) ), concat(concat('~',version.ver_vldto), ')') ) as vhdec) as HierarchyVersionText,
  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,
  case when hier.hier_desc is null then ''
  else cast( upper(hier.hier_desc) as vhdec ) end                                                                                as HierarchyTextUpper,
  to_category
}
where
       version.hier_catg                       =  '0106'
  and  clfdvalue.fld_name                      =  'CONTROLLINGAREA'
  and  version.ver_status                      <> 'T'
  and  version.ver_status                      <> 'B'

Learn More