/DCO/I_AcctgDocRelatedDispute

DDL: /DCO/I_ACCTGDOCRELATEDDISPUTE Type: view_entity COMPOSITE Package: /DCO/COMMONS_REC_ITEM

Accounting Document Related Dispute

/DCO/I_AcctgDocRelatedDispute is a Composite CDS View that provides data about "Accounting Document Related Dispute" in SAP S/4HANA. It reads from 5 data sources (/DCO/I_AccountingDocument, /DCO/I_AccountingDocument, /DCO/I_Dispute, /DCO/I_DisputeDraft, I_DraftAdministrativeData) and exposes 113 fields with key fields DCoAccountingDocumentUUID, DCoDisputeUUID, DCoDisputeUUID. Part of development package /DCO/COMMONS_REC_ITEM.

Data Sources (5)

SourceAliasJoin Type
/DCO/I_AccountingDocument /DCO/I_AccountingDocument inner
/DCO/I_AccountingDocument /DCO/I_AccountingDocument inner
/DCO/I_Dispute /DCO/I_Dispute inner
/DCO/I_DisputeDraft /DCO/I_DisputeDraft inner
I_DraftAdministrativeData I_DraftAdministrativeData inner

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Accounting Document Related Dispute view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (113)

KeyFieldSource TableSource FieldDescription
KEY DCoAccountingDocumentUUID /DCO/I_AccountingDocument DCoAccountingDocumentUUID
KEY DCoDisputeUUID /DCO/I_DsputAccountingDocument DCoDisputeUUID UUID
DebtCollectionsDispute /DCO/I_Dispute DebtCollectionsDispute WEBGUI External ID
BusinessPartner /DCO/I_Dispute BusinessPartner Issuing Authority
DebtCollectionsCompanyCode /DCO/I_Dispute DebtCollectionsCompanyCode Company Code
DCoDisputeProcessStep /DCO/I_Dispute DCoDisputeProcessStep Process Step
DCoDisputeProcessStepStatus /DCO/I_Dispute DCoDisputeProcessStepStatus
DCoDisputePriority /DCO/I_Dispute DCoDisputePriority Workflow priority
DCoDisputeEscalationReason /DCO/I_Dispute DCoDisputeEscalationReason
DCoDisputeEscalationLevelValue /DCO/I_Dispute DCoDisputeEscalationLevelValue
DCoDisputeCurrency /DCO/I_Dispute DCoDisputeCurrency Valuation Crcy
DCoDisputeProcessor /DCO/I_Dispute DCoDisputeProcessor User Name
DCoDisputeProcessorGroup /DCO/I_Dispute DCoDisputeProcessorGroup
DCoDisputeProcessCoordinator /DCO/I_Dispute DCoDisputeProcessCoordinator
DCoDisputeResponsiblePerson /DCO/I_Dispute DCoDisputeResponsiblePerson User Name
DCoDisputeCustContactPerson /DCO/I_Dispute DCoDisputeCustContactPerson
DCoDisputeProcStepDeadlineDate /DCO/I_Dispute DCoDisputeProcStepDeadlineDate
DCoDisputePlannedCloseDate /DCO/I_Dispute DCoDisputePlannedCloseDate
DCoDsputDbtCollsActyIsCrted /DCO/I_Dispute DCoDsputDbtCollsActyIsCrted
DCoPredecessorServiceRequest /DCO/I_Dispute DCoPredecessorServiceRequest
DCoDebtCollectionsActivity /DCO/I_Dispute DCoDebtCollectionsActivity
DCoDsputOrigntgInbComm /DCO/I_Dispute DCoDsputOrigntgInbComm
DCoPredecessorDispute /DCO/I_Dispute DCoPredecessorDispute
DCoDisputeAssgdServiceRequest /DCO/I_Dispute DCoDisputeAssgdServiceRequest
DCoDsputCustomerInteraction /DCO/I_Dispute DCoDsputCustomerInteraction
DCoDisputedSumAmount /DCO/I_Dispute DCoDisputedSumAmount
DCoDisputeCorrectionSumAmount /DCO/I_Dispute DCoDisputeCorrectionSumAmount
DCoDsputToBeWrittenOffSumAmt /DCO/I_Dispute DCoDsputToBeWrittenOffSumAmt
DCoDsputAcctgDocColltdSumAmt /DCO/I_Dispute DCoDsputAcctgDocColltdSumAmt
DCoDisputeCreationUser /DCO/I_Dispute DCoDisputeCreationUser User
DCoDisputeCreationDateTime /DCO/I_Dispute DCoDisputeCreationDateTime Timestamp
DCoDisputeLastChangedByUser /DCO/I_Dispute DCoDisputeLastChangedByUser Last Changed By
DCoDisputeLastChangeDateTime /DCO/I_Dispute DCoDisputeLastChangeDateTime Time Stamp
DCoDisputeClosedByUser /DCO/I_Dispute DCoDisputeClosedByUser User close
DCoDisputeClosingDateTime /DCO/I_Dispute DCoDisputeClosingDateTime
DCoDisputeDecidedByUser /DCO/I_Dispute DCoDisputeDecidedByUser
DCoDisputeDecisionDateTime /DCO/I_Dispute DCoDisputeDecisionDateTime
BusinessPartnerName
DCoCompanyCodeName
DCoDisputeCustCntctPersonName
DCoDisputeCreationUserName
DCoDisputeLastChgdByUserName
DCoDisputeClosedByUserName
DCoDisputeDecidedByUserName
DCoDisputeProcessorName
DCoDisputeProcCoordinatorName
DCoDisputeRespPersonName
DCoDisputeEscalationReasonName
DCoDisputePriorityName
DCoDisputeProcessStepName
DCoDisputeCurrencyName
DCoDisputeProcessStepStsName
DCoDisputeProcessorGroupName
IsDraftEntity
DCoDisputeCriticality
_AccountingDocument _AccountingDocument
DCoAccountingDocumentUUID
KEY DCoDisputeUUID /DCO/I_DisputeAcctgDocDraft DCoDisputeUUID UUID
DebtCollectionsDispute /DCO/I_DisputeDraft DebtCollectionsDispute WEBGUI External ID
BusinessPartner /DCO/I_DisputeDraft BusinessPartner Issuing Authority
DebtCollectionsCompanyCode /DCO/I_DisputeDraft DebtCollectionsCompanyCode Company Code
DCoDisputeProcessStep /DCO/I_DisputeDraft DCoDisputeProcessStep Process Step
DCoDisputeProcessStepStatus /DCO/I_DisputeDraft DCoDisputeProcessStepStatus
DCoDisputePriority /DCO/I_DisputeDraft DCoDisputePriority Workflow priority
DCoDisputeEscalationReason /DCO/I_DisputeDraft DCoDisputeEscalationReason
DCoDisputeEscalationLevelValue /DCO/I_DisputeDraft DCoDisputeEscalationLevelValue
DCoDisputeCurrency /DCO/I_DisputeDraft DCoDisputeCurrency Valuation Crcy
DCoDisputeProcessor /DCO/I_DisputeDraft DCoDisputeProcessor User Name
DCoDisputeProcessorGroup /DCO/I_DisputeDraft DCoDisputeProcessorGroup
DCoDisputeProcessCoordinator /DCO/I_DisputeDraft DCoDisputeProcessCoordinator
DCoDisputeResponsiblePerson /DCO/I_DisputeDraft DCoDisputeResponsiblePerson User Name
DCoDisputeCustContactPerson /DCO/I_DisputeDraft DCoDisputeCustContactPerson
DCoDisputeProcStepDeadlineDate /DCO/I_DisputeDraft DCoDisputeProcStepDeadlineDate
DCoDisputePlannedCloseDate /DCO/I_DisputeDraft DCoDisputePlannedCloseDate
DCoDsputDbtCollsActyIsCrted /DCO/I_DisputeDraft DCoDsputDbtCollsActyIsCrted
DCoPredecessorServiceRequest /DCO/I_DisputeDraft DCoPredecessorServiceRequest
DCoDebtCollectionsActivity /DCO/I_DisputeDraft DCoDebtCollectionsActivity
DCoDsputOrigntgInbComm /DCO/I_DisputeDraft DCoDsputOrigntgInbComm
DCoPredecessorDispute /DCO/I_DisputeDraft DCoPredecessorDispute
DCoDisputeAssgdServiceRequest /DCO/I_DisputeDraft DCoDisputeAssgdServiceRequest
DCoDsputCustomerInteraction /DCO/I_DisputeDraft DCoDsputCustomerInteraction
DCoDisputedSumAmount /DCO/I_DisputeDraft DCoDisputedSumAmount
DCoDisputeCorrectionSumAmount /DCO/I_DisputeDraft DCoDisputeCorrectionSumAmount
DCoDsputToBeWrittenOffSumAmt /DCO/I_DisputeDraft DCoDsputToBeWrittenOffSumAmt
DCoDsputAcctgDocColltdSumAmt /DCO/I_DisputeDraft DCoDsputAcctgDocColltdSumAmt
DCoDisputeCreationUser /DCO/I_DisputeDraft DCoDisputeCreationUser User
DCoDisputeCreationDateTime /DCO/I_DisputeDraft DCoDisputeCreationDateTime Timestamp
DCoDisputeLastChangedByUser /DCO/I_DisputeDraft DCoDisputeLastChangedByUser Last Changed By
DCoDisputeLastChangeDateTime /DCO/I_DisputeDraft DCoDisputeLastChangeDateTime Time Stamp
DCoDisputeClosedByUser /DCO/I_DisputeDraft DCoDisputeClosedByUser User close
DCoDisputeClosingDateTime /DCO/I_DisputeDraft DCoDisputeClosingDateTime
DCoDisputeDecidedByUser /DCO/I_DisputeDraft DCoDisputeDecidedByUser
DCoDisputeDecisionDateTime /DCO/I_DisputeDraft DCoDisputeDecisionDateTime
BusinessPartnerName
DCoCompanyCodeName
DCoDisputeCustCntctPersonName
DCoDisputeCreationUserName
DCoDisputeLastChgdByUserName
DCoDisputeClosedByUserName
DCoDisputeDecidedByUserName
DCoDisputeProcessorName
DCoDisputeProcCoordinatorName
DCoDisputeRespPersonName
DCoDisputeEscalationReasonName
DCoDisputePriorityName
DCoDisputeProcessStepName
DCoDisputeCurrencyName
DCoDisputeProcessStepStsName
DCoDisputeProcessorGroupName
IsDraftEntity
DCoDisputeCriticality
_AccountingDocument _AccountingDocument
_BusinessPartner /DCO/I_DisputeDraft _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 /DCO/I_AcctgDocRelatedDispute.
-- 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 /DCO/I_AcctgDocRelatedDispute AS
SELECT
  /DCO/I_AccountingDocument.DCoAccountingDocumentUUID AS DCoAccountingDocumentUUID,
  /DCO/I_DsputAccountingDocument.DCoDisputeUUID AS DCoDisputeUUID,
  /DCO/I_Dispute.DebtCollectionsDispute AS DebtCollectionsDispute,
  /DCO/I_Dispute.BusinessPartner AS BusinessPartner,
  /DCO/I_Dispute.DebtCollectionsCompanyCode AS DebtCollectionsCompanyCode,
  /DCO/I_Dispute.DCoDisputeProcessStep AS DCoDisputeProcessStep,
  /DCO/I_Dispute.DCoDisputeProcessStepStatus AS DCoDisputeProcessStepStatus,
  /DCO/I_Dispute.DCoDisputePriority AS DCoDisputePriority,
  /DCO/I_Dispute.DCoDisputeEscalationReason AS DCoDisputeEscalationReason,
  /DCO/I_Dispute.DCoDisputeEscalationLevelValue AS DCoDisputeEscalationLevelValue,
  /DCO/I_Dispute.DCoDisputeCurrency AS DCoDisputeCurrency,
  /DCO/I_Dispute.DCoDisputeProcessor AS DCoDisputeProcessor,
  /DCO/I_Dispute.DCoDisputeProcessorGroup AS DCoDisputeProcessorGroup,
  /DCO/I_Dispute.DCoDisputeProcessCoordinator AS DCoDisputeProcessCoordinator,
  /DCO/I_Dispute.DCoDisputeResponsiblePerson AS DCoDisputeResponsiblePerson,
  /DCO/I_Dispute.DCoDisputeCustContactPerson AS DCoDisputeCustContactPerson,
  /DCO/I_Dispute.DCoDisputeProcStepDeadlineDate AS DCoDisputeProcStepDeadlineDate,
  /DCO/I_Dispute.DCoDisputePlannedCloseDate AS DCoDisputePlannedCloseDate,
  /DCO/I_Dispute.DCoDsputDbtCollsActyIsCrted AS DCoDsputDbtCollsActyIsCrted,
  /DCO/I_Dispute.DCoPredecessorServiceRequest AS DCoPredecessorServiceRequest,
  /DCO/I_Dispute.DCoDebtCollectionsActivity AS DCoDebtCollectionsActivity,
  /DCO/I_Dispute.DCoDsputOrigntgInbComm AS DCoDsputOrigntgInbComm,
  /DCO/I_Dispute.DCoPredecessorDispute AS DCoPredecessorDispute,
  /DCO/I_Dispute.DCoDisputeAssgdServiceRequest AS DCoDisputeAssgdServiceRequest,
  /DCO/I_Dispute.DCoDsputCustomerInteraction AS DCoDsputCustomerInteraction,
  /DCO/I_Dispute.DCoDisputedSumAmount AS DCoDisputedSumAmount,
  /DCO/I_Dispute.DCoDisputeCorrectionSumAmount AS DCoDisputeCorrectionSumAmount,
  /DCO/I_Dispute.DCoDsputToBeWrittenOffSumAmt AS DCoDsputToBeWrittenOffSumAmt,
  /DCO/I_Dispute.DCoDsputAcctgDocColltdSumAmt AS DCoDsputAcctgDocColltdSumAmt,
  /DCO/I_Dispute.DCoDisputeCreationUser AS DCoDisputeCreationUser,
  /DCO/I_Dispute.DCoDisputeCreationDateTime AS DCoDisputeCreationDateTime,
  /DCO/I_Dispute.DCoDisputeLastChangedByUser AS DCoDisputeLastChangedByUser,
  /DCO/I_Dispute.DCoDisputeLastChangeDateTime AS DCoDisputeLastChangeDateTime,
  /DCO/I_Dispute.DCoDisputeClosedByUser AS DCoDisputeClosedByUser,
  /DCO/I_Dispute.DCoDisputeClosingDateTime AS DCoDisputeClosingDateTime,
  /DCO/I_Dispute.DCoDisputeDecidedByUser AS DCoDisputeDecidedByUser,
  /DCO/I_Dispute.DCoDisputeDecisionDateTime AS DCoDisputeDecisionDateTime,
  /DCO/I_Dispute._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  /DCO/I_Dispute._CompanyCode._Text[ 1: Language = $session.system_language ].DCoCompanyCodeName AS DCoCompanyCodeName,
  /DCO/I_Dispute._CustomerContactPerson.BusinessPartnerName AS DCoDisputeCustCntctPersonName,
  /DCO/I_Dispute._DisputeCreationUser.UserDescription AS DCoDisputeCreationUserName,
  /DCO/I_Dispute._DisputeLastChangedByUser.UserDescription AS DCoDisputeLastChgdByUserName,
  /DCO/I_Dispute._DisputeClosedByUser.UserDescription AS DCoDisputeClosedByUserName,
  /DCO/I_Dispute._DisputeDecidedByUser.UserDescription AS DCoDisputeDecidedByUserName,
  /DCO/I_Dispute._DisputeProcessor.PersonFullName AS DCoDisputeProcessorName,
  /DCO/I_Dispute._DisputeProcessCoordinator.PersonFullName AS DCoDisputeProcCoordinatorName,
  /DCO/I_Dispute._DisputeResponsiblePerson.PersonFullName AS DCoDisputeRespPersonName,
  /DCO/I_Dispute._DisputeEscalationReason._Text[ 1: Language = $session.system_language ].DCoDisputeEscalationReasonName AS DCoDisputeEscalationReasonName,
  /DCO/I_Dispute._DisputePriority._Text[ 1: Language = $session.system_language ].DCoDisputePriorityName AS DCoDisputePriorityName,
  /DCO/I_Dispute._DisputeProcessStep._Text[ 1: Language = $session.system_language ].DCoDisputeProcessStepName AS DCoDisputeProcessStepName,
  /DCO/I_Dispute._Currency._Text[ 1: Language = $session.system_language ].CurrencyName AS DCoDisputeCurrencyName,
  /DCO/I_Dispute._DisputeProcessStepStatus._Text[ 1: Language = $session.system_language ].DCoDisputeProcessStepStsName AS DCoDisputeProcessStepStsName,
  /DCO/I_Dispute._DisputeProcessorTeam.DCoDisputeProcessorGroupName AS DCoDisputeProcessorGroupName,
  cast ( '' as /dco/dispute_is_draft_entity preserving type ) AS IsDraftEntity,
  cast ( 0 as /dco/dispute_criticality preserving type ) AS DCoDisputeCriticality,
  /DCO/I_DisputeDraft._BusinessPartner AS _BusinessPartner
INNER JOIN /DCO/I_Dispute ON /* join condition not captured in parsed metadata */
INNER JOIN /DCO/I_AccountingDocument ON /* join condition not captured in parsed metadata */
INNER JOIN I_DraftAdministrativeData ON /* join condition not captured in parsed metadata */
INNER JOIN /DCO/I_DisputeDraft ON /* join condition not captured in parsed metadata */
;