P_DisputeCaseDEX

DDL: P_DISPUTECASEDEX SQL: PDISPUTECASEDEX Type: view COMPOSITE
19 Fields 1 Data Sources

Dispute Cases for Extraction

P_DisputeCaseDEX is a Composite CDS View that provides data about "Dispute Cases for Extraction" in SAP S/4HANA. It reads from 1 data source (I_DisputeCase) and exposes 19 fields with key field DisputeCaseUUID.

Data Sources (1)

SourceAliasJoin Type
I_DisputeCase I_DisputeCase from

Annotations (11)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.sqlViewName PDISPUTECASEDEX view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Dispute Cases for Extraction view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY DisputeCaseUUID DisputeCaseUUID UUID
CompanyCode CompanyCode Receiver Company Code
Country _CompanyCode Country Venue: Ctry/Reg
Customer Customer Sold-to Party
CaseSystemStatus Status Workflow Status
DisputedAmount DisputedAmount Disputed Amount
OriginalAmount OriginalAmount Original Disputed Amount
Currency Currency Valuation Crcy
DisputeCaseRootCause DisputeCaseRootCause Root Cause Code
DisputeCaseCoordinator DisputeCaseCoordinator Coordinator
CaseCreationDate
CompanyCodeCurrency _CompanyCode Currency Valuation Crcy
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
GlobalCurrencyExchangeRateType GlobalCurrencyExchangeRateType Exch. 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 P_DisputeCaseDEX.
-- 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: PDISPUTECASEDEX

CREATE VIEW P_DisputeCaseDEX AS
SELECT
  DisputeCaseUUID,
  CompanyCode,
  _CompanyCode.Country AS Country,
  Customer,
  Status AS CaseSystemStatus,
  DisputedAmount,
  OriginalAmount,
  Currency,
  DisputeCaseRootCause,
  DisputeCaseCoordinator,
  cast( substring( cast( _CaseAttributes.CreationDateTime as sstring ),1,8 ) as udm_create_date ) AS CaseCreationDate,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  GlobalCurrency,
  GlobalCurrencyExchangeRateType
FROM I_DisputeCase
;

Learn More