A_CADisputeCase_2

DDL: A_CADISPUTECASE_2 Type: view_entity CONSUMPTION
72 Fields 1 Data Sources 1 Associations

Dispute Case

A_CADisputeCase_2 is a Consumption CDS View that provides data about "Dispute Case" in SAP S/4HANA. It reads from 1 data source (R_CADisputeCaseTP) and exposes 72 fields with key field CaseUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_CADisputeCaseTP R_CADisputeCaseTP projection

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Dispute Case view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
OData.entityType.name A_DisputeCase_2_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

Fields (72)

KeyFieldSource TableSource FieldDescription
KEY CaseUUID CaseUUID UUID
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerFullName BusinessPartnerFullName Broker Name
ContractAccount ContractAccount Contract Acct
ContractAccountName ContractAccountName Cont. acct name
CAContract Contract
CAApplicationArea CAApplicationArea ApplicationArea
CASubApplication CASubApplication Subapplication
DisputedAmount DisputedAmount Disputed Amount
TotalReceivablesAmount TotalReceivablesAmount
DisputeCaseCorrectionAmount DisputeCaseCorrectionAmount
DisputeCaseReversedAmount DisputeCaseReversedAmount
CreditedAmount CreditedAmount Credited
WriteOffAmount WriteOffAmount Cleared Manually
DisputeCaseReplacedAmount DisputeCaseReplacedAmount
PaidAmount PaidAmount Paid Amount
CARemainingDisputedAmount CARemainingDisputedAmount
DisputeCaseCurrency DisputeCaseCurrency Currency
LogicalSystem LogicalSystem Logical System
CADisputeType CADisputeType
CADisputeTypeText CADisputeTypeText
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName CompanyCodeName Company Name
DisputeCaseCoordinator DisputeCaseCoordinator Coordinator
DisputeCaseRootCause DisputeCaseRootCause Root Cause Code
CaseRootCauseDescription CaseRootCauseDescription
CaseProcessingDeadlineDate CaseProcessingDeadlineDate Process. Deadline
ContactPersonFullName ContactPersonFullName
ContactPersonEmailAddress ContactPersonEmailAddress Email
ContactPersonPhoneNumber ContactPersonPhoneNumber Telephone No.
ContactPersonFaxNumber ContactPersonFaxNumber Fax Number
ContactPersonFaxCountry ContactPersonFaxCountry C/R of Fax No.
DisputeCaseBPCorrespondenceKey DisputeCaseBPCorrespondenceKey
DisputeCaseInformationText DisputeCaseInformationText
DisputeCaseTransactionDate DisputeCaseTransactionDate
CADisputeCase CADisputeCase
CaseType CaseType Upper/Lowercase
CaseID CaseID Case ID
CaseExternalReference CaseExternalReference External Reference
CaseCreatedBy CaseCreatedBy Created By
CaseCreationDate CaseCreationDate
CaseLastChangedBy CaseLastChangedBy Changed By
CaseLastChangedOn CaseLastChangedOn Last Changed At
CaseStatusProfile CaseStatusProfile Status Profile
CaseClosedBy CaseClosedBy Closed By
CaseClosedTime CaseClosedTime Closed At
CasePlannedCloseDate CasePlannedCloseDate Planned Close Date
CaseProcessor CaseProcessor Processor
CaseResponsible CaseResponsible Person Responsible
CaseTitle CaseTitle Case Title
CaseAuthorizationLevel CaseAuthorizationLevel Auth. Level
CaseStatus CaseStatus Status
CaseStatusName CaseStatusName
CaseSystemStatus CaseSystemStatus System Status
CaseUserStatusName CaseUserStatusName User Status
CasePriority CasePriority Priority
DisputeCasePriorityName DisputeCasePriorityName
CaseCategory CaseCategory Category
DisputeCaseCategoryName DisputeCaseCategoryName
CaseReason CaseReason Reason
CaseReasonName CaseReasonName
CaseEscalationReason CaseEscalationReason Escalation Reason
DsputCaseEscalationRsnName DsputCaseEscalationRsnName
StreetName StreetName Text
HouseNumber HouseNumber House Number
CountryName CountryName Country
PostalCode PostalCode Postal Code
CityName CityName Name
CADisputeExternalCallerCode CADisputeExternalCallerCode
DisputeCaseOrigin DisputeCaseOrigin
CAAuthorizationGroup CAAuthorizationGroup AuthorizGroup
_BusinessPartner _BusinessPartner

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 A_CADisputeCase_2.
-- 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.

CREATE VIEW A_CADisputeCase_2 AS
SELECT
  CaseUUID,
  BusinessPartner,
  BusinessPartnerFullName,
  ContractAccount,
  ContractAccountName,
  cast ( CAContract as vtref_kk preserving type ) AS CAContract,
  CAApplicationArea,
  CASubApplication,
  DisputedAmount,
  TotalReceivablesAmount,
  DisputeCaseCorrectionAmount,
  DisputeCaseReversedAmount,
  CreditedAmount,
  WriteOffAmount,
  DisputeCaseReplacedAmount,
  PaidAmount,
  CARemainingDisputedAmount,
  DisputeCaseCurrency,
  LogicalSystem,
  CADisputeType,
  CADisputeTypeText,
  CompanyCode,
  CompanyCodeName,
  DisputeCaseCoordinator,
  DisputeCaseRootCause,
  CaseRootCauseDescription,
  CaseProcessingDeadlineDate,
  ContactPersonFullName,
  ContactPersonEmailAddress,
  ContactPersonPhoneNumber,
  ContactPersonFaxNumber,
  ContactPersonFaxCountry,
  DisputeCaseBPCorrespondenceKey,
  DisputeCaseInformationText,
  DisputeCaseTransactionDate,
  CADisputeCase,
  CaseType,
  CaseID,
  CaseExternalReference,
  CaseCreatedBy,
  CaseCreationDate,
  CaseLastChangedBy,
  CaseLastChangedOn,
  CaseStatusProfile,
  CaseClosedBy,
  CaseClosedTime,
  CasePlannedCloseDate,
  CaseProcessor,
  CaseResponsible,
  CaseTitle,
  CaseAuthorizationLevel,
  CaseStatus,
  CaseStatusName,
  CaseSystemStatus,
  CaseUserStatusName,
  CasePriority,
  DisputeCasePriorityName,
  CaseCategory,
  DisputeCaseCategoryName,
  CaseReason,
  CaseReasonName,
  CaseEscalationReason,
  DsputCaseEscalationRsnName,
  StreetName,
  HouseNumber,
  CountryName,
  PostalCode,
  CityName,
  CADisputeExternalCallerCode,
  DisputeCaseOrigin,
  CAAuthorizationGroup
FROM R_CADisputeCaseTP
LEFT OUTER JOIN A_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
;

Learn More