R_DisputeCaseDraftCollsSgmtTP

DDL: R_DISPUTECASEDRAFTCOLLSSGMTTP Type: view TRANSACTIONAL
69 Fields 2 Data Sources 6 Associations

Dispute Case TP

R_DisputeCaseDraftCollsSgmtTP is a Transactional CDS View that provides data about "Dispute Case TP" in SAP S/4HANA. It reads from 2 data sources (I_CollsSgmtCompanyCodeAssgmt, P_DisputeCaseDraft) and exposes 69 fields with key fields CollectionSegment, DisputeCaseUUID. It has 6 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_CollsSgmtCompanyCodeAssgmt I_CollsSgmtCompanyCodeAssgmt from
P_DisputeCaseDraft P_DisputeCaseDraft inner

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 RDISPCCLLSGTP view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Dispute Case TP 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 (69)

KeyFieldSource TableSource FieldDescription
KEY CollectionSegment CollectionSegment Segment
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
CustomerDisputedAmount CustomerDisputedAmount Customer Disputed Amount
CustomerDisputedCurrency CustomerDisputedCurrency 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 P_DisputeCaseDraft 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 P_DisputeCaseDraft _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
_CollectionSegment _CollectionSegment

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_DisputeCaseDraftCollsSgmtTP.
-- 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_DisputeCaseDraftCollsSgmtTP AS
SELECT
  CollectionSegment,
  DisputeCaseUUID,
  DraftUUID,
  DisputeCaseCoordinator,
  DisputeCaseRootCause,
  CaseProcessingDeadlineDate,
  OriginalAmount,
  DisputedAmount,
  PaidAmount,
  CreditedAmount,
  WriteOffAmount,
  ManuallyClearedAmount,
  DisputeCaseCurrency,
  CustomerDisputedAmount,
  CustomerDisputedCurrency,
  ContactPersonName,
  ContactPersonEmailAddress,
  ContactPersonPhoneNumber,
  ContactPersonFaxNumber,
  ContactPersonFaxCountry,
  Customer,
  P_DisputeCaseDraft.CompanyCode AS 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,
  P_DisputeCaseDraft._CompanyCode AS _CompanyCode
FROM I_CollsSgmtCompanyCodeAssgmt
INNER JOIN P_DisputeCaseDraft ON /* join condition not captured in parsed metadata */
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