P_BalExpsrKeyFigHierNode

@AbapCatalog.sqlViewName: 'PBALHIERN'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_BalExpsrKeyFigHierNode as select from fxm_kf_def
{
  key concat(  'KF', kf ) as  HierarchyNode,
      concat(  'GR', kf_group ) as ParentNode,
      @Semantics.text: true
      kf_text  as HierarchyNodeText,      
      kf as BalSheetExpsrKeyFigure
}
union all select from fxm_kf_grp_def
{
  concat(  'GR', kf_group ) as  HierarchyNode,
  exposure_or_hedge as ParentNode,
       @Semantics.text: true
  kf_group_text     as HierarchyNodeText,
  '' as BalSheetExpsrKeyFigure
  
} union all
// Select Exposure Node from Domain Fixed Value

select from dd07t {
  $session.client as mandt,
  'E'  as HierarchyNode,
  '' as ParentNode,
  ddtext as HierarchyNodeText,
  '' as BalSheetExpsrKeyFigure
} where ddlanguage = $session.system_language and valpos = '0001' and as4local = 'A' and domname = 'FXM_EXPOSURE_HEDGE_INDICATOR'
union all
// select Hedge Node from Domain fixed value

select from dd07t {
  $session.client as mandt,
  'H'  as HierarchyNode,
  '' as ParentNode,
  ddtext as HierarchyNodeText,
  '' as BalSheetExpsrKeyFigure
} where ddlanguage = $session.system_language and valpos = '0002' and as4local = 'A' and domname = 'FXM_EXPOSURE_HEDGE_INDICATOR'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T",
"FXM_KF_DEF",
"FXM_KF_GRP_DEF"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/