I_CADisputeCase

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_CADisputeCase.
-- 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: ICADISPUTECASE

CREATE VIEW I_CADisputeCase AS
SELECT
  CaseUUID,
  BusinessPartner,
  ContractAccount,
  cast ( ltrim( CAContract,'0') as fica_vtref preserving type ) AS CAContract,
  CAApplicationArea,
  cast( CASubApplication as subap_kk ) AS CASubApplication,
  DisputedAmount,
  TotalReceivablesAmount,
  DisputeCaseCorrectionAmount,
  DisputeCaseReversedAmount,
  CreditedAmount,
  WriteOffAmount,
  DisputeCaseReplacedAmount,
  PaidAmount,
  CARemainingDisputedAmount,
  DisputeCaseCurrency,
  LogicalSystem,
  CompanyCode,
  DisputeCaseCoordinator,
  _DisputeCaseCoordinator.UserDescription AS DsputCaseCoordinatorFullName,
  DisputeCaseRootCause,
  _RootCause._Text[1:Language = $session.system_language].CaseRootCauseDescription AS CaseRootCauseDescription,
  DisputeCaseRootCause AS MissingDocCaseRootCause,
  DisputeCaseRootCause AS IncorrectDocCaseRootCause,
  CaseProcessingDeadlineDate,
  ContactPersonFullName,
  ContactPersonEmailAddress,
  ContactPersonPhoneNumber,
  ContactPersonFaxNumber,
  ContactPersonFaxCountry,
  DisputeCaseBPCorrespondenceKey,
  DisputeCaseInformationText,
  DisputeCaseTransactionDate,
  cast( CADisputeType as fica_dispute_type_gfn ) AS CADisputeType,
  CADisputeCase,
  CaseType,
  CaseID,
  CaseExternalReference,
  CaseCreatedBy,
  _CaseCreatedBy.UserDescription AS CaseCreatedByUserName,
  CaseCreationDate,
  CaseLastChangedBy,
  _CaseLastChangedBy.UserDescription AS CaseLastChangedByUserName,
  cast( CaseLastChangedOn as coll_pr_changed_at preserving type ) AS CaseLastChangedOn,
  CaseStatusProfile,
  CaseClosedBy,
  _CaseClosedBy.UserDescription AS CaseClosedByUserName,
  CaseClosedTime,
  CasePlannedCloseDate,
  CaseProcessor,
  _CaseProcessor.UserDescription AS CaseProcessorName,
  CaseResponsible,
  _CaseResponsible.UserDescription AS CaseResponsibleName,
  CaseTitle,
  CaseAuthorizationLevel,
  CaseStatus,
  CaseStatus AS MissingDocumentCaseStatus,
  CaseStatus AS IncorrectDocumentCaseStatus,
  cast(_CaseIndividualStatusText[1:Language = $session.system_language].CaseStatusName as scmgstat_descr_gfn) AS CaseStatusName,
  CaseSystemStatus,
  CaseUserStatusName,
  CasePriority,
  DisputeCasePriorityName,
  CaseCategory,
  DisputeCaseCategoryName,
  CaseCategory AS MissingDocCaseCategory,
  CaseCategory AS IncorrectDocCaseCategory,
  CaseReason,
  CaseReasonName,
  CaseReason AS MissingDocCaseReason,
  CaseReason AS IncorrectDocCaseReason,
  CACaseEscltnRsnForMissingDoc,
  CACaseEscltnRsnForIncorrectDoc,
  CaseEscalationReason,
  DsputCaseEscalationRsnName,
  CADisputeTypeText,
  BusinessPartnerFullName,
  StreetName,
  HouseNumber,
  CountryName,
  PostalCode,
  CityName,
  ContractAccountName,
  CompanyCodeName,
  CACaseConversionStatus,
  CaseIsDisplayOnly,
  CaseIsClosed,
  CADisputeCaseProcessingIsActv,
  DisputeCaseOrigin,
  CADisputeCaseOrigin,
  _CaseOriginText[1:Language = $session.system_language].CADisputeCaseOriginText AS CADisputeCaseOriginText,
  _CaseTypes.CaseAttributeProfile AS CaseAttributeProfile,
  _CaseProcessor.UserDescription AS UserDescription
FROM P_CADisputeCaseAttribute
LEFT OUTER JOIN I_User AS _CaseProcessor ON CaseProcessor = _CaseProcessor.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _CaseResponsible ON CaseResponsible = _CaseResponsible.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _DisputeCaseCoordinator ON DisputeCaseCoordinator = _DisputeCaseCoordinator.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _CaseCreatedBy ON CaseCreatedBy = _CaseCreatedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _CaseLastChangedBy ON CaseLastChangedBy = _CaseLastChangedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _CaseClosedBy ON CaseClosedBy = _CaseClosedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_RootCause AS _RootCause ON CaseType = _RootCause.CaseType AND DisputeCaseRootCause = _RootCause.DisputeCaseRootCause  -- association [1..1]
LEFT OUTER JOIN I_CaseIndivStatusText AS _CaseIndividualStatusText ON CaseStatusProfile = _CaseIndividualStatusText.CaseStatusProfile AND CaseStatus = _CaseIndividualStatusText.CaseStatus  -- association [0..*]
LEFT OUTER JOIN I_CADisputeCaseOriginText AS _CaseOriginText ON CADisputeCaseOrigin = _CaseOriginText.CADisputeCaseOrigin  -- association [0..*]
LEFT OUTER JOIN I_CountryText AS _ContactPersonFaxCountryText ON ContactPersonFaxCountry = _ContactPersonFaxCountryText.Country  -- association [0..*]
LEFT OUTER JOIN I_CASubApplicationText AS _CASubApplicationText ON CASubApplication = _CASubApplicationText.CASubApplication  -- association [0..*]
;