FIISAL_GR_GLACCTHIERDETAIL2

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Greece GLAccount global hierarchy detail'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #L,
  dataClass: #MIXED
}
define view entity FIISAL_GR_GLACCTHIERDETAIL2

  as select from    I_GLAccountInCompanyCode
    inner join      FIISAL_GR_GLAcctGlobHier2 as hier on  I_GLAccountInCompanyCode.GLAccount = hier.UniversalHierNodeLowValue
                                                      and hier.UniversalHierNodeLevel        is not initial
    left outer join uhdt_ntxt                 as ntxt on  hier.UniversalHierNodeID = ntxt.node_id
                                                      and ntxt.lang                = $session.system_language

{
  I_GLAccountInCompanyCode.CompanyCode,
  I_GLAccountInCompanyCode.GLAccount,
  I_GLAccountInCompanyCode.AlternativeGLAccount,
  hier.UniversalHierHierarchyID,
  hier.UniversalHierHierarchyType,
  hier.UniversalHierNodeLevel                                                   as UniversalHierNodeLevel,
  hier.UniversalHierNodeLowValue                                                as UniversalHierNodeLowValue,
  hier.UniversalHierNodeID                                                      as UniversalHierNodeID,
  hier.UniversalHierNodeParentID                                                as UniversalHierNodeParentID,
  ntxt.lval_txt                                                                 as UniversalHierNodeLowValueTxt,

  case when hier.NodeTypeStage1 <> 'R' then hier.NodeLowValueStage1 else '' end as HierarchyParentNodeVal

}


union select from I_GLAccountInCompanyCode
  inner join      FIISAL_GR_GLAcctGlobHier2 as hier on  I_GLAccountInCompanyCode.GLAccount = hier.UniversalHierNodeLowValue
                                                    and hier.NodeLevelStage1               is not initial
  left outer join uhdt_ntxt                 as ntxt on  hier.UniversalHierNodeID = ntxt.node_id
                                                    and ntxt.lang                = $session.system_language


{
  I_GLAccountInCompanyCode.CompanyCode,
  I_GLAccountInCompanyCode.GLAccount,
  I_GLAccountInCompanyCode.AlternativeGLAccount,
  hier.UniversalHierHierarchyID,
  hier.UniversalHierHierarchyType,
  hier.NodeLevelStage1                                                          as UniversalHierNodeLevel,
  hier.NodeLowValueStage1                                                       as UniversalHierNodeLowValue,
  hier.NodeIDStage1                                                             as UniversalHierNodeID,
  hier.HierNodeParentID1                                                        as UniversalHierNodeParentID,
  ntxt.lval_txt                                                                 as UniversalHierNodeLowValueTxt,

  case when hier.NodeTypeStage2 <> 'R' then hier.NodeLowValueStage2 else '' end as HierarchyParentNodeVal

}

union select from I_GLAccountInCompanyCode
  inner join      FIISAL_GR_GLAcctGlobHier2 as hier on  I_GLAccountInCompanyCode.GLAccount = hier.UniversalHierNodeLowValue
                                                    and hier.NodeLevelStage2               is not initial
  left outer join uhdt_ntxt                 as ntxt on  hier.UniversalHierNodeID = ntxt.node_id
                                                    and ntxt.lang                = $session.system_language

{
  I_GLAccountInCompanyCode.CompanyCode,
  I_GLAccountInCompanyCode.GLAccount,
  I_GLAccountInCompanyCode.AlternativeGLAccount,
  hier.UniversalHierHierarchyID,
  hier.UniversalHierHierarchyType,
  hier.NodeLevelStage2                                                          as UniversalHierNodeLevel,
  hier.NodeLowValueStage2                                                       as UniversalHierNodeLowValue,
  hier.NodeIDStage2                                                             as UniversalHierNodeID,
  hier.HierNodeParentID2                                                        as UniversalHierNodeParentID,
  ntxt.lval_txt                                                                 as UniversalHierNodeLowValueTxt,

  case when hier.NodeTypeStage3 <> 'R' then hier.NodeLowValueStage3 else '' end as HierarchyParentNodeVal
}

union select from I_GLAccountInCompanyCode
  inner join      FIISAL_GR_GLAcctGlobHier2 as hier on  I_GLAccountInCompanyCode.GLAccount = hier.UniversalHierNodeLowValue
                                                    and hier.NodeLevelStage3               is not initial
  left outer join uhdt_ntxt                 as ntxt on  hier.UniversalHierNodeID = ntxt.node_id
                                                    and ntxt.lang                = $session.system_language

{
  I_GLAccountInCompanyCode.CompanyCode,
  I_GLAccountInCompanyCode.GLAccount,
  I_GLAccountInCompanyCode.AlternativeGLAccount,
  hier.UniversalHierHierarchyID,
  hier.UniversalHierHierarchyType,
  hier.NodeLevelStage3                                                          as UniversalHierNodeLevel,
  hier.NodeLowValueStage3                                                       as UniversalHierNodeLowValue,
  hier.NodeIDStage3                                                             as UniversalHierNodeID,
  hier.HierNodeParentID3                                                        as UniversalHierNodeParentID,
  ntxt.lval_txt                                                                 as UniversalHierNodeLowValueTxt,
  case when hier.NodeTypeStage4 <> 'R' then hier.NodeLowValueStage4 else '' end as HierarchyParentNodeVal

}

union select from I_GLAccountInCompanyCode
  inner join      FIISAL_GR_GLAcctGlobHier2 as hier on  I_GLAccountInCompanyCode.GLAccount = hier.UniversalHierNodeLowValue
                                                    and hier.NodeLevelStage4               is not initial
  left outer join uhdt_ntxt                 as ntxt on  hier.UniversalHierNodeID = ntxt.node_id
                                                    and ntxt.lang                = $session.system_language


{
  I_GLAccountInCompanyCode.CompanyCode,
  I_GLAccountInCompanyCode.GLAccount,
  I_GLAccountInCompanyCode.AlternativeGLAccount,
  hier.UniversalHierHierarchyID,
  hier.UniversalHierHierarchyType,
  hier.NodeLevelStage4                                                          as UniversalHierNodeLevel,
  hier.NodeLowValueStage4                                                       as UniversalHierNodeLowValue,
  hier.NodeIDStage4                                                             as UniversalHierNodeID,
  hier.HierNodeParentID4                                                        as UniversalHierNodeParentID,
  ntxt.lval_txt                                                                 as UniversalHierNodeLowValueTxt,
  case when hier.NodeTypeStage5 <> 'R' then hier.NodeLowValueStage5 else '' end as HierarchyParentNodeVal

}

union select from I_GLAccountInCompanyCode
  inner join      FIISAL_GR_GLAcctGlobHier2 as hier on  I_GLAccountInCompanyCode.GLAccount = hier.UniversalHierNodeLowValue
                                                    and hier.NodeLevelStage5               is not initial
  left outer join uhdt_ntxt                 as ntxt on  hier.UniversalHierNodeID = ntxt.node_id
                                                    and ntxt.lang                = $session.system_language

{
  I_GLAccountInCompanyCode.CompanyCode,
  I_GLAccountInCompanyCode.GLAccount,
  I_GLAccountInCompanyCode.AlternativeGLAccount,
  hier.UniversalHierHierarchyID,
  hier.UniversalHierHierarchyType,
  hier.NodeLevelStage5                                                          as UniversalHierNodeLevel,
  hier.NodeLowValueStage5                                                       as UniversalHierNodeLowValue,
  hier.NodeIDStage5                                                             as UniversalHierNodeID,
  hier.HierNodeParentID5                                                        as UniversalHierNodeParentID,
  ntxt.lval_txt                                                                 as UniversalHierNodeLowValueTxt,
  case when hier.NodeTypeStage6 <> 'R' then hier.NodeLowValueStage6 else '' end as HierarchyParentNodeVal
}

union select from I_GLAccountInCompanyCode
  inner join      FIISAL_GR_GLAcctGlobHier2 as hier on  I_GLAccountInCompanyCode.GLAccount = hier.UniversalHierNodeLowValue
                                                    and hier.NodeLevelStage6               is not initial
  left outer join uhdt_ntxt                 as ntxt on  hier.UniversalHierNodeID = ntxt.node_id
                                                    and ntxt.lang                = $session.system_language

{
  I_GLAccountInCompanyCode.CompanyCode,
  I_GLAccountInCompanyCode.GLAccount,
  I_GLAccountInCompanyCode.AlternativeGLAccount,
  hier.UniversalHierHierarchyID,
  hier.UniversalHierHierarchyType,
  hier.NodeLevelStage6    as UniversalHierNodeLevel,
  hier.NodeLowValueStage6 as UniversalHierNodeLowValue,
  hier.NodeIDStage6       as UniversalHierNodeID,
  hier.HierNodeParentID6  as UniversalHierNodeParentID,
  ntxt.lval_txt           as UniversalHierNodeLowValueTxt,
  ''                      as HierarchyParentNodeVal

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