C_CADisputeCaseTP

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_CADisputeCaseTP.
-- 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.
-- SQL view name: CDISPUTECASE

CREATE VIEW C_CADisputeCaseTP AS
SELECT
  _CADisputeCaseTP.CaseUUID AS CaseUUID,
  CaseType,
  _CADisputeCaseTP.BusinessPartner AS BusinessPartner,
  _CADisputeCaseTP.ContractAccount AS ContractAccount,
  _CADisputeCaseTP.CAContract AS CAContract,
  _CADisputeCaseTP.CaseID AS CaseID,
  _CADisputeCaseTP.CaseStatus AS CaseStatus,
  MissingDocumentCaseStatus,
  IncorrectDocumentCaseStatus,
  _CADisputeCaseTP.CaseStatusName AS CaseStatusName,
  CaseSystemStatus,
  _CADisputeCaseTP.CADisputeType AS CADisputeType,
  _CADisputeCaseTP.CADisputeTypeText AS CADisputeTypeText,
  _CADisputeCaseTP.CaseCategory AS CaseCategory,
  _CADisputeCaseTP.IncorrectDocCaseCategory AS IncorrectDocCaseCategory,
  _CADisputeCaseTP.MissingDocCaseCategory AS MissingDocCaseCategory,
  _CADisputeCaseTP.DisputeCaseCategoryName AS DisputeCaseCategoryName,
  _CADisputeCaseTP.CADisputeCase AS CADisputeCase,
  _CADisputeCaseTP.CasePriority AS CasePriority,
  _CADisputeCaseTP.DisputeCasePriorityName AS DisputeCasePriorityName,
  _CADisputeCaseTP.DisputedAmount AS DisputedAmount,
  _CADisputeCaseTP.DisputeCaseCorrectionAmount AS DisputeCaseCrrtnProgressAmount,
  _CADisputeCaseTP.DisputeCaseCorrectionAmount AS DisputeCaseCorrectionAmount,
  _CADisputeCaseTP.TotalReceivablesAmount AS TotalReceivablesAmount,
  _CADisputeCaseTP.CARemainingDisputedAmount AS CARemainingDisputedAmount,
  _CADisputeCaseTP.DisputeCaseReversedAmount AS DisputeCaseReversedAmount,
  _CADisputeCaseTP.CreditedAmount AS CreditedAmount,
  _CADisputeCaseTP.WriteOffAmount AS WriteOffAmount,
  _CADisputeCaseTP.DisputeCaseReplacedAmount AS DisputeCaseReplacedAmount,
  _CADisputeCaseTP.CaseProcessor AS CaseProcessor,
  _CADisputeCaseTP.CaseCreatedBy AS CaseCreatedBy,
  _CADisputeCaseTP.CaseCreationDate AS CaseCreationDate,
  CaseLastChangedBy,
  CaseLastChangedOn,
  CaseClosedBy,
  CaseClosedTime,
  _CADisputeCaseTP.CaseReason AS CaseReason,
  _CADisputeCaseTP.IncorrectDocCaseReason AS IncorrectDocCaseReason,
  _CADisputeCaseTP.MissingDocCaseReason AS MissingDocCaseReason,
  _CADisputeCaseTP.CaseReasonName AS CaseReasonName,
  _CADisputeCaseTP.DisputeCaseInformationText AS DisputeCaseInformationText,
  _CADisputeCaseTP.DisputeCaseTransactionDate AS DisputeCaseTransactionDate,
  _CADisputeCaseTP.CaseProcessingDeadlineDate AS CaseProcessingDeadlineDate,
  _CADisputeCaseTP.CaseTitle AS CaseTitle,
  _CADisputeCaseTP.CasePlannedCloseDate AS CasePlannedCloseDate,
  _CADisputeCaseTP.DisputeCaseCurrency AS DisputeCaseCurrency,
  _CADisputeCaseTP.BusinessPartnerFullName AS BusinessPartnerFullName,
  _CADisputeCaseTP.CompanyCode AS CompanyCode,
  _CADisputeCaseTP.CompanyCodeName AS CompanyCodeName,
  _CADisputeCaseTP.ContractAccountName AS ContractAccountName,
  _CADisputeCaseTP.AddressLine1 AS AddressLine1,
  _CADisputeCaseTP.AddressLine2 AS AddressLine2,
  _CADisputeCaseTP.CountryName AS CountryName,
  _CADisputeCaseTP.CASubApplication AS CASubApplication,
  _CADisputeCaseTP.CaseExternalReference AS CaseExternalReference,
  CaseEscalationReason,
  _CADisputeCaseTP.CACaseEscltnRsnForMissingDoc AS CACaseEscltnRsnForMissingDoc,
  _CADisputeCaseTP.CACaseEscltnRsnForIncorrectDoc AS CACaseEscltnRsnForIncorrectDoc,
  _CADisputeCaseTP.DsputCaseEscalationRsnName AS DsputCaseEscalationRsnName,
  _CADisputeCaseTP.DisputeCaseCoordinator AS DisputeCaseCoordinator,
  _CADisputeCaseTP.CaseResponsible AS CaseResponsible,
  _CADisputeCaseTP.DisputeCaseRootCause AS DisputeCaseRootCause,
  _CADisputeCaseTP.IncorrectDocCaseRootCause AS IncorrectDocCaseRootCause,
  _CADisputeCaseTP.MissingDocCaseRootCause AS MissingDocCaseRootCause,
  _CADisputeCaseTP.CaseRootCauseDescription AS CaseRootCauseDescription,
  _CADisputeCaseTP.CADocumentNumber AS CADocumentNumber,
  _CADisputeCaseTP.ContactPersonFullName AS ContactPersonFullName,
  _CADisputeCaseTP.ContactPersonEmailAddress AS ContactPersonEmailAddress,
  _CADisputeCaseTP.ContactPersonPhoneNumber AS ContactPersonPhoneNumber,
  _CADisputeCaseTP.ContactPersonFaxNumber AS ContactPersonFaxNumber,
  _CADisputeCaseTP.ContactPersonFaxCountry AS ContactPersonFaxCountry,
  CADisputeCaseCreateIsHidden,
  CADisputeCaseEditIsHidden,
  CADisputeCaseDisplayIsHidden,
  UserDefinedText,
  CACaseConversionStatus,
  CaseIsDisplayOnly,
  CaseIsClosed,
  CADisputeCaseProcessingIsActv,
  cast( '' as xdamnt_open) AS DisputeIsBasedOnOpenAmount,
  cast('' as is_cloud_system ) AS IsCloudSystem
FROM I_CADisputeCaseTP AS _CADisputeCaseTP
LEFT OUTER JOIN C_CADisputedPaymentTP AS _Payment ON CaseUUID = _Payment.CaseUniqueID  -- association [0..*]
LEFT OUTER JOIN C_CADisputedCreditTP AS _Credit ON CaseUUID = _Credit.CaseUniqueID  -- association [0..*]
LEFT OUTER JOIN C_CADisputedDocumentTP AS _CADisputedDocument ON CaseUUID = _CADisputedDocument.CaseUniqueID  -- association [0..*]
LEFT OUTER JOIN C_CADisputeCaseFllwUpPostingTP AS _FollowPosting ON CaseUUID = _FollowPosting.CaseUniqueID  -- association [0..*]
LEFT OUTER JOIN C_CAInvcgUserContact AS _Processor ON CaseProcessor = _Processor.ContactCardID  -- association [0..1]
LEFT OUTER JOIN C_CAInvcgUserContact AS _CreatedBy ON CaseCreatedBy = _CreatedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN C_CAInvcgUserContact AS _Responsible ON CaseResponsible = _Responsible.ContactCardID  -- association [0..1]
LEFT OUTER JOIN C_CAInvcgUserContact AS _Coordinator ON DisputeCaseCoordinator = _Coordinator.ContactCardID  -- association [0..1]
LEFT OUTER JOIN C_CANotDisputedClearedDoc AS _ClearedDoc ON ContractAccount = _ClearedDoc.ContractAccount AND BusinessPartner = _ClearedDoc.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN C_CANotDisputedOpenDoc AS _OpenDoc ON ContractAccount = _OpenDoc.ContractAccount AND BusinessPartner = _OpenDoc.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN C_CANotDisputedPayment AS _NotDisPayment ON ContractAccount = _NotDisPayment.ContractAccount AND BusinessPartner = _NotDisPayment.BusinessPartner AND CAContract = _NotDisPayment.CAContract  -- association [0..*]
LEFT OUTER JOIN C_CANotDisputedCredit AS _NotDisCredit ON ContractAccount = _NotDisCredit.ContractAccount AND BusinessPartner = _NotDisCredit.BusinessPartner AND CAContract = _NotDisCredit.CAContract  -- association [0..*]
LEFT OUTER JOIN C_CADisputeCaseChangeHist AS _ChangeHistory ON CaseUUID = _ChangeHistory.DisputeCaseUUID  -- association [0..*]
LEFT OUTER JOIN C_CANotDisputedCreditMemo AS _NotDisCreditMemo ON ContractAccount = _NotDisCreditMemo.ContractAccount AND BusinessPartner = _NotDisCreditMemo.BusinessPartner AND CAContract = _NotDisCreditMemo.CAContract AND CaseUUID = _NotDisCreditMemo.CaseUUID AND CompanyCode = _NotDisCreditMemo.CompanyCode  -- association [0..*]
LEFT OUTER JOIN C_CANotDisputedDocument AS _NotDisDocument ON ContractAccount = _NotDisDocument.ContractAccount AND BusinessPartner = _NotDisDocument.BusinessPartner AND CAContract = _NotDisDocument.CAContract AND CaseUUID = _NotDisDocument.CaseUUID AND CompanyCode = _NotDisDocument.CompanyCode  -- association [0..*]
;