I_DisputeCaseDraft

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_DisputeCaseDraft.
-- 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 I_DisputeCaseDraft AS
SELECT
  DraftUUID,
  DisputeCaseUUID,
  DisputeCaseCoordinator,
  DisputeCaseRootCause,
  CaseProcessingDeadlineDate,
  OriginalAmount,
  DisputedAmount,
  PaidAmount,
  CreditedAmount,
  WriteOffAmount,
  ManuallyClearedAmount,
  DisputeCaseCurrency,
  CustomerDisputedAmount,
  CustomerDisputedCurrency,
  ContactPersonName,
  ContactPersonEmailAddress,
  ContactPersonPhoneNumber,
  ContactPersonFaxNumber,
  ContactPersonFaxCountry,
  ContactPerson,
  Customer,
  CompanyCode,
  DisputeCaseExternalApplication,
  CaseType,
  CaseID,
  CaseExternalReference,
  CaseCreatedBy,
  cast( casecreatedon as udmo_create_time ) AS CaseCreatedOn,
  CaseLastChangedBy,
  cast( caselastchangedon as udmo_change_time ) AS CaseLastChangedOn,
  CaseClosedBy,
  cast( caseclosedtime as udmo_closing_time ) AS CaseClosedTime,
  CasePlannedCloseDate,
  CaseProcessor,
  CaseResponsible,
  CaseTitle,
  CaseEscalationReason,
  CaseCategory,
  CasePriority,
  CaseAuthorizationLevel,
  CaseStatusProfile,
  CaseStatus,
  CaseSystemStatus,
  CaseReason,
  HasActiveEntity,
  draftentitycreationdatetime AS DraftCreationDateTime,
  draftentitylastchangedatetime AS DraftLastChangedDateTime,
  DraftAdministrativeDataUUID
FROM dispcasedra
LEFT OUTER JOIN I_UserContactCard AS _DisputeCaseCoordinatorCard ON DisputeCaseCoordinator = _DisputeCaseCoordinatorCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_DisputeCaseExternalAppl AS _DisputeCaseExternalAppl ON DisputeCaseExternalApplication = _DisputeCaseExternalAppl.DisputeCaseExternalApplication  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON ContactPersonFaxCountry = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_RootCause AS _RootCause ON DisputeCaseRootCause = _RootCause.DisputeCaseRootCause AND CaseType = _RootCause.CaseType  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByContactCard ON CaseCreatedBy = _CreatedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ChangedByContactCard ON CaseLastChangedBy = _ChangedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ClosedByContactCard ON CaseClosedBy = _ClosedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ProcessorContactCard ON CaseProcessor = _ProcessorContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ResponsibleContactCard ON CaseResponsible = _ResponsibleContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_Caseentity AS _CaseEntity ON CaseID = _CaseEntity.CaseUniqueID  -- association [0..1]
LEFT OUTER JOIN I_Casetypes AS _CaseTypes ON CaseType = _CaseTypes.CaseType  -- association [0..1]
LEFT OUTER JOIN I_CaseEscalationReason AS _Escalation ON CaseEscalationReason = _Escalation.CaseEscalationReason  -- association [0..1]
LEFT OUTER JOIN I_CaseCategory AS _CaseCategory ON CaseCategory = _CaseCategory.CaseCategory AND CaseType = _CaseCategory.CaseType  -- association [0..1]
LEFT OUTER JOIN I_CasePriority AS _Priority ON CasePriority = _Priority.CasePriority  -- association [0..1]
LEFT OUTER JOIN I_Caseauthorizationlevel AS _AuthLevel ON CaseAuthorizationLevel = _AuthLevel.CaseAuthorizationLevel  -- association [0..1]
LEFT OUTER JOIN I_CaseStatusProfile AS _StatProfile ON CaseStatusProfile = _StatProfile.CaseStatusProfile  -- association [0..1]
LEFT OUTER JOIN I_Caseindividualstatus AS _Individual ON CaseStatus = _Individual.CaseStatus AND CaseStatusProfile = _Individual.CaseStatusProfile  -- association [0..1]
LEFT OUTER JOIN I_CaseSystemStatus AS _CaseSystemStatus ON CaseSystemStatus = _CaseSystemStatus.CaseSystemStatus  -- association [0..1]
LEFT OUTER JOIN I_CaseReasons AS _Reasons ON CaseReason = _Reasons.CaseReason AND CaseType = _Reasons.CaseType  -- association [0..1]
;