I_FINANCIALSTATEMENTHIERNODE

CDS View

Financial Statement Hierarchy Node

I_FINANCIALSTATEMENTHIERNODE is a CDS View in S/4HANA. Financial Statement Hierarchy Node. It contains 14 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 14 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_AT_AstAcqnDownPaymentC view_entity inner CONSUMPTION AT Asst Acqn and Down Payment - Cube
I_BalShtIncStatementHierNode view_entity from BASIC Balance Sheet Hierarchy Node
I_FinancialStatementStructure view inner COMPOSITE Financial Statement Version Structure
P_GLAccountInCOAHierarchy view_entity inner COMPOSITE GL Account in Chart of Accounts Hierarchy

Fields (14)

KeyField CDS FieldsUsed in Views
KEY HierarchyNode FinancialStatementItem,HierarchyNode 3
KEY ParentNode ParentNode,ParentNodeUniqueID 3
DebitCreditCode DebitCreditCode 1
FinancialStatementHierarchy FinancialStatementHierarchy 1
FinancialStatementLeafItem FinancialStatementLeafItem 1
FinancialStatementNodeType FinancialStatementNodeType,NodeType 3
FinStmntNodeFormattedID FinStmntNodeFormattedID 1
HierarchyLevel HierarchyLevel 3
HierarchyNodeSequence HierarchyNodeSequence,SiblingNode 3
HierarchyNodeVal HierarchyNodeVal 1
HierarchyVersion HierarchyVersion 1
SignIsInverted SignIsInverted 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 1 
@AbapCatalog.sqlViewName: 'IFISTMTHERNODE'
@EndUserText.label: 'Financial Statement Hierarchy Node'
@VDM.viewType: #BASIC
@ObjectModel: { dataCategory: #HIERARCHY }
@ObjectModel.representativeKey: 'HierarchyNode'
@Hierarchy.parentChild:
{
  recurse:
    {
        parent: 'ParentNode',
        child:  'HierarchyNode'
     },
  siblingsOrder:
    {
        by: 'HierarchyNodeSequence',
        direction: 'ASC'
    },
  directory: '_Hierarchy'
  }
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.buffering.status: #NOT_ALLOWED
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #ANALYTICAL_PARENT_CHILD_HIERARCHY_NODE
@ObjectModel.supportedCapabilities: [#CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET,#ANALYTICAL_PARENT_CHILD_HIERARCHY_NODE, #EXTRACTION_DATA_SOURCE]
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.preserveKey:true
@Analytics.dataExtraction.enabled: true
@ObjectModel.sapObjectNodeType.name:'FinancialStatementHierNode'

define view I_FinancialStatementHierNode
  as select from P_FinancialStatementHierNode
  association [0..*] to I_FinancialStatementHierNodeT as _Text                       on  $projection.FinancialStatementHierarchy = _Text.FinancialStatementHierarchy
                                                                                     and $projection.HierarchyNode               = _Text.HierarchyNode
                                                                                     and $projection.FinancialStatementLeafItem  = '' // just to show that this association is only to be followed if GLAcount is blank


  association [0..1] to I_FinancialStatementLeafItem  as _FinancialStatementLeafItem on  $projection.FinancialStatementLeafItem = _FinancialStatementLeafItem.FinancialStatementLeafItem

  association [0..1] to I_FinancialStatementHier      as _Hierarchy                  on  $projection.FinancialStatementHierarchy = _Hierarchy.FinancialStatementHierarchy
                                                                                     and $projection.ValidityEndDate             = _Hierarchy.ValidityEndDate // Hierarchy directory and hierarchy nodes have the same time slice


  association [0..1] to I_FinancialStatementHierNode  as _ParentNode                 on  $projection.FinancialStatementHierarchy = _ParentNode.FinancialStatementHierarchy
                                                                                     and $projection.ValidityEndDate             = _ParentNode.ValidityEndDate
                                                                                     and $projection.ParentNode                  = _ParentNode.HierarchyNode


{

       @Consumption.filter: {mandatory : true, selectionType : #SINGLE, multipleSelections : false }
       @ObjectModel.foreignKey.association: '_Hierarchy'
  key  FinancialStatementHierarchy,
       @ObjectModel.text.association: '_Text'
  key  HierarchyNode,
       @Semantics.businessDate.to: true
       @Consumption.filter: {mandatory : true, selectionType : #SINGLE, multipleSelections : false }
  key  ValidityEndDate,
       @Semantics.businessDate.from: true
       ValidityStartDate,


       ParentNode,
       HierarchyVersion,
       @ObjectModel.foreignKey.association: '_FinancialStatementLeafItem'
       FinancialStatementLeafItem,
       SequenceNumber, // used for sorting

       @Semantics.signReversalIndicator: true
       SignIsInverted,
       ChartOfAccounts,
       FinancialStatementNodeType,
       @Analytics.dataExtraction.relevant: true
       FinStmntNodeFormattedID,
       HierarchyNodeVal,
       HierarchyNodeSequence, //sequence in num6

       HierarchyLevel,
       DebitCreditCode,
       _Text,
       _FinancialStatementLeafItem,
       _Hierarchy,
       _ParentNode

}

Learn More