P_CnsldtnUnivHierNode_3

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 P_CnsldtnUnivHierNode_3.
-- 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.
-- Parameters: P_HierarchyType : hrytype, P_MasterDataType : fieldname

CREATE VIEW P_CnsldtnUnivHierNode_3 AS
SELECT
  cast(_HierarchyNode.nodecls as fincs_hierarchynodeclass preserving type ) AS HierarchyNodeClass,
  cast(_HierarchyNode.hryid as fincs_universalhierhierarchyid preserving type ) AS UniversalHierarchy,
  cast(_HierarchyNode.hrynode as fincs_hierarchynode preserving type ) AS HierarchyNode,
  cast(_HierarchyNode.hryvalto as fincs_validityenddate preserving type ) AS ValidityEndDate,
  cast(_HierarchyNode.hryid_42 as fincs_universalhierarchy42 preserving type ) AS CnsldtnUniversalHierarchy,
  cast('000000000000001' as fincs_hierarchyversion preserving type ) AS HierarchyVersion,
  cast(_HierarchyNode.parnode as fincs_parentnode preserving type ) AS ParentNode,
  cast(_HierarchyNode.hryvalfrom as fincs_validitystartdate preserving type ) AS ValidityStartDate,
  cast(_HierarchyNode.nodetype as fincs_nodetype preserving type ) AS NodeType,
  cast(_HierarchyNode.nodevalue as fincs_hierarchynodevalue preserving type ) AS HierarchyNodeVal,
  _HierarchyNode.leafvalue AS UniversalHierarchyLeafValue,
  cast(_HierarchyNode.hryseqnbr as fincs_hierarchynodesequence preserving type ) AS HierarchyNodeSequence,
  cast(_HierarchyNode.hrylevel as fincs_hierarchynodelevel preserving type ) AS HierarchyNodeLevel,
  cast(_HierarchyNode.itclg as fincs_conschartofaccounts preserving type ) AS ConsolidationChartOfAccounts,
  cast(_HierarchyNode.kokrs as fincs_controllingarea preserving type ) AS ControllingArea,
  cast(_HierarchyNode.ktopl as fincs_chartofaccounts preserving type ) AS ChartOfAccounts,
  cast(_HierarchyNode.sityp as fincs_subitemcategory preserving type ) AS SubItemCategory,
  cast(_HierarchyNode.matkl as fincs_materialgroup preserving type ) AS MaterialGroup,
  cast(_HierarchyNode.matkl as fincs_productgroup preserving type ) AS ProductGroup,
  cast(_HierarchyNode.matnr as fincs_material preserving type ) AS Material,
  cast(_HierarchyNode.matnr as fincs_product preserving type ) AS Product,
  cast(_HierarchyNode.fkart as fincs_billingdocumenttype preserving type ) AS BillingDocumentType,
  cast(_HierarchyNode.vtweg as fincs_distributionchannel preserving type ) AS DistributionChannel,
  cast(_HierarchyNode.spart as fincs_division preserving type ) AS Division,
  cast(_HierarchyNode.brsch as fincs_industry preserving type ) AS Industry,
  cast(_HierarchyNode.werks as fincs_plant preserving type ) AS Plant,
  cast(_HierarchyNode.bzirk as fincs_salesdistrict preserving type ) AS SalesDistrict,
  cast(_HierarchyNode.grant_nbr as fincs_grant preserving type ) AS GrantID,
  cast(_HierarchyNode.fincode as fincs_fund preserving type ) AS Fund,
  cast(_HierarchyNode.item as fincs_consolidationfsitem preserving type ) AS CnsldtnFinancialStatementItem,
  cast(_HierarchyNode.kostl as fincs_costcenter preserving type ) AS CostCenter,
  cast(_HierarchyNode.bunit as fincs_consolidationunit preserving type ) AS ConsolidationUnit,
  cast(_HierarchyNode.prctr as fincs_profitcenter preserving type ) AS ProfitCenter,
  cast(_HierarchyNode.segment as fincs_segment preserving type ) AS Segment,
  cast(_HierarchyNode.lifnr as fincs_supplier preserving type ) AS Supplier,
  cast(_HierarchyNode.vkorg as fincs_vkorg preserving type ) AS SalesOrganization,
  cast(_HierarchyNode.kunnr as fincs_customer preserving type ) AS Customer,
  cast(_HierarchyNode.kdgrp as fincs_customergroup preserving type ) AS CustomerGroup,
  cast(_HierarchyNode.sitem as fincs_subitem preserving type ) AS SubItem,
  cast(_HierarchyNode.land1 as fincs_country preserving type ) AS Country,
  cast(_HierarchyNode.sign as fincs_signisinverted preserving type ) AS SignIsInverted,
  cast(_HierarchyNode.saknr as fincs_glaccount preserving type ) AS GLAccount,
  cast(_HierarchyNode.sitem as fincs_subitem preserving type ) AS CnsldtnSubitem,
  cast(_HierarchyNode.sityp as fincs_subitemcategory preserving type ) AS CnsldtnSubitemCategory,
  cast(_HierarchyNode.plevl as fincs_postinglevel preserving type ) AS ConsolidationPostingLevel
FROM hrrp_node_n AS _HierarchyNode
;