P_FINANCIALSTATEMENTHIERNODE
P_FINANCIALSTATEMENTHIERNODE is a CDS View in S/4HANA. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_FinancialStatementHierNode | view | from | BASIC | Financial Statement Hierarchy Node |
@AbapCatalog.sqlViewName: 'PFISTMTHIRND'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private:true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_FinancialStatementHierNode
as select from hrrp_node_n
{
key hrrp_node_n.hryid_42 as FinancialStatementHierarchy,
key hrrp_node_n.hrynode as HierarchyNode,
key hrrp_node_n.hryvalto as ValidityEndDate,
cast(hrrp_node_n.hryvalfrom as fis_datab preserving type ) as ValidityStartDate,
hrrp_node_n.parnode as ParentNode,
@VDM.lifecycle.status: #DEPRECATED
cast('000000000000001' as hryversn ) as HierarchyVersion,
hrrp_node_n.nodecls as ChartOfAccounts,
hrrp_node_n.nodetype as NodeType,
cast( hrrp_node_n.fs_leafitem as hrynode preserving type ) as FinancialStatementLeafItem,
hrrp_node_n.fs_nodetype as FinancialStatementNodeType,
hrrp_node_n.hrynodeext as FinStmntNodeFormattedID,
concat(hrrp_node_n.hryseqnbr, hrrp_node_n.hrynode) as SequenceNumber,
cast(hrrp_node_n.sign as hryattrvalue ) as SignIsInverted,
hrrp_node_n.nodevalue as HierarchyNodeVal,
hrrp_node_n.hryseqnbr as HierarchyNodeSequence, //sequence in num6
hrrp_node_n.hrylevel as HierarchyLevel,
hrrp_node_n.balind as DebitCreditCode
}
where
(
hrrp_node_n.nodetype = 'R'
or hrrp_node_n.nodetype = 'N'
or hrrp_node_n.nodetype = 'L'
or hrrp_node_n.nodetype = 'O'
or hrrp_node_n.nodetype = 'M'
or hrrp_node_n.nodetype = 'K'
or hrrp_node_n.nodetype = 'A'
)
and hrrp_node_n.hrytyp = 'FSVN'
and not hrrp_node_n.hryid like '0109/%'
and not hrrp_node_n.hryid like '0102/%'
and not hrrp_node_n.hryid like 'H109/%'
union all select from hrrp_node_n
{
key hrrp_node_n.hryid_42 as FinancialStatementHierarchy,
key cast('1COA0PLRESULTA' as hrynode) as HierarchyNode,
key hrrp_node_n.hryvalto as ValidityEndDate,
cast(hrrp_node_n.hryvalfrom as fis_datab preserving type ) as ValidityStartDate,
cast('00PLPROFIT' as parnode) as ParentNode,
@VDM.lifecycle.status: #DEPRECATED
cast('000000000000001' as hryversn) as HierarchyVersion,
hrrp_node_n.nodecls as ChartOfAccounts,
'L' as NodeType,
cast('0COA0PLRESULTA' as hrynode) as FinancialStatementLeafItem,
cast('' as fi_fsv_nodtyp) as FinancialStatementNodeType,
cast('0COA0PLRESULT A' as fi_fsv_nodeext) as FinStmntNodeFormattedID,
concat(hrrp_node_n.hryseqnbr, hrrp_node_n.hrynode) as SequenceNumber,
hrrp_node_n.sign as SignIsInverted,
hrrp_node_n.nodevalue as HierarchyNodeVal,
hrrp_node_n.hryseqnbr as HierarchyNodeSequence, //sequence in num6
hrrp_node_n.hrylevel as HierarchyLevel,
hrrp_node_n.balind as DebitCreditCode
}
where
hrrp_node_n.nodetype = 'M'
and hrrp_node_n.hrytyp = 'FSVN'
and not hrrp_node_n.hryid like '0109/%'
and not hrrp_node_n.hryid like '0102/%'
and not hrrp_node_n.hryid like 'H109/%'
union all select from hrrp_node_n
{
key hrrp_node_n.hryid_42 as FinancialStatementHierarchy,
key cast('1COA0BSRESULT1A' as hrynode) as HierarchyNode,
key hrrp_node_n.hryvalto as ValidityEndDate,
cast(hrrp_node_n.hryvalfrom as fis_datab preserving type ) as ValidityStartDate,
cast('00BSLOSS' as parnode) as ParentNode,
@VDM.lifecycle.status: #DEPRECATED
cast('000000000000001' as hryversn) as HierarchyVersion,
hrrp_node_n.nodecls as ChartOfAccounts,
'L' as NodeType,
cast('0COA0BSRESULT1A' as hrynode) as FinancialStatementLeafItem,
cast('' as fi_fsv_nodtyp) as FinancialStatementNodeType,
cast('0COA0BSRESULT 1A' as fi_fsv_nodeext) as FinStmntNodeFormattedID,
concat(hrrp_node_n.hryseqnbr, hrrp_node_n.hrynode) as SequenceNumber,
hrrp_node_n.sign as SignIsInverted,
hrrp_node_n.nodevalue as HierarchyNodeVal,
hrrp_node_n.hryseqnbr as HierarchyNodeSequence, //sequence in num6
hrrp_node_n.hrylevel as HierarchyLevel,
hrrp_node_n.balind as DebitCreditCode
}
where
hrrp_node_n.nodetype = 'K'
and hrrp_node_n.hrytyp = 'FSVN'
and not hrrp_node_n.hryid like '0109/%'
and not hrrp_node_n.hryid like '0102/%'
and not hrrp_node_n.hryid like 'H109/%'
union all select from hrrp_node_n
{
key hrrp_node_n.hryid_42 as FinancialStatementHierarchy,
key cast('1COA0BSRESULT2A' as hrynode) as HierarchyNode,
key hrrp_node_n.hryvalto as ValidityEndDate,
cast(hrrp_node_n.hryvalfrom as fis_datab preserving type ) as ValidityStartDate,
cast('00BSPROFIT' as parnode) as ParentNode,
@VDM.lifecycle.status: #DEPRECATED
cast('000000000000001' as hryversn) as HierarchyVersion,
hrrp_node_n.nodecls as ChartOfAccounts,
'L' as NodeType,
cast('0COA0BSRESULT2A' as hrynode) as FinancialStatementLeafItem,
cast('' as fi_fsv_nodtyp) as FinancialStatementNodeType,
cast('0COA0BSRESULT 2A' as fi_fsv_nodeext) as FinStmntNodeFormattedID,
concat(hrrp_node_n.hryseqnbr, hrrp_node_n.hrynode) as SequenceNumber,
hrrp_node_n.sign as SignIsInverted,
hrrp_node_n.nodevalue as HierarchyNodeVal,
hrrp_node_n.hryseqnbr as HierarchyNodeSequence, //sequence in num6
hrrp_node_n.hrylevel as HierarchyLevel,
hrrp_node_n.balind as DebitCreditCode
}
where
hrrp_node_n.nodetype = 'A'
and hrrp_node_n.hrytyp = 'FSVN'
and not hrrp_node_n.hryid like '0109/%'
and not hrrp_node_n.hryid like '0102/%'
and not hrrp_node_n.hryid like 'H109/%'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"HRRP_NODE_N"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/