I_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 I_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: ICADCTP

CREATE VIEW I_CADisputeCaseTP AS
SELECT
  I_CADisputeCase.CaseUUID AS CaseUUID,
  I_CADisputeCase.CaseID AS CaseID,
  I_CADisputeCase.BusinessPartner AS BusinessPartner,
  I_CADisputeCase.CAContract AS CAContract,
  I_CADisputeCase.ContractAccount AS ContractAccount,
  I_CADisputeCase.CAApplicationArea AS CAApplicationArea,
  cast( CASubApplication as subap_kk ) AS CASubApplication,
  I_CADisputeCase.DisputedAmount AS DisputedAmount,
  I_CADisputeCase.TotalReceivablesAmount AS TotalReceivablesAmount,
  I_CADisputeCase.DisputeCaseCorrectionAmount AS DisputeCaseCorrectionAmount,
  I_CADisputeCase.DisputeCaseReversedAmount AS DisputeCaseReversedAmount,
  I_CADisputeCase.CreditedAmount AS CreditedAmount,
  I_CADisputeCase.WriteOffAmount AS WriteOffAmount,
  I_CADisputeCase.DisputeCaseReplacedAmount AS DisputeCaseReplacedAmount,
  I_CADisputeCase.PaidAmount AS PaidAmount,
  I_CADisputeCase.CARemainingDisputedAmount AS CARemainingDisputedAmount,
  I_CADisputeCase.DisputeCaseCurrency AS DisputeCaseCurrency,
  I_CADisputeCase.LogicalSystem AS LogicalSystem,
  CADisputeType,
  I_CADisputeCase.CADisputeTypeText AS CADisputeTypeText,
  I_CADisputeCase.CompanyCode AS CompanyCode,
  I_CADisputeCase.DisputeCaseCoordinator AS DisputeCaseCoordinator,
  CaseRootCauseDescription,
  I_CADisputeCase.DisputeCaseRootCause AS DisputeCaseRootCause,
  MissingDocCaseRootCause,
  IncorrectDocCaseRootCause,
  I_CADisputeCase.CaseProcessingDeadlineDate AS CaseProcessingDeadlineDate,
  I_CADisputeCase.ContactPersonFullName AS ContactPersonFullName,
  I_CADisputeCase.ContactPersonEmailAddress AS ContactPersonEmailAddress,
  I_CADisputeCase.ContactPersonPhoneNumber AS ContactPersonPhoneNumber,
  I_CADisputeCase.ContactPersonFaxNumber AS ContactPersonFaxNumber,
  I_CADisputeCase.ContactPersonFaxCountry AS ContactPersonFaxCountry,
  I_CADisputeCase.CaseType AS CaseType,
  I_CADisputeCase.CaseExternalReference AS CaseExternalReference,
  I_CADisputeCase.CaseCreatedBy AS CaseCreatedBy,
  I_CADisputeCase.CaseCreationDate AS CaseCreationDate,
  I_CADisputeCase.CaseLastChangedBy AS CaseLastChangedBy,
  I_CADisputeCase.CaseLastChangedOn AS CaseLastChangedOn,
  I_CADisputeCase.CaseClosedBy AS CaseClosedBy,
  I_CADisputeCase.CaseClosedTime AS CaseClosedTime,
  I_CADisputeCase.CasePlannedCloseDate AS CasePlannedCloseDate,
  I_CADisputeCase.CaseProcessor AS CaseProcessor,
  I_CADisputeCase.CaseResponsible AS CaseResponsible,
  I_CADisputeCase.CaseTitle AS CaseTitle,
  CACaseEscltnRsnForMissingDoc,
  CACaseEscltnRsnForIncorrectDoc,
  CaseEscalationReason,
  DsputCaseEscalationRsnName,
  I_CADisputeCase.CaseCategory AS CaseCategory,
  MissingDocCaseCategory,
  IncorrectDocCaseCategory,
  DisputeCaseCategoryName,
  I_CADisputeCase.CasePriority AS CasePriority,
  DisputeCasePriorityName,
  I_CADisputeCase.CaseAuthorizationLevel AS CaseAuthorizationLevel,
  I_CADisputeCase.CaseStatus AS CaseStatus,
  MissingDocumentCaseStatus,
  IncorrectDocumentCaseStatus,
  CaseStatusName,
  I_CADisputeCase.CaseSystemStatus AS CaseSystemStatus,
  I_CADisputeCase.CaseUserStatusName AS CaseUserStatusName,
  I_CADisputeCase.CaseReason AS CaseReason,
  I_CADisputeCase.CaseReason AS MissingDocCaseReason,
  I_CADisputeCase.CaseReason AS IncorrectDocCaseReason,
  DisputeCaseInformationText,
  I_CADisputeCase.DisputeCaseTransactionDate AS DisputeCaseTransactionDate,
  I_CADisputeCase.CADisputeCase AS CADisputeCase,
  CaseReasonName,
  I_CADisputeCase.BusinessPartnerFullName AS BusinessPartnerFullName,
  I_CADisputeCase.ContractAccountName AS ContractAccountName,
  I_CADisputeCase.CompanyCodeName AS CompanyCodeName,
  cast(concat_with_space( I_CADisputeCase.StreetName, I_CADisputeCase.HouseNumber, 1) as secdep_house_number_kk ) AS AddressLine1,
  cast(concat_with_space( I_CADisputeCase.PostalCode, I_CADisputeCase.CityName, 1) as secdep_home_town_kk) AS AddressLine2,
  I_CADisputeCase.CountryName AS CountryName,
  UserDescription,
  I_CADisputeCase.CaseStatusProfile AS CaseStatusProfile,
  CACaseConversionStatus,
  CaseIsDisplayOnly,
  CaseIsClosed,
  CADisputeCaseProcessingIsActv,
  cast('' as opbel_gfn_kk) AS CADocumentNumber,
  cast( 'X' as boole_d preserving type ) AS CADisputeCaseCreateIsHidden,
  cast( 'X' as boole_d preserving type ) AS CADisputeCaseEditIsHidden,
  cast( ' ' as boole_d preserving type ) AS CADisputeCaseDisplayIsHidden,
  '' AS UserDefinedText
FROM I_CADisputeCase
LEFT OUTER JOIN I_CADisputeCaseFllwUpPostingTP AS _FollowPosting ON CaseUUID = _FollowPosting.CaseUniqueID  -- association [0..*]
LEFT OUTER JOIN I_CADisputedPaymentTP AS _Payment ON CaseUUID = _Payment.CaseUniqueID  -- association [0..*]
LEFT OUTER JOIN I_CADisputedCreditTP AS _Credit ON CaseUUID = _Credit.CaseUniqueID  -- association [0..*]
LEFT OUTER JOIN I_CADisputedDocumentTP AS _CADisputedDocument ON CaseUUID = _CADisputedDocument.CaseUniqueID  -- association [0..*]
LEFT OUTER JOIN E_CADisputeCase AS _Extension ON CaseUUID = _Extension.CaseUUID  -- association [1..1]
;