I_SemTagGLAccountHierarchy

DDL: I_SEMTAGGLACCOUNTHIERARCHY SQL: IFISTGLACCOUNTH Type: view BASIC

General Ledger Account Hierarchy

I_SemTagGLAccountHierarchy is a Basic CDS View (Dimension) that provides data about "General Ledger Account Hierarchy" in SAP S/4HANA. It reads from 1 data source (I_GLAccountHierarchy) and exposes 8 fields with key fields GLAccountHierarchy, ValidityEndDate. It has 1 association to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_GLAccountHierarchy I_GLAccountHierarchy from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_GLAccountHierarchyText _Text $projection.GLAccountHierarchy = _Text.GLAccountHierarchy and $projection.ValidityEndDate = _Text.ValidityEndDate

Annotations (18)

NameValueLevelField
EndUserText.label General Ledger Account Hierarchy view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
VDM.viewType #BASIC view
Metadata.allowExtensions true view
AbapCatalog.sqlViewName IFISTGLACCOUNTH view
ObjectModel.representativeKey GLAccountHierarchy view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
Search.searchable true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY GLAccountHierarchy GLAccountHierarchy
KEY ValidityEndDate ValidityEndDate
ValidityStartDate ValidityStartDate
HierarchyType HierarchyType
LastChangedByUser LastChangedByUser
LastChangeTime LastChangeTime
LastChangeDateTime LastChangeDateTime
_Text _Text 
@EndUserText.label: 'General Ledger Account Hierarchy'
@Analytics: { dataCategory: #DIMENSION,
              internalName: #LOCAL }
@VDM.viewType: #BASIC
@Metadata.allowExtensions:true
@AbapCatalog.sqlViewName: 'IFISTGLACCOUNTH'
@ObjectModel.representativeKey: 'GLAccountHierarchy'
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.preserveKey:true
@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.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE]

define view I_SemTagGLAccountHierarchy
  as select from I_GLAccountHierarchy
  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 GLAccountHierarchy,

      @Semantics.businessDate.to: true
  key ValidityEndDate,
      @Semantics.businessDate.from: true
      ValidityStartDate,
      HierarchyType,
      @Semantics.user.lastChangedBy: true
      LastChangedByUser,
      @API.element.releaseState: #DEPRECATED
      @VDM.lifecycle.status:    #DEPRECATED
      @API.element.successor:   'LastChangeDateTime'
      @VDM.lifecycle.successor: 'LastChangeDateTime'
      LastChangeTime,
      @Semantics.systemDateTime.lastChangedAt: true
      LastChangeDateTime,
      _Text

}
where
  SemanticTagIsUsed is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNTHIERARCHY"
],
"ASSOCIATED":
[
"I_GLACCOUNTHIERARCHYTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More