R_CollsHeadOfficeDisputeCase

DDL: R_COLLSHEADOFFICEDISPUTECASE Type: view COMPOSITE Package: ODATA_HEADOFFICE_RECEIVABLES
70 Fields 2 Data Sources 6 Associations

Head Office Dispute Case

R_CollsHeadOfficeDisputeCase is a Composite CDS View that provides data about "Head Office Dispute Case" in SAP S/4HANA. It reads from 2 data sources (I_CollsSgmtCompanyCodeAssgmt, P_DisputeCaseDraft) and exposes 70 fields with key fields CollectionSegment, DisputeCaseUUID, HeadOffice. It has 6 associations to related views. Part of development package ODATA_HEADOFFICE_RECEIVABLES.

Data Sources (2)

SourceAliasJoin Type
I_CollsSgmtCompanyCodeAssgmt I_CollsSgmtCompanyCodeAssgmt inner
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 RCLLHOBDC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Head Office Dispute Case view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey DisputeCaseUUID view

Fields (70)

KeyFieldSource TableSource FieldDescription
KEY CollectionSegment I_CollsSgmtCompanyCodeAssgmt CollectionSegment Segment
KEY DisputeCaseUUID P_DisputeCaseDraft DisputeCaseUUID UUID
KEY HeadOffice I_CollectionsInvoiceMemory Customer Sold-to Party
DraftUUID P_DisputeCaseDraft DraftUUID UUID
DisputeCaseCoordinator P_DisputeCaseDraft DisputeCaseCoordinator Coordinator
DisputeCaseRootCause P_DisputeCaseDraft DisputeCaseRootCause Root Cause Code
CaseProcessingDeadlineDate P_DisputeCaseDraft CaseProcessingDeadlineDate Process. Deadline
OriginalAmount P_DisputeCaseDraft OriginalAmount Original Disputed Amount
DisputedAmount P_DisputeCaseDraft DisputedAmount Disputed Amount
PaidAmount P_DisputeCaseDraft PaidAmount Paid Amount
CreditedAmount P_DisputeCaseDraft CreditedAmount Credited
WriteOffAmount P_DisputeCaseDraft WriteOffAmount Cleared Manually
ManuallyClearedAmount P_DisputeCaseDraft ManuallyClearedAmount Automatically Written Off
DisputeCaseCurrency P_DisputeCaseDraft DisputeCaseCurrency Currency
CustomerDisputedAmount P_DisputeCaseDraft CustomerDisputedAmount Customer Disputed Amount
CustomerDisputedCurrency P_DisputeCaseDraft CustomerDisputedCurrency Currency
ContactPersonName P_DisputeCaseDraft ContactPersonName Full Name
ContactPersonEmailAddress P_DisputeCaseDraft ContactPersonEmailAddress Email
ContactPersonPhoneNumber P_DisputeCaseDraft ContactPersonPhoneNumber Telephone No.
ContactPersonFaxNumber P_DisputeCaseDraft ContactPersonFaxNumber Fax Number
ContactPersonFaxCountry P_DisputeCaseDraft ContactPersonFaxCountry C/R of Fax No.
Customer P_DisputeCaseDraft Customer Sold-to Party
CompanyCode P_DisputeCaseDraft CompanyCode Receiver Company Code
DisputeCaseExternalApplication P_DisputeCaseDraft DisputeCaseExternalApplication External Appl.
CaseType P_DisputeCaseDraft CaseType Upper/Lowercase
CaseID P_DisputeCaseDraft CaseID Case ID
CaseExternalReference P_DisputeCaseDraft CaseExternalReference External Reference
CaseCreatedBy P_DisputeCaseDraft CaseCreatedBy Created By
CaseCreatedOn P_DisputeCaseDraft CaseCreatedOn Created At
CaseLastChangedBy P_DisputeCaseDraft CaseLastChangedBy Changed By
CaseLastChangedOn P_DisputeCaseDraft CaseLastChangedOn Last Changed At
CaseClosedBy P_DisputeCaseDraft CaseClosedBy Closed By
CaseClosedTime P_DisputeCaseDraft CaseClosedTime Closed At
CasePlannedCloseDate P_DisputeCaseDraft CasePlannedCloseDate Planned Close Date
CaseProcessor P_DisputeCaseDraft CaseProcessor Processor
CaseResponsible P_DisputeCaseDraft CaseResponsible Person Responsible
CaseTitle P_DisputeCaseDraft CaseTitle Case Title
CaseEscalationReason P_DisputeCaseDraft CaseEscalationReason Escalation Reason
CaseCategory P_DisputeCaseDraft CaseCategory Category
CasePriority P_DisputeCaseDraft CasePriority Priority
CaseAuthorizationLevel P_DisputeCaseDraft CaseAuthorizationLevel Auth. Level
CaseStatusProfile P_DisputeCaseDraft CaseStatusProfile Status Profile
CaseStatus P_DisputeCaseDraft CaseStatus Status
CaseSystemStatus P_DisputeCaseDraft CaseSystemStatus System Status
CaseReason P_DisputeCaseDraft CaseReason Reason
IsActiveEntity P_DisputeCaseDraft IsActiveEntity Is active
HasActiveEntity P_DisputeCaseDraft HasActiveEntity TRUE
DraftCreationDateTime P_DisputeCaseDraft DraftCreationDateTime Time Stamp
DraftLastChangedDateTime P_DisputeCaseDraft DraftLastChangedDateTime Time Stamp
_AuthLevel P_DisputeCaseDraft _AuthLevel
_CaseCategory P_DisputeCaseDraft _CaseCategory
_CaseSystemStatus P_DisputeCaseDraft _CaseSystemStatus
_CaseTypes P_DisputeCaseDraft _CaseTypes
_ChangedByContactCard _ChangedByContactCard
_ClosedByContactCard _ClosedByContactCard
_CompanyCode P_DisputeCaseDraft _CompanyCode
_Country P_DisputeCaseDraft _Country
_CreatedByContactCard _CreatedByContactCard
_Customer P_DisputeCaseDraft _Customer
_DisputeCaseCoordinatorCard _DisputeCaseCoordinatorCard
_DisputeCaseExternalAppl P_DisputeCaseDraft _DisputeCaseExternalAppl
_Escalation P_DisputeCaseDraft _Escalation
_Individual P_DisputeCaseDraft _Individual
_Priority P_DisputeCaseDraft _Priority
_ProcessorContactCard _ProcessorContactCard
_Reasons P_DisputeCaseDraft _Reasons
_ResponsibleContactCard _ResponsibleContactCard
_RootCause P_DisputeCaseDraft _RootCause
_StatProfile P_DisputeCaseDraft _StatProfile
_CollectionSegment I_CollsSgmtCompanyCodeAssgmt _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_CollsHeadOfficeDisputeCase.
-- 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_CollsHeadOfficeDisputeCase AS
SELECT
  I_CollsSgmtCompanyCodeAssgmt.CollectionSegment AS CollectionSegment,
  P_DisputeCaseDraft.DisputeCaseUUID AS DisputeCaseUUID,
  I_CollectionsInvoiceMemory.Customer AS HeadOffice,
  P_DisputeCaseDraft.DraftUUID AS DraftUUID,
  P_DisputeCaseDraft.DisputeCaseCoordinator AS DisputeCaseCoordinator,
  P_DisputeCaseDraft.DisputeCaseRootCause AS DisputeCaseRootCause,
  P_DisputeCaseDraft.CaseProcessingDeadlineDate AS CaseProcessingDeadlineDate,
  P_DisputeCaseDraft.OriginalAmount AS OriginalAmount,
  P_DisputeCaseDraft.DisputedAmount AS DisputedAmount,
  P_DisputeCaseDraft.PaidAmount AS PaidAmount,
  P_DisputeCaseDraft.CreditedAmount AS CreditedAmount,
  P_DisputeCaseDraft.WriteOffAmount AS WriteOffAmount,
  P_DisputeCaseDraft.ManuallyClearedAmount AS ManuallyClearedAmount,
  P_DisputeCaseDraft.DisputeCaseCurrency AS DisputeCaseCurrency,
  P_DisputeCaseDraft.CustomerDisputedAmount AS CustomerDisputedAmount,
  P_DisputeCaseDraft.CustomerDisputedCurrency AS CustomerDisputedCurrency,
  P_DisputeCaseDraft.ContactPersonName AS ContactPersonName,
  P_DisputeCaseDraft.ContactPersonEmailAddress AS ContactPersonEmailAddress,
  P_DisputeCaseDraft.ContactPersonPhoneNumber AS ContactPersonPhoneNumber,
  P_DisputeCaseDraft.ContactPersonFaxNumber AS ContactPersonFaxNumber,
  P_DisputeCaseDraft.ContactPersonFaxCountry AS ContactPersonFaxCountry,
  P_DisputeCaseDraft.Customer AS Customer,
  P_DisputeCaseDraft.CompanyCode AS CompanyCode,
  P_DisputeCaseDraft.DisputeCaseExternalApplication AS DisputeCaseExternalApplication,
  P_DisputeCaseDraft.CaseType AS CaseType,
  P_DisputeCaseDraft.CaseID AS CaseID,
  P_DisputeCaseDraft.CaseExternalReference AS CaseExternalReference,
  P_DisputeCaseDraft.CaseCreatedBy AS CaseCreatedBy,
  P_DisputeCaseDraft.CaseCreatedOn AS CaseCreatedOn,
  P_DisputeCaseDraft.CaseLastChangedBy AS CaseLastChangedBy,
  P_DisputeCaseDraft.CaseLastChangedOn AS CaseLastChangedOn,
  P_DisputeCaseDraft.CaseClosedBy AS CaseClosedBy,
  P_DisputeCaseDraft.CaseClosedTime AS CaseClosedTime,
  P_DisputeCaseDraft.CasePlannedCloseDate AS CasePlannedCloseDate,
  P_DisputeCaseDraft.CaseProcessor AS CaseProcessor,
  P_DisputeCaseDraft.CaseResponsible AS CaseResponsible,
  P_DisputeCaseDraft.CaseTitle AS CaseTitle,
  P_DisputeCaseDraft.CaseEscalationReason AS CaseEscalationReason,
  P_DisputeCaseDraft.CaseCategory AS CaseCategory,
  P_DisputeCaseDraft.CasePriority AS CasePriority,
  P_DisputeCaseDraft.CaseAuthorizationLevel AS CaseAuthorizationLevel,
  P_DisputeCaseDraft.CaseStatusProfile AS CaseStatusProfile,
  P_DisputeCaseDraft.CaseStatus AS CaseStatus,
  P_DisputeCaseDraft.CaseSystemStatus AS CaseSystemStatus,
  P_DisputeCaseDraft.CaseReason AS CaseReason,
  P_DisputeCaseDraft.IsActiveEntity AS IsActiveEntity,
  P_DisputeCaseDraft.HasActiveEntity AS HasActiveEntity,
  P_DisputeCaseDraft.DraftCreationDateTime AS DraftCreationDateTime,
  P_DisputeCaseDraft.DraftLastChangedDateTime AS DraftLastChangedDateTime,
  P_DisputeCaseDraft._AuthLevel AS _AuthLevel,
  P_DisputeCaseDraft._CaseCategory AS _CaseCategory,
  P_DisputeCaseDraft._CaseSystemStatus AS _CaseSystemStatus,
  P_DisputeCaseDraft._CaseTypes AS _CaseTypes,
  P_DisputeCaseDraft._CompanyCode AS _CompanyCode,
  P_DisputeCaseDraft._Country AS _Country,
  P_DisputeCaseDraft._Customer AS _Customer,
  P_DisputeCaseDraft._DisputeCaseExternalAppl AS _DisputeCaseExternalAppl,
  P_DisputeCaseDraft._Escalation AS _Escalation,
  P_DisputeCaseDraft._Individual AS _Individual,
  P_DisputeCaseDraft._Priority AS _Priority,
  P_DisputeCaseDraft._Reasons AS _Reasons,
  P_DisputeCaseDraft._RootCause AS _RootCause,
  P_DisputeCaseDraft._StatProfile AS _StatProfile,
  I_CollsSgmtCompanyCodeAssgmt._CollectionSegment AS _CollectionSegment
INNER JOIN P_DisputeCaseDraft ON /* join condition not captured in parsed metadata */
INNER JOIN I_CollsSgmtCompanyCodeAssgmt 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