FAC_CDS_UH_VSRN_TO_UPDATE

DDL: FAC_CDS_UH_VSRN_TO_UPDATE SQL: FACV_VRSN_UPD Type: view Package: UH_CORE

Hierarchy Version to Be Update

FAC_CDS_UH_VSRN_TO_UPDATE is a CDS View that provides data about "Hierarchy Version to Be Update" in SAP S/4HANA. It reads from 4 data sources (uhdt_betyt, uhdt_catgt, uhdt_hier, uhdt_vrsn) and exposes 12 fields with key field VersionId. It has 2 associations to related views. Part of development package UH_CORE.

4 data source(s) 12 fields

Data Sources (4)

SourceAliasJoin Type
uhdt_betyt betyt left_outer
uhdt_catgt catgt left_outer
uhdt_hier hier left_outer
uhdt_vrsn vrsn inner

Associations (2)

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

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FACV_VRSN_UPD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Hierarchy Version to Be Update view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY VersionId notif ver_id
HierarchyCategory uhdt_vrsn hier_catg
CategoryText uhdt_catgt catg_text
HierarchyId uhdt_vrsn hier_hid
BusinessEntityName to_category BusinessEntityName
bety_textendasBusinessEntityText
HierarchyDescription uhdt_hier hier_desc
ValidFrom uhdt_vrsn ver_vldfm
ValidTo uhdt_vrsn ver_vldto
VersionStatus to_version VersionStatus
CreatedOn to_version CreatedOn
to_category to_category 
@AbapCatalog.sqlViewName: 'FACV_VRSN_UPD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
//@ClientHandling.algorithm: #SESSION_VARIABLE


@ObjectModel.usageType: {
  dataClass: #MIXED,
  serviceQuality: #C,
  sizeCategory: #S
}

@EndUserText.label: 'Hierarchy Version to Be Update'
define view FAC_CDS_UH_VSRN_TO_UPDATE
  as select distinct from uhdt_notif as notif
    inner join            uhdt_vrsn  as vrsn  on notif.ver_id = vrsn.ver_id
    left outer join       uhdt_hier  as hier  on  vrsn.hier_hid  = hier.hier_hid
                                              and vrsn.hier_catg = hier.hier_catg
                                              and hier.lang      = $session.system_language
    left outer join       uhdt_catgt as catgt on  vrsn.hier_catg = catgt.catg_key
                                              and catgt.lang     = $session.system_language
    left outer join       uhdt_betyt as betyt on  betyt.bety_name = notif.bety_name
                                              and betyt.lang      = $session.system_language
  association [1..1] to fac_cds_uh_category as to_category on $projection.HierarchyCategory = to_category.CategoryKey
  association [1..1] to fac_cds_uh_version  as to_version  on $projection.VersionId = to_version.VersionId
{
  key notif.ver_id                                                                                                           as VersionId,
      vrsn.hier_catg                                                                                                         as HierarchyCategory,
      catgt.catg_text                                                                                                        as CategoryText,
      vrsn.hier_hid                                                                                                          as HierarchyId,
      to_category.BusinessEntityName                                                                                         as BusinessEntityName,
      case
      when betyt.bety_text is null
      then notif.bety_name
      else betyt.bety_text end                                                                                               as BusinessEntityText,
      hier.hier_desc                                                                                                         as HierarchyDescription,
      vrsn.ver_vldfm                                                                                                         as ValidFrom,
      vrsn.ver_vldto                                                                                                         as ValidTo,
      to_version.VersionStatus                                                                                               as VersionStatus,
      to_version.CreatedOn                                                                                                   as CreatedOn,
      to_category
}

Learn More