I_RootCause

DDL: I_ROOTCAUSE SQL: IROOTCAUSE Type: view BASIC
4 Fields 1 Data Sources 2 Associations

Root Cause

I_RootCause (Basic)

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

DisputeCaseRootCause · Financial Operations

I_RootCause is a Basic CDS View (Dimension) that provides data about "Root Cause" in SAP S/4HANA. It reads from 1 data source (udmattr_rccode) and exposes 4 fields with key fields CaseType, DisputeCaseRootCause. It has 2 associations to related views.

SAP Help Documentation

CategoryCDS Views for Dispute Resolution
Data CategoryDimension
Purpose
This CDS view is designed to provide a structured representation of root causes associated with dispute cases. It extracts and organizes data related to the types of cases and their corresponding root causes, facilitating analysis and reporting. This CDS view provides the data to answer the following business questions: What are the different root causes associated with dispute cases in the system? How can we categorize dispute cases based on their root causes? What are the textual descriptions or details associated with each root cause of a dispute case? How do different case types relate to specific root causes in dispute management? 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 Users who want to use this CDS view don't need any special authorization.

Structure
Important fields Important fields in this view include the following: Field Name Description CaseType Case Type DisputeCaseRootCause Root Cause Code

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-DM
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Analytical Dimension, Data Source for Data Extraction
PackageFinancial Operations for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view is designed to provide a structured representation of root causes associated with dispute cases. It extracts and organizes data related to the types of cases and their corresponding root causes, facilitating analysis and reporting.</p> This CDS view provides the data to answer the following business questions:<ul> <li><p>What are the different root causes associated with dispute cases in the system?</p></li> <li><p>How can we categorize dispute cases based on their root causes?</p></li> <li><p>What are the textual descriptions or details associated with each root cause of a dispute case?</p></li> <li><p>How do different case types relate to specific root causes in dispute management?</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
udmattr_rccode udmattr_rccode from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CaseType _CaseType $projection.CaseType = _CaseType.CaseType
[0..*] I_RootCauseText _Text $projection.CaseType = _Text.CaseType and $projection.DisputeCaseRootCause = _Text.DisputeCaseRootCause

Annotations (13)

NameValueLevelField
EndUserText.label Root Cause view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IROOTCAUSE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey DisputeCaseRootCause view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.sapObjectNodeType.name DisputeCaseRootCause view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CaseType Upper/Lowercase
KEY DisputeCaseRootCause Root Cause Code
_CaseType _CaseType
_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_RootCause.
-- 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: IROOTCAUSE

CREATE VIEW I_RootCause AS
SELECT
  cast( casetype as scmgcase_type preserving type ) AS CaseType,
  cast( root_ccode as udm_root_ccode preserving type ) AS DisputeCaseRootCause
FROM udmattr_rccode
LEFT OUTER JOIN I_CaseType AS _CaseType ON CaseType = _CaseType.CaseType  -- association [0..1]
LEFT OUTER JOIN I_RootCauseText AS _Text ON CaseType = _Text.CaseType AND DisputeCaseRootCause = _Text.DisputeCaseRootCause  -- association [0..*]
;

Learn More