I_DisputeCase

DDL: I_DISPUTECASE SQL: IDISPUTECASE Type: view BASIC

Dispute Case

I_DisputeCase (Basic)

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

Dispute Case · Financial Operations

I_DisputeCase is a Basic CDS View that provides data about "Dispute Case" in SAP S/4HANA. It reads from 1 data source (udmcaseattr00) and exposes 17 fields with key field DisputeCaseUUID. It has 7 associations to related views.

SAP Help Documentation

CategoryCDS Views for Dispute Resolution
StatusSystem Status
Purpose
This CDS view is designed to provide a comprehensive overview of dispute cases within a business context. It integrates various attributes related to dispute cases, such as company code, customer information, case status, currency details, and coordinator information, enabling efficient management and analysis of dispute cases in SAP Dispute Management . This CDS view provides the data to answer the following business questions: What are the details of each dispute case, including the disputed and original amounts? Which company code and customer are associated with each dispute case? What is the current status of each dispute case? Who is the coordinator responsible for handling each dispute case, and what is their full name? What is the root cause of each dispute case? What currency is used for the disputed amounts, and what is the global currency and exchange rate type associated with the company code? How can the data be extracted for analytical purposes, including change data capture 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 Users who want to use this CDS view must have a role with the following restriction types set to read access: BUKRS ( Company Code ) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Important Fields Important fields in this view include the following: Field Name Description DisputeCaseUUID UUID CompanyCode Company Code Customer Customer Status System Status DisputedAmount Disputed Amount OriginalAmount Orig. Disp. Amt Currency Currency DisputeCaseRootCause Root Cause Code DisputeCaseCoordinator Coordinator DsputCaseCoordinatorFullName Description GlobalCurrency Global Currency GlobalCurrencyExchangeRateType Exchange Rate Type

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode as well as in delta mode. Deltas are determined automatically by change data capture.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-DM
CapabilitiesData Source for Data Extraction, Data Source in SQL Select
PackageFinancial Operations for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
udmcaseattr00 udmcaseattr00 from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_User _User $projection.DisputeCaseCoordinator = _User.UserID
[1..1] I_CaseAttributes _CaseAttributes $projection.DisputeCaseUUID = _CaseAttributes.CaseUUID
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[1..1] I_CaseStatus _CaseStatus $projection.Status = _CaseStatus.Status
[1..1] I_Currency _Currency $projection.Currency = _Currency.Currency
[0..1] P_LdngLdgrGlobCrcyTranslation _GlobalCurrency $projection.CompanyCode = _GlobalCurrency.CompanyCode

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey DisputeCaseUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName IDISPUTECASE view
EndUserText.label Dispute Case view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY DisputeCaseUUID case_guid UUID in character form
CompanyCode fin_bukrs Company Code
Customer fin_kunnr Customer Key in Accounts Receivable Accounting
Status fin_stat_para Case: System Status
DisputedAmount Current Disputed Amount
OriginalAmount Original Disputed Amount
Currency fin_dispute_curr Currency of Dispute Case
DisputeCaseRootCause fin_root_ccode Root Cause Code
DisputeCaseCoordinator fin_coordinator Coordinator of Dispute Case
DsputCaseCoordinatorFullName _User UserDescription User Description
GlobalCurrency _GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
GlobalCurrencyExchangeRateType _GlobalCurrency ExchangeRateType Exchange Rate Type
_CaseAttributes _CaseAttributes
_CompanyCode _CompanyCode
_Customer _Customer
_CaseStatus _CaseStatus
_Currency _Currency

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_DisputeCase.
-- 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: IDISPUTECASE

CREATE VIEW I_DisputeCase AS
SELECT
  case_guid AS DisputeCaseUUID,
  fin_bukrs AS CompanyCode,
  fin_kunnr AS Customer,
  fin_stat_para AS Status,
  cast( fin_disputed_amt as udm_disputed_amt preserving type ) AS DisputedAmount,
  cast( fin_original_amt as udm_original_amt preserving type ) AS OriginalAmount,
  fin_dispute_curr AS Currency,
  fin_root_ccode AS DisputeCaseRootCause,
  fin_coordinator AS DisputeCaseCoordinator,
  _User.UserDescription AS DsputCaseCoordinatorFullName,
  _GlobalCurrency.GlobalCurrency AS GlobalCurrency,
  _GlobalCurrency.ExchangeRateType AS GlobalCurrencyExchangeRateType
FROM udmcaseattr00
LEFT OUTER JOIN I_User AS _User ON DisputeCaseCoordinator = _User.UserID  -- association [0..1]
LEFT OUTER JOIN I_CaseAttributes AS _CaseAttributes ON DisputeCaseUUID = _CaseAttributes.CaseUUID  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_CaseStatus AS _CaseStatus ON Status = _CaseStatus.Status  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN P_LdngLdgrGlobCrcyTranslation AS _GlobalCurrency ON CompanyCode = _GlobalCurrency.CompanyCode  -- association [0..1]
;