C_DisputeCaseDraft

DDL: C_DISPUTECASEDRAFT Type: view_entity CONSUMPTION
71 Fields 1 Data Sources

Dispute Case Draft

C_DisputeCaseDraft is a Consumption CDS View that provides data about "Dispute Case Draft" in SAP S/4HANA. It reads from 1 data source (R_DisputeCaseDraftTP) and exposes 71 fields with key field DisputeCaseUUID.

Data Sources (1)

SourceAliasJoin Type
R_DisputeCaseDraftTP R_DisputeCaseDraftTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Dispute Case Draft view
ObjectModel.representativeKey DisputeCaseUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

Fields (71)

KeyFieldSource TableSource FieldDescription
KEY DisputeCaseUUID DisputeCaseUUID UUID
DraftUUID DraftUUID UUID
DisputeCaseCoordinator DisputeCaseCoordinator Coordinator
DisputeCaseRootCause DisputeCaseRootCause Root Cause Code
CaseProcessingDeadlineDate CaseProcessingDeadlineDate Process. Deadline
OriginalAmount OriginalAmount Original Disputed Amount
DisputedAmount DisputedAmount Disputed Amount
PaidAmount PaidAmount Paid Amount
CreditedAmount CreditedAmount Credited
WriteOffAmount WriteOffAmount Cleared Manually
ManuallyClearedAmount ManuallyClearedAmount Automatically Written Off
DisputeCaseCurrency DisputeCaseCurrency Currency
ContactPersonName ContactPersonName Full Name
ContactPersonEmailAddress ContactPersonEmailAddress Email
ContactPersonPhoneNumber ContactPersonPhoneNumber Telephone No.
ContactPersonFaxNumber ContactPersonFaxNumber Fax Number
ContactPersonFaxCountry ContactPersonFaxCountry C/R of Fax No.
Customer Customer Sold-to Party
CompanyCode CompanyCode Receiver Company Code
DisputeCaseExternalApplication DisputeCaseExternalApplication External Appl.
CaseType CaseType Upper/Lowercase
CaseID CaseID Case ID
CaseExternalReference CaseExternalReference External Reference
CaseCreatedBy CaseCreatedBy Created By
CaseCreatedOn CaseCreatedOn Created At
CaseLastChangedBy CaseLastChangedBy Changed By
CaseLastChangedOn CaseLastChangedOn Last Changed At
CaseClosedBy CaseClosedBy Closed By
CaseClosedTime CaseClosedTime Closed At
CasePlannedCloseDate CasePlannedCloseDate Planned Close Date
CaseProcessor CaseProcessor Processor
CaseResponsible CaseResponsible Person Responsible
CaseTitle CaseTitle Case Title
CaseEscalationReason CaseEscalationReason Escalation Reason
CaseCategory CaseCategory Category
CasePriority CasePriority Priority
CaseAuthorizationLevel CaseAuthorizationLevel Auth. Level
CaseStatusProfile CaseStatusProfile Status Profile
CaseStatus CaseStatus Status
CaseSystemStatus CaseSystemStatus System Status
CaseReason CaseReason Reason
IsActiveEntity IsActiveEntity Is active
HasActiveEntity HasActiveEntity TRUE
DraftCreationDateTime DraftCreationDateTime Time Stamp
DraftLastChangedDateTime DraftLastChangedDateTime Time Stamp
CountryNameasCountryNamelocalized
DsputCaseCoordinatorFullName _DisputeCaseCoordinatorCard UserDescription Full Name
CustomerName _Customer CustomerName Name of Customer
CompanyCodeName _CompanyCode CompanyCodeName Company Name
CaseTypeNameasCaseTypeNamelocalized
CreatedByUserName _CreatedByContactCard UserDescription Full Name
LastChangedByUserName _ChangedByContactCard UserDescription Full Name
DisputeCaseClosedByUserName _ClosedByContactCard UserDescription Full Name
DisputeCaseProcessorFullName _ProcessorContactCard UserDescription Full Name
DisputeCaseResponsibleFullName _ResponsibleContactCard UserDescription Full Name
CaseStatusNameasCaseStatusNamelocalized
CaseReasonNameasCaseReasonNamelocalized
_AuthLevel _AuthLevel
_CaseSystemStatus _CaseSystemStatus
_CaseTypes _CaseTypes
_CaseCategory _CaseCategory
_CompanyCode _CompanyCode
_Country _Country
_Customer _Customer
_DisputeCaseExternalAppl _DisputeCaseExternalAppl
_Escalation _Escalation
_Individual _Individual
_Priority _Priority
_Reasons _Reasons
_RootCause _RootCause
_StatProfile _StatProfile

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 C_DisputeCaseDraft.
-- 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 C_DisputeCaseDraft AS
SELECT
  DisputeCaseUUID,
  DraftUUID,
  DisputeCaseCoordinator,
  DisputeCaseRootCause,
  CaseProcessingDeadlineDate,
  OriginalAmount,
  DisputedAmount,
  PaidAmount,
  CreditedAmount,
  WriteOffAmount,
  ManuallyClearedAmount,
  DisputeCaseCurrency,
  ContactPersonName,
  ContactPersonEmailAddress,
  ContactPersonPhoneNumber,
  ContactPersonFaxNumber,
  ContactPersonFaxCountry,
  Customer,
  CompanyCode,
  DisputeCaseExternalApplication,
  CaseType,
  CaseID,
  CaseExternalReference,
  CaseCreatedBy,
  CaseCreatedOn,
  CaseLastChangedBy,
  CaseLastChangedOn,
  CaseClosedBy,
  CaseClosedTime,
  CasePlannedCloseDate,
  CaseProcessor,
  CaseResponsible,
  CaseTitle,
  CaseEscalationReason,
  CaseCategory,
  CasePriority,
  CaseAuthorizationLevel,
  CaseStatusProfile,
  CaseStatus,
  CaseSystemStatus,
  CaseReason,
  IsActiveEntity,
  HasActiveEntity,
  DraftCreationDateTime,
  DraftLastChangedDateTime,
  _Country._Text.CountryName as CountryName : localized AS CountryNameasCountryNamelocalized,
  _DisputeCaseCoordinatorCard.UserDescription AS DsputCaseCoordinatorFullName,
  _Customer.CustomerName AS CustomerName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _CaseTypes._Text.CaseTypeName as CaseTypeName : localized AS CaseTypeNameasCaseTypeNamelocalized,
  _CreatedByContactCard.UserDescription AS CreatedByUserName,
  _ChangedByContactCard.UserDescription AS LastChangedByUserName,
  _ClosedByContactCard.UserDescription AS DisputeCaseClosedByUserName,
  _ProcessorContactCard.UserDescription AS DisputeCaseProcessorFullName,
  _ResponsibleContactCard.UserDescription AS DisputeCaseResponsibleFullName,
  _Individual._Text.CaseStatusName as CaseStatusName : localized AS CaseStatusNameasCaseStatusNamelocalized,
  _Reasons._Text.CaseReasonName as CaseReasonName : localized AS CaseReasonNameasCaseReasonNamelocalized
FROM R_DisputeCaseDraftTP
;

Learn More