FAC_DART_Z3_FSV_Node

DDL: FAC_DART_Z3_FSV_NODE SQL: FAC_DZFSVN Type: view Package: FINS_FI_DART_Z3

Financial Statement Hierarchy Node

FAC_DART_Z3_FSV_Node is a CDS View that provides data about "Financial Statement Hierarchy Node" in SAP S/4HANA. It reads from 3 data sources (hrrp_node_n, hrrp_nodet_n, hrrp_node_n) and exposes 9 fields with key fields FinancialStatementHierarchy, ValidityEndDate. Part of development package FINS_FI_DART_Z3.

3 data source(s) 9 fields

Data Sources (3)

SourceAliasJoin Type
hrrp_node_n hrrp_node_n from
hrrp_nodet_n hrrp_nodet_n left_outer
hrrp_node_n parent left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FAC_DZFSVN view
EndUserText.label Financial Statement Hierarchy Node view
AbapCatalog.buffering.status #NOT_ALLOWED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY FinancialStatementHierarchy hrrp_node_n hryid_42
KEY ValidityEndDate hrrp_node_n hryvalto
ValidityStartDate hrrp_node_n hryvalfrom
HierarchyNode hrrp_node_n nodevalue
ParentNode hrrp_node_n nodevalue
HierarchyNodeText hrrp_nodet_n nodetxt
SequenceNumber hrrp_node_n hryseqnbr
HierarchyLevel hrrp_node_n hrylevel
ChartOfAccountsOnGLAcc hrrp_node_n nodecls 
@AbapCatalog.sqlViewName: 'FAC_DZFSVN'
@EndUserText.label: 'Financial Statement Hierarchy Node'
@AbapCatalog.buffering.status: #NOT_ALLOWED
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #C
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
define view FAC_DART_Z3_FSV_Node
  as select from    hrrp_node_n
    left outer join hrrp_node_n as parent on  hrrp_node_n.hryid_42 = parent.hryid_42
                                          and hrrp_node_n.hryvalto = parent.hryvalto
                                          and hrrp_node_n.hryvalto = parent.hryvalto
                                          and hrrp_node_n.parnode  = parent.hrynode
    left outer join hrrp_nodet_n          on  hrrp_node_n.hryid_42 = hrrp_nodet_n.hryid_42
                                          and hrrp_node_n.hryvalto = hrrp_nodet_n.hryvalto
                                          and hrrp_node_n.nodecls  = hrrp_nodet_n.nodecls
                                          and hrrp_node_n.hrynode  = hrrp_nodet_n.hrynode
                                          and hrrp_node_n.parnode  = hrrp_nodet_n.parnode
                                          and hrrp_nodet_n.spras   = $session.system_language

{

  key  hrrp_node_n.hryid_42   as FinancialStatementHierarchy,
       @Semantics.businessDate.to: true
  key  hrrp_node_n.hryvalto   as ValidityEndDate,
       @Semantics.businessDate.from: true
       hrrp_node_n.hryvalfrom as ValidityStartDate,
       @EndUserText.label: 'Node Type'
       case hrrp_node_n.nodetype
        when 'L' then case when hrrp_node_n.nodecls is not initial then 'GL Account'  else 'Functional Area' end
        else 'Item'
       end                    as NodeType,
       hrrp_node_n.nodevalue  as HierarchyNode,
       parent.nodevalue       as ParentNode,
       hrrp_nodet_n.nodetxt   as HierarchyNodeText,
       hrrp_node_n.hryseqnbr  as SequenceNumber,
       hrrp_node_n.hrylevel   as HierarchyLevel,
       hrrp_node_n.nodecls    as ChartOfAccountsOnGLAcc
}
where
      hrrp_node_n.nodetype <> 'D'
  and hrrp_node_n.nodetype <> 'V'
  and hrrp_node_n.nodetype <> 'J'
  and hrrp_node_n.nodetype <> 'B'
  and hrrp_node_n.parnode  <> '00NOTASSGND'

Learn More