R_HierRuntimeRprstnNode

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_HierRuntimeRprstnNode.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: RHRRPNODE

CREATE VIEW R_HierRuntimeRprstnNode AS
SELECT
  hryid_42 AS HierarchyID,
  cast( '000000000000001' as hryversn preserving type ) AS HierarchyVersion,
  cast(hryvalto as fis_datbi preserving type ) AS ValidityEndDate,
  hrynode AS HierarchyNode,
  nodecls AS HierarchyNodeClass,
  parnode AS ParentNode,
  hrytyp AS HierarchyType,
  cast(hryvalfrom as fis_datab preserving type ) AS ValidityStartDate,
  balind AS DebitCreditCode,
  NodeType,
  nodevalue AS HierarchyNodeVal,
  hryseqnbr AS SequenceNumber,
  hrylevel AS HierarchyNodeLevel,
  kokrs AS ControllingArea,
  ktopl AS ChartOfAccounts,
  itclg AS ConsolidationChartOfAccounts,
  sityp AS SubItemCategory,
  scen_id AS ValidationScenarioID,
  fikrs AS FinancialManagementArea,
  fma_fisyear AS FinMgmtAreaFiscalYear,
  saknr AS GLAccount,
  kostl AS CostCenter,
  prctr AS ProfitCenter,
  stagr AS StatisticalKeyFigure,
  lstar AS ActivityType,
  cast( posid as fis_wbs_no_conv preserving type ) AS WBSElement,
  fkber AS FunctionalArea,
  bukrs AS CompanyCode,
  Segment,
  cbttype AS BusinessTransactionType,
  aufnr AS OrderID,
  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,
  kunnr AS CustomerNum,
  lifnr AS AssetSupplier,
  cast( pspid as fis_project_no_conv preserving type ) AS Project,
  matnr AS Material,
  kdgrp AS CustomerGroup,
  land1 AS CountryOrRegion,
  item AS FinancialStatementItemTemplate,
  cast ( bunit as fincs_consolidationunit preserving type ) 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,
  fs_product_group AS FinancialServicesProductGroup,
  pricingrelevant AS PricingIsRelevant,
  sign AS SignIsInverted,
  regrouping AS GeneralLedgerAgingIncrement,
  fs_leafitem AS FinancialStatementLeafItem,
  fs_nodetype AS FinancialStatementNodeType,
  hrynodeext AS FinStmntNodeFormattedID,
  banksplit AS BankAccountGroupingIsSet,
  node_timedep AS HierarchyNodeIsTimeDependent
FROM hrrp_node_n
LEFT OUTER JOIN R_HierRuntimeRprstnNodeText AS _Text ON HierarchyID = _Text.HierarchyID AND ValidityEndDate = _Text.ValidityEndDate AND HierarchyNode = _Text.HierarchyNode AND HierarchyNodeClass = _Text.HierarchyNodeClass AND ParentNode = _Text.ParentNode AND HierarchyVersion = _Text.HierarchyVersion  -- association [0..*]
LEFT OUTER JOIN R_HierRuntimeRepresentation AS _Hierarchy ON HierarchyID = _Hierarchy.HierarchyID AND HierarchyVersion = _Hierarchy.HierarchyVersion AND ValidityEndDate = _Hierarchy.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElement = _WBSElementBasicData.WBSElement  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _ProjectBasicData ON Project = _ProjectBasicData.Project  -- association [0..1]
;