I_GLACCOUNTHIERARCHY

CDS View

General Ledger Account Hierarchy

I_GLACCOUNTHIERARCHY is a CDS View in S/4HANA. General Ledger Account Hierarchy. 4 CDS views read from this table.

Used by 4 CDS view(s)

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_GLAccountHierarchyNode view inner CONSUMPTION API GL Acccount Hierarchy Node
I_GLAccountHierarchyStdVH view from COMPOSITE General Ledger Account Hierarchy
I_GLAcctHierNodeSemanticTag view inner BASIC GL Account Hierarchy Node with Semantic Tag
I_SemTagGLAccountHierarchy view from BASIC General Ledger Account Hierarchy 
@EndUserText.label: 'General Ledger Account Hierarchy'
@Analytics: { dataCategory: #DIMENSION }
@VDM.viewType: #BASIC
@Metadata.allowExtensions:true
@AbapCatalog.sqlViewName: 'IFIGLACCOUNTH'
@ObjectModel.representativeKey: 'GLAccountHierarchy'
@AbapCatalog.buffering.status: #NOT_ALLOWED
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #CHECK
@Search.searchable: true
@ObjectModel.supportedCapabilities:[#CDS_MODELING_DATA_SOURCE,#SEARCHABLE_ENTITY,#EXTRACTION_DATA_SOURCE]
@Analytics.dataExtraction.enabled: true
define view I_GLAccountHierarchy
  as select from hrrp_dir_n
  association [0..*] to I_GLAccountHierarchyText as _Text on  $projection.GLAccountHierarchy = _Text.GLAccountHierarchy
                                                          and $projection.ValidityEndDate    = _Text.ValidityEndDate

{
       @ObjectModel.text.association: '_Text'
       @Search.defaultSearchElement:true
       @Search.fuzzinessThreshold:0.8
       @Search.ranking:#HIGH
  key  cast ( hrrp_dir_n.hryid_42 as fis_glaccthier preserving type ) as GLAccountHierarchy,
       @Semantics.businessDate.to: true
  key  hrrp_dir_n.hryvalto                                            as ValidityEndDate,
       @Semantics.businessDate.from: true
       hrrp_dir_n.hryvalfrom                                          as ValidityStartDate,
       hrrp_dir_n.hrytyp                                              as HierarchyType,
       @Semantics.user.lastChangedBy: true
       hrrp_dir_n.upduser                                             as LastChangedByUser,
       @VDM.lifecycle.status:    #DEPRECATED
       @API.element.releaseState: #DEPRECATED
       @API.element.successor:   'LastChangeDateTime'
       @VDM.lifecycle.successor: 'LastChangeDateTime'
       hrrp_dir_n.updtime                                             as LastChangeTime,
       @Semantics.systemDateTime.lastChangedAt: true
       hrrp_dir_n.updtime                                             as LastChangeDateTime,
       hrrp_dir_n.hrysid                                              as HierarchyShortID,
       hrrp_dir_n.funareaassigned                                     as FunctionalAreaIsUsed,
       hrrp_dir_n.semtagassigned                                      as SemanticTagIsUsed,

       _Text

}
where
          hrrp_dir_n.hrytyp    =  'FSVN'
  and(
          hrrp_dir_n.aging     is null
    or    hrrp_dir_n.aging     =  ''
  )
  and(
          hrrp_dir_n.hrysource =  'UH'
    or(
          hrrp_dir_n.hrysource <> 'UH'
      and hrrp_dir_n.hryvalto  =  '99991231'
    )
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"HRRP_DIR_N"
],
"ASSOCIATED":
[
"I_GLACCOUNTHIERARCHYTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More