I_CnsldtnSalesOrgHierNodeEnhcd

DDL: I_CNSLDTNSALESORGHIERNODEENHCD Type: view BASIC
9 Fields 1 Data Sources

Cnsldtn Sales Organization - Hier Node

I_CnsldtnSalesOrgHierNodeEnhcd is a Basic CDS View that provides data about "Cnsldtn Sales Organization - Hier Node" in SAP S/4HANA. It reads from 1 data source (hrrp_node) and exposes 9 fields with key fields AdditionalMasterDataHierarchy, HierarchyNode, ValidityEndDate.

Data Sources (1)

SourceAliasJoin Type
hrrp_node hrrp_node from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICCSGHNENH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view
EndUserText.label Cnsldtn Sales Organization - Hier Node view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY AdditionalMasterDataHierarchy
KEY HierarchyNode hrrp_node hrynode Node
KEY ValidityEndDate
ParentNode hrrp_node parnode Par. Node
ValidityStartDate
HierarchyNodeSequence hrrp_node hryseqnbr Sequence Number
HierarchyNodeLevel hrrp_node hrylevel Hierarchy Level
NodeType hrrp_node nodetype Object Type
HierarchyType

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 I_CnsldtnSalesOrgHierNodeEnhcd.
-- 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.

CREATE VIEW I_CnsldtnSalesOrgHierNodeEnhcd AS
SELECT
  cast( hrrp_node.hryid as fincs_hryid) AS AdditionalMasterDataHierarchy,
  hrrp_node.hrynode AS HierarchyNode,
  cast(hrrp_node.hryvalto as fis_datbi) AS ValidityEndDate,
  hrrp_node.parnode AS ParentNode,
  cast(hrrp_node.hryvalfrom as fis_datab) AS ValidityStartDate,
  hrrp_node.hryseqnbr AS HierarchyNodeSequence,
  hrrp_node.hrylevel AS HierarchyNodeLevel,
  hrrp_node.nodetype AS NodeType,
  cast(substring( hrrp_node.hryid, 1, 4) as hrytype) AS HierarchyType
FROM hrrp_node
;

Learn More