R_DisputeCaseDraftTP

DDL: R_DISPUTECASEDRAFTTP Type: view TRANSACTIONAL
65 Fields 1 Data Sources 6 Associations

Dispute Case with Draft

R_DisputeCaseDraftTP is a Transactional CDS View that provides data about "Dispute Case with Draft" in SAP S/4HANA. It reads from 1 data source (P_DisputeCaseDraft) and exposes 65 fields with key field DisputeCaseUUID. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_DisputeCaseDraft P_DisputeCaseDraft from

Associations (6)

CardinalityTargetAliasCondition
[0..1] R_RblsMgmtUserContactCard _CreatedByContactCard $projection.CaseCreatedBy = _CreatedByContactCard.ContactCardID
[0..1] R_RblsMgmtUserContactCard _ChangedByContactCard $projection.CaseLastChangedBy = _ChangedByContactCard.ContactCardID
[0..1] R_RblsMgmtUserContactCard _ClosedByContactCard $projection.CaseClosedBy = _ClosedByContactCard.ContactCardID
[0..1] R_RblsMgmtUserContactCard _DisputeCaseCoordinatorCard $projection.DisputeCaseCoordinator = _DisputeCaseCoordinatorCard.ContactCardID
[0..1] R_RblsMgmtUserContactCard _ProcessorContactCard $projection.CaseProcessor = _ProcessorContactCard.ContactCardID
[0..1] R_RblsMgmtUserContactCard _ResponsibleContactCard $projection.CaseResponsible = _ResponsibleContactCard.ContactCardID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName RDISPCASEDR view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Dispute Case with 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 #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (65)

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
_AuthLevel _AuthLevel
_CaseSystemStatus _CaseSystemStatus
_CaseTypes _CaseTypes
_CaseCategory _CaseCategory
_ChangedByContactCard _ChangedByContactCard
_ClosedByContactCard _ClosedByContactCard
_CompanyCode _CompanyCode
_Country _Country
_CreatedByContactCard _CreatedByContactCard
_Customer _Customer
_DisputeCaseCoordinatorCard _DisputeCaseCoordinatorCard
_DisputeCaseExternalAppl _DisputeCaseExternalAppl
_Escalation _Escalation
_Individual _Individual
_Priority _Priority
_ProcessorContactCard _ProcessorContactCard
_Reasons _Reasons
_ResponsibleContactCard _ResponsibleContactCard
_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 R_DisputeCaseDraftTP.
-- 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 R_DisputeCaseDraftTP 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
FROM P_DisputeCaseDraft
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _CreatedByContactCard ON CaseCreatedBy = _CreatedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _ChangedByContactCard ON CaseLastChangedBy = _ChangedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _ClosedByContactCard ON CaseClosedBy = _ClosedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _DisputeCaseCoordinatorCard ON DisputeCaseCoordinator = _DisputeCaseCoordinatorCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _ProcessorContactCard ON CaseProcessor = _ProcessorContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _ResponsibleContactCard ON CaseResponsible = _ResponsibleContactCard.ContactCardID  -- association [0..1]
;

Learn More