R_FinWBSElementHierarchy

/* This view selects only fro HRRP_DIRECTORY and does not consider WBSElementStructure */
@AbapCatalog.sqlViewName: 'RFIWBSELEMENTH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE 
@Analytics: { dataCategory: #DIMENSION }
@Analytics.internalName:#LOCAL
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@EndUserText.label: 'Hierarchy of WBS Element'
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
//@Analytics.dataExtraction.enabled: true

@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #A,
  sizeCategory: #XL
}
@ObjectModel.representativeKey: 'WBSElementHierarchy'
//@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION

//@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #ANALYTICAL_DIMENSION ]


define view R_FinWBSElementHierarchy as select from hrrp_dir_n
//     inner join hrrp_node on hrrp_directory.hryid = hrrp_node.hryid and 

//                             hrrp_directory.hryver = hrrp_node.hryver and 

//                             hrrp_directory.hryvalto = hrrp_node.hryvalto and 

//                             hrrp_node.nodetype = 'R'

  
  association [0..*] to R_FinWBSElementHierarchyText as _Text         on  $projection.WBSElementHierarchy = _Text.WBSElementHierarchy
{   
      @ObjectModel.text.association: '_Text'
  key cast ( hrrp_dir_n.hryid_42 as fis_finwbshier preserving type )  as WBSElementHierarchy,
  
      @Semantics.businessDate.to: true
  key cast(hrrp_dir_n.hryvalto as fis_datbi preserving type)       as ValidityEndDate,
      @Semantics.businessDate.from: true
      cast(hrrp_dir_n.hryvalfrom as fis_datab preserving type)     as ValidityStartDate,
      cast ( hrrp_dir_n.hrytyp as hrytype preserving type)                        as HierarchyType,
      @Semantics.user.lastChangedBy: true
      hrrp_dir_n.upduser                                           as LastChangedByUser,
//      @Semantics.systemDateTime.lastChangedAt: true

//      hrrp_directory.updtime                                           as LastChangeTime,

      _Text
}
where
  hrrp_dir_n.hrytyp = '0110'   // WBS Element Hierarchy

  

  

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"HRRP_DIR_N"
],
"ASSOCIATED":
[
"R_FINWBSELEMENTHIERARCHYTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/