I_CnsldtnSegmentElimNode

DDL: I_CNSLDTNSEGMENTELIMNODE Type: view BASIC Package: FIN_CS_MD_SEGMENT
2 Fields 1 Data Sources 1 Associations

Cnsldtn Segment Elimination Node

I_CnsldtnSegmentElimNode (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

CnsldtnSegmentEliminationNde · Group Reporting

I_CnsldtnSegmentElimNode is a Basic CDS View (Dimension) that provides data about "Cnsldtn Segment Elimination Node" in SAP S/4HANA. It reads from 1 data source (fincs_addlcharcx) and exposes 2 fields with key field Segment. It has 1 association to related views. Part of development package FIN_CS_MD_SEGMENT.

SAP Help Documentation

CategoryCDS Views for Master Data
Data CategoryDimension
Purpose
This CDS view provides access to the segment for elimination nodes in a segment hierarchy in group reporting. The nodes are of node type $ . A segment for elimination node is a virtual node in a segment hierarchy. The node is derived from the closest common parent node of a segment and its partner segment. A segment for elimination represents the amount of consolidation between a segment and its partner segment. This CDS view provides the data to answer the following business questions: What segment for elimination nodes exist? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations One of the following business catalogs needs to be assigned to a user to be able to use this CDS view: SAP_FIN_BC_CCON_MDORG_PC SAP_A4C_BC_DEV_TST_FI_CCON_PC Configuration HRYTYPE = CS01 (Master Data Type)

Structure
Important Fields Important fields in this view include the following: Field Name Description Segment A consolidation segment at a leaf or elimination node of the hierarchy. NodeType The type of node, which can be a root, a node, a leaf, or $ for elimination nodes.

SAP Business Warehouse (SAP BW) Extraction
Data Extraction Type Full (physical deletions are possible in source tables) Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. For details about the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content . For more information about data extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessGroup Reporting
Application ComponentFIN-CS-MD-2CL
CapabilitiesData Source for Data Extraction,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities,Data Source in SQL Select,Analytical Dimension
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageGroup Reporting for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides access to the segment for elimination nodes in a segment hierarchy in group reporting. The nodes are of node type $. </p> <p>A segment for elimination node is a virtual node in a segment hierarchy. The node is derived from the closest common parent node of a segment and its partner segment. A segment for elimination represents the amount of consolidation between a segment and its partner segment. </p> This CDS view provides the data to answer the following business questions:<ul> <li> <p>What segment for elimination nodes exist? </p> </li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
fincs_addlcharcx _addlcharcx inner

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CnsldtnSegmentElimNodeT _Text $projection.Segment = _Text.Segment

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName ICSSEGELIMNOD view
AbapCatalog.compiler.compareFilter true view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.representativeKey Segment view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.sapObjectNodeType.name CnsldtnSegmentEliminationNde view
VDM.viewType #BASIC view
EndUserText.label Cnsldtn Segment Elimination Node view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY Segment Consolidation Segment for Elimination
_Text _Text

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_CnsldtnSegmentElimNode.
-- 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_CnsldtnSegmentElimNode AS
SELECT
  cast(left(_node.nodevalue, 25) as fincs_elim_segment preserving type ) AS Segment
INNER JOIN fincs_addlcharcx AS _addlcharcx ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CnsldtnSegmentElimNodeT AS _Text ON Segment = _Text.Segment  -- association [0..*]
;

Learn More