R_HIERRUNTIMERPRSTNNODE
Hierarchy Node
R_HIERRUNTIMERPRSTNNODE is a CDS View in S/4HANA. Hierarchy Node. It contains 13 fields. 8 CDS views read from this table.
CDS Views using this table (8)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_FinSrvcsProdGrpHierNode | view_entity | from | COMPOSITE | Fin Srvcs Product Group Hierarchy Node |
| I_FinStmntExpandedHierNode | view | left_outer | COMPOSITE | Financial Statement Expanded Hier Node |
| P_CN_FinancialStatementItem | view | from | CONSUMPTION | Items in Financial Statement Version |
| P_CN_FsvHierInCoa | view | from | CONSUMPTION | FSV based on chart of accounts |
| P_CN_FsvHierInCoa | view | inner | CONSUMPTION | FSV based on chart of accounts |
| P_FSTMT_GLACCOUNT_ENH | view | left_outer | CONSUMPTION | |
| R_HierRuntimeRprstnInnerNode | view_entity | from | BASIC | Hierarchy Inner Node |
| SHIDCN_FinStmntHierarchyQT | view | from | Statement Items Text in Structure |
Fields (13)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | HierarchyID | FinancialStatementHierarchy,FINANCIALSTATEMENTVARIANT,hierarchy | 4 |
| KEY | HierarchyNode | HierarchyNode,hrynode,Node | 4 |
| KEY | HierarchyVersion | HierarchyVersion,hryver | 2 |
| KEY | ParentNode | ParentNode,parnode | 3 |
| KEY | ValidityEndDate | ValidityEndDate | 4 |
| DebitCreditCode | DebitCreditCode | 1 | |
| FinancialServicesProductGroup | FinancialServicesProductGroup | 1 | |
| HierarchyNodeClass | ChartOfAccounts,HierarchyNodeClass | 2 | |
| HierarchyNodeLevel | HierarchyNodeLevel,NodeLevel | 3 | |
| HierarchyNodeVal | FinStatementHierarchyNodeValue,HierarchyNodeVal,NodeValue | 4 | |
| NodeType | NodeType | 3 | |
| SequenceNumber | HierarchyNodeSequence,SequenceNumber | 2 | |
| ValidityStartDate | ValidityStartDate | 4 |
@AbapCatalog.sqlViewName: 'RHRRPNODE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Hierarchy Node'
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@ObjectModel: {
usageType: {
dataClass: #MASTER,
serviceQuality: #C,
sizeCategory: #XXL
}
}
@ClientHandling.algorithm: #SESSION_VARIABLE
define view R_HierRuntimeRprstnNode
as select from hrrp_node_n
association [0..*] to R_HierRuntimeRprstnNodeText as _Text on $projection.HierarchyID = _Text.HierarchyID
and $projection.ValidityEndDate = _Text.ValidityEndDate
and $projection.HierarchyNode = _Text.HierarchyNode
and $projection.HierarchyNodeClass = _Text.HierarchyNodeClass
and $projection.ParentNode = _Text.ParentNode
and $projection.HierarchyVersion = _Text.HierarchyVersion
association [0..1] to R_HierRuntimeRepresentation as _Hierarchy on $projection.HierarchyID = _Hierarchy.HierarchyID
and $projection.HierarchyVersion = _Hierarchy.HierarchyVersion
and $projection.ValidityEndDate = _Hierarchy.ValidityEndDate
association [0..1] to I_WBSElementBasicData as _WBSElementBasicData on $projection.WBSElement = _WBSElementBasicData.WBSElement
association [0..1] to I_ProjectBasicData as _ProjectBasicData on $projection.Project = _ProjectBasicData.Project
{
key hryid_42 as HierarchyID,
key cast( '000000000000001' as hryversn preserving type ) as HierarchyVersion, //keep it for compatibility
@Semantics.businessDate.to: true
key cast(hryvalto as fis_datbi preserving type ) as ValidityEndDate,
@ObjectModel.text.association: '_Text'
key hrynode as HierarchyNode,
key nodecls as HierarchyNodeClass,
key parnode as ParentNode,
hrytyp as HierarchyType,
@Semantics.businessDate.from: true
cast(hryvalfrom as fis_datab preserving type ) as ValidityStartDate,
balind as DebitCreditCode,
nodetype as NodeType,
nodevalue as HierarchyNodeVal,
hryseqnbr as SequenceNumber,
hrylevel as HierarchyNodeLevel,
//HRRP_SI_CLFD
kokrs as ControllingArea, //FIS_KOKRS
ktopl as ChartOfAccounts, //FIS_KTOPL
itclg as ConsolidationChartOfAccounts,
sityp as SubItemCategory,
scen_id as ValidationScenarioID,
fikrs as FinancialManagementArea,
fma_fisyear as FinMgmtAreaFiscalYear,
//HRRP_SI_BETY
saknr as GLAccount, //FIS_RACCT
kostl as CostCenter, //FIS_KOSTL
prctr as ProfitCenter,
stagr as StatisticalKeyFigure, //FIS_STAGR
lstar as ActivityType, //LEARR
_WBSElementBasicData.WBSElementExternalID as WBSElementExternalID,
cast( posid as fis_wbs_no_conv preserving type ) as WBSElement,
fkber as FunctionalArea,
bukrs as CompanyCode,
segment as Segment,
cbttype as BusinessTransactionType,
aufnr as OrderID, //FIS_AUFNR
fincode as Fund,
grant_nbr as GrantID,
budget_pd as BudgetPeriod,
sponsored_class as SponsoredClass,
fictr as FundCenterText,
sponsored_prog as SponsoredProgram,
measure as FundedProgram,
partner as BusinessPartnerNumber,
acc_id as BankAccountInternalID,
lqpos as LiquidityItem,
gsber as AssetBusinessArea,
trtyp as FinancialTransactionType, //FIS_RMVCT
kunnr as CustomerNum,
lifnr as AssetSupplier,
cast( pspid as fis_project_no_conv preserving type ) as Project,
_ProjectBasicData.ProjectExternalID as ProjectExternalID,
matnr as Material,
kdgrp as CustomerGroup,
land1 as CountryOrRegion,
item as FinancialStatementItemTemplate,
bunit as ConsolidationUnit,
sitem as SubItem,
docty as ConsolidationDocumentType,
rcomp as Company,
matkl as MaterialGroup,
rule_num as ValidationRuleID,
bzirk as SalesDistrict,
fkart as BillingDocumentType,
spart as Division,
vkorg as SalesOrganization,
vtweg as DistributionChannel,
werks as Plant,
brsch as Industry,
fipex as CommitmentItem,
plevl as PostingLevel, //FC_PLEVL
fs_product_group as FinancialServicesProductGroup,
//HRRP_SI_CHSALES
pricingrelevant as PricingIsRelevant,
//HRRP_SI_FSVITM
sign as SignIsInverted,
regrouping as GeneralLedgerAgingIncrement,
fs_leafitem as FinancialStatementLeafItem,
fs_nodetype as FinancialStatementNodeType,
hrynodeext as FinStmntNodeFormattedID,
_Text,
_Hierarchy
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROJECTBASICDATA",
"I_WBSELEMENTBASICDATA",
"HRRP_NODE_N"
],
"ASSOCIATED":
[
"I_PROJECTBASICDATA",
"I_WBSELEMENTBASICDATA",
"R_HIERRUNTIMEREPRESENTATION",
"R_HIERRUNTIMERPRSTNNODETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/