I_CaseReason

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

Case Reason

I_CaseReason (Basic)

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

Dispute Case Reason · 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. Part of development package UDM_DM_CDS.

SAP Help Documentation

CategoryCDS Views for Dispute Resolution
Purpose
This CDS view provides the case reasons defined for dispute cases in SAP Dispute Management . This CDS view provides the data to answer the following business questions: Which case reasons are defined for dispute cases? 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_AR_DISPUTES_PC - Accounts Receivable - Dispute Resolution SAP_FIN_BC_AR_DM_ANALYTICS_PC - Accounts Receivable - Dispute Management Analytics SAP_FIN_BC_AR_DM_PERIOD_PC - Accounts Receivable - Periodic Activities for Dispute Management SAP_FIN_BC_AR_DM_SETTINGS_PC - Accounts Receivable - Dispute Management Settings

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-DM-2CL
CapabilitiesData Source for Data Extraction,Data Source in SQL Select,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities,Analytical Dimension
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageFinancial Operations for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the case reasons defined for dispute cases.</p> This CDS view provides the data to answer the following business questions:<ul> <li> <p>Which case reasons are defined for dispute cases?</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 (13)

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
ObjectModel.sapObjectNodeType.name DisputeCaseReason 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