I_SemTagGLAccount

DDL: I_SEMTAGGLACCOUNT SQL: IFISEMTAGGLACCT Type: view BASIC Package: FINS_FI_SEM_TAG

G/L Account with Semantic Tag

I_SemTagGLAccount is a Basic CDS View (Cube) that provides data about "G/L Account with Semantic Tag" in SAP S/4HANA. It has 1 association to related views. Part of development package FINS_FI_SEM_TAG.

14 fields

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_GLAccountHierarchyNode _GLAccountHierarchyNode $projection.GLAccountHierarchy = _GLAccountHierarchyNode.GLAccountHierarchy and $projection.HierarchyNode = _GLAccountHierarchyNode.HierarchyNode

Annotations (14)

NameValueLevelField
EndUserText.label G/L Account with Semantic Tag view
AbapCatalog.sqlViewName IFISEMTAGGLACCT view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
Analytics.dataCategory #CUBE view
Analytics.dataExtraction.enabled true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.sapObjectNodeType.name SemanticTagGeneralLedger view

Fields (14)

KeyFieldSource TableSource FieldDescription
GLAccountHierarchy GLAccountHierarchy
HierarchyNode
SemanticTag SemanticTag
ValidityEndDate ValidityEndDate
ValidityStartDate ValidityStartDate
ChartOfAccounts ChartOfAccounts
GLAccount GLAccount
FunctionalAreaIsUsed FunctionalAreaIsUsed
IsFunctionalAreaPermitted
_Hierarchy _Hierarchy
_GLAccountHierarchyNode _GLAccountHierarchyNode
_SemanticTag _SemanticTag
_ChartOfAccounts _ChartOfAccounts
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 
@EndUserText.label: 'G/L Account with Semantic Tag'
@AbapCatalog.sqlViewName: 'IFISEMTAGGLACCT'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@Analytics: { dataCategory: #CUBE,
              dataExtraction.enabled: true
            }
//@ObjectModel.representativeKey: 'SemanticTag'

@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.modelingPattern: #ANALYTICAL_CUBE
@ObjectModel.supportedCapabilities: [ #ANALYTICAL_PROVIDER,
                                      #SQL_DATA_SOURCE,
                                      #CDS_MODELING_DATA_SOURCE,
                                      #CDS_MODELING_ASSOCIATION_TARGET,
                                      #EXTRACTION_DATA_SOURCE]
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions:true
@ObjectModel.sapObjectNodeType.name:'SemanticTagGeneralLedger'

define view I_SemTagGLAccount
  as select distinct from P_SemTagGLAccount

  association [0..*] to I_GLAccountHierarchyNode as _GLAccountHierarchyNode on  $projection.GLAccountHierarchy = _GLAccountHierarchyNode.GLAccountHierarchy
                                                                            and $projection.HierarchyNode      = _GLAccountHierarchyNode.HierarchyNode

{
  @ObjectModel.foreignKey.association: '_Hierarchy'
  GLAccountHierarchy,
  cast ( '' as hrynode )                                                                          as HierarchyNode,
  @ObjectModel.foreignKey.association: '_SemanticTag'
  SemanticTag,
  @Semantics.businessDate.to: true
  ValidityEndDate,
  @Semantics.businessDate.from: true
  ValidityStartDate,
  @ObjectModel.foreignKey.association: '_ChartOfAccounts'
  ChartOfAccounts,
  @ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
  GLAccount,
  FunctionalAreaIsUsed,
  cast( case when SemanticTag = 'NTINC_ALAC' then '' else FunctionalAreaIsUsed end as xfber_011 ) as IsFunctionalAreaPermitted,
  _Hierarchy,
  //OBSOLETING, DO NOT USE THIS ASSOCIATION!!!

  _GLAccountHierarchyNode,
  _SemanticTag,
  _ChartOfAccounts,
  _GLAccountInChartOfAccounts

}

Learn More