I_CaseReason

DDL: I_CASEREASON SQL: ICASEREASON Type: view BASIC
4 Fields 1 Data Sources 2 Associations

Case Reason

I_CaseReason (Basic)

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

DisputeCaseReason · Financial Operations

I_CaseReason is a Basic CDS View (Dimension) that provides data about "Case Reason" in SAP S/4HANA. It reads from 1 data source (scmgattr_reason) and exposes 4 fields with key fields CaseType, CaseReason. 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 case reasons within a system, specifically focusing on dispute cases. It serves as a dimension in analytical scenarios, allowing for the extraction and analysis of data related to the reasons behind cases. The view facilitates associations with case types and case reason texts, enabling a comprehensive understanding of the context and details surrounding each case reason. This CDS view provides the data to answer the following business questions: What are the different reasons associated with dispute cases in the system? How can case reasons be categorized and linked to specific case types? What textual descriptions are available for each case reason, and how do they relate to the case types? How can the data on case reasons be extracted for analytical purposes to improve service quality and decision-making processes? 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 CaseReason Reason

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 case reasons within a system, specifically focusing on dispute cases. It serves as a dimension in analytical scenarios, allowing for the extraction and analysis of data related to the reasons behind cases. The view facilitates associations with case types and case reason texts, enabling a comprehensive understanding of the context and details surrounding each case reason.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the different reasons associated with dispute cases in the system?</p></li> <li><p>How can case reasons be categorized and linked to specific case types?</p></li> <li><p>What textual descriptions are available for each case reason, and how do they relate to the case types?</p></li> <li><p>How can the data on case reasons be extracted for analytical purposes to improve service quality and decision-making processes?</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
scmgattr_reason scmgattr_reason from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CaseType _CaseType $projection.CaseType = _CaseType.CaseType
[0..*] I_CaseReasonText _Text $projection.CaseType = _Text.CaseType and $projection.CaseReason = _Text.CaseReason

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Case Reason view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName ICASEREASON view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey CaseReason view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CaseType Usage Type
KEY CaseReason Return/Change Reason
_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_CaseReason.
-- 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: ICASEREASON

CREATE VIEW I_CaseReason AS
SELECT
  cast( case_type as scmgcase_type preserving type ) AS CaseType,
  cast( reason_code as scmg_reason_code preserving type ) AS CaseReason
FROM scmgattr_reason
LEFT OUTER JOIN I_CaseType AS _CaseType ON CaseType = _CaseType.CaseType  -- association [0..1]
LEFT OUTER JOIN I_CaseReasonText AS _Text ON CaseType = _Text.CaseType AND CaseReason = _Text.CaseReason  -- association [0..*]
;

Learn More