I_UniversalHierVersion

DDL: I_UNIVERSALHIERVERSION SQL: IUHVRSN Type: view BASIC

Universal Hierarchy Version

I_UniversalHierVersion is a Basic CDS View that provides data about "Universal Hierarchy Version" in SAP S/4HANA. It reads from 2 data sources (uhdt_catg, uhdt_vrsn) and exposes 21 fields with key field UniversalHierarchyVersionID. It has 3 associations to related views.

2 data source(s) 21 fields

Data Sources (2)

SourceAliasJoin Type
uhdt_catg uhdt_catg left_outer
uhdt_vrsn uhdt_vrsn from

Associations (3)

CardinalityTargetAliasCondition
[1..*] I_UniversalHierNode _Node $projection.UniversalHierarchyVersionID = _Node.UniversalHierarchyVersionID
[0..*] I_UniversalHierClassFieldVal _ClFdValue $projection.UniversalHierarchyVersionID = _ClFdValue.UniversalHierObjectID
[1..*] I_UniversalHierHierarchy _Hierarchy $projection.UniversalHierHierarchyID = _Hierarchy.UniversalHierHierarchyID and $projection.UniversalHierHierarchyType = _Hierarchy.UniversalHierHierarchyType

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IUHVRSN view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Universal Hierarchy Version view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY UniversalHierarchyVersionID ver_id
UniversalHierVersParentID ver_pid
UniversalHierVersStatus ver_status
UniversalHierVersValidFrom ver_vldfm
UniversalHierVersValidTo ver_vldto
UniversalHierVersMsg ver_msg
UniversalHierVersNumber ver_nbr
UniversalHierVersIndex ver_idx
UniversalHierHierarchyID hier_hid
UniversalHierHierarchyType hier_catg
UniversalHierVersUpdatedAt updated_at
UniversalHierVersUpdatedBy updated_by
UniversalHierVersCreatedAt created_at
UniversalHierVersCreatedBy created_by
UniversalHierVersLockedBy locked_by
UniversalHierVersLockedAt locked_at
UniversalHierVersIsAllowLegacy uhdt_vrsn allow_legacy_tcode_usage
HierarchyType uhdt_catg hrrp_hrytype
_ClFdValue _ClFdValue
_Node _Node
_Hierarchy _Hierarchy 
@AbapCatalog.sqlViewName: 'IUHVRSN'

@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations:  [ '_node' ] 
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Universal Hierarchy Version'

@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: {
  dataClass: #TRANSACTIONAL,
  serviceQuality: #B,
  sizeCategory: #S
}
define view I_UniversalHierVersion
  as select from    uhdt_vrsn
  left outer join uhdt_catg on uhdt_vrsn.hier_catg = uhdt_catg.catg_key
                              
  association [1..*] to I_UniversalHierNode     as _Node       on $projection.UniversalHierarchyVersionID = _Node.UniversalHierarchyVersionID
  association [0..*] to I_UniversalHierClassFieldVal as _ClFdValue on $projection.UniversalHierarchyVersionID = _ClFdValue.UniversalHierObjectID
  association [1..*] to I_UniversalHierHierarchy as _Hierarchy on $projection.UniversalHierHierarchyID = _Hierarchy.UniversalHierHierarchyID
                                                              and $projection.UniversalHierHierarchyType = _Hierarchy.UniversalHierHierarchyType
{
  key ver_id                       as  UniversalHierarchyVersionID,
      ver_pid                      as  UniversalHierVersParentID,
      ver_status                   as  UniversalHierVersStatus,
      
      @Semantics.businessDate.from: true
      ver_vldfm                    as  UniversalHierVersValidFrom,
      
      @Semantics.businessDate.to: true
      ver_vldto                    as  UniversalHierVersValidTo,
      ver_msg                      as  UniversalHierVersMsg,
      ver_nbr                      as  UniversalHierVersNumber,
      ver_idx                      as  UniversalHierVersIndex,
      hier_hid                     as  UniversalHierHierarchyID,
      hier_catg                    as  UniversalHierHierarchyType,
      updated_at                   as  UniversalHierVersUpdatedAt,
      updated_by                   as  UniversalHierVersUpdatedBy,
      created_at                   as  UniversalHierVersCreatedAt,
      created_by                   as  UniversalHierVersCreatedBy,
      locked_by                    as  UniversalHierVersLockedBy,
      locked_at                    as  UniversalHierVersLockedAt,
      uhdt_vrsn.allow_legacy_tcode_usage     as  UniversalHierVersIsAllowLegacy,
      uhdt_catg.hrrp_hrytype       as  HierarchyType,
      _ClFdValue,
      _Node,
      _Hierarchy
}

Learn More