P_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 P_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 P_DisputeCaseDraft AS
SELECT
  DisputeCaseUUID,
  _DisputeCaseDraft.DraftUUID AS DraftUUID,
  case when _DisputeCaseDraft.DraftUUID is null then OriginalAmount else _DisputeCaseDraft.OriginalAmount end as OriginalAmount AS OriginalAmountendasOriginalAmount,
  case when _DisputeCaseDraft.DraftUUID is null then DisputedAmount else _DisputeCaseDraft.DisputedAmount end as DisputedAmount AS DisputedAmountendasDisputedAmount,
  case when _DisputeCaseDraft.DraftUUID is null then PaidAmount else _DisputeCaseDraft.PaidAmount end as PaidAmount AS PaidAmountendasPaidAmount,
  case when _DisputeCaseDraft.DraftUUID is null then CreditedAmount else _DisputeCaseDraft.CreditedAmount end as CreditedAmount AS CreditedAmountendasCreditedAmount,
  case when _DisputeCaseDraft.DraftUUID is null then WriteOffAmount else _DisputeCaseDraft.WriteOffAmount end as WriteOffAmount AS WriteOffAmountendasWriteOffAmount,
  case when _DisputeCaseDraft.DraftUUID is null then ContactPersonName else _DisputeCaseDraft.ContactPersonName end as ContactPersonName AS ContactPersonNameendasContactPersonName,
  case when _DisputeCaseDraft.DraftUUID is null then ContactPerson else _DisputeCaseDraft.ContactPerson end as ContactPerson AS ContactPersonendasContactPerson,
  case when _DisputeCaseDraft.DraftUUID is null then Customer else _DisputeCaseDraft.Customer end as Customer AS CustomerendasCustomer,
  case when _DisputeCaseDraft.DraftUUID is null then CompanyCode else _DisputeCaseDraft.CompanyCode end as CompanyCode AS CompanyCodeendasCompanyCode,
  case when _DisputeCaseDraft.DraftUUID is null then CaseType else _DisputeCaseDraft.CaseType end as CaseType AS CaseTypeendasCaseType,
  case when _DisputeCaseDraft.DraftUUID is null then CaseID else _DisputeCaseDraft.CaseID end as CaseID AS CaseIDendasCaseID,
  case when _DisputeCaseDraft.DraftUUID is null then CaseCreatedBy else _DisputeCaseDraft.CaseCreatedBy end as CaseCreatedBy AS CaseCreatedByendasCaseCreatedBy,
  case when _DisputeCaseDraft.DraftUUID is null then CaseCreatedOn else _DisputeCaseDraft.CaseCreatedOn end as CaseCreatedOn AS CaseCreatedOnendasCaseCreatedOn,
  case when _DisputeCaseDraft.DraftUUID is null then CaseLastChangedBy else _DisputeCaseDraft.CaseLastChangedBy end as CaseLastChangedBy AS CaseLastChangedByendasCaseLastChangedBy,
  case when _DisputeCaseDraft.DraftUUID is null then CaseLastChangedOn else _DisputeCaseDraft.CaseLastChangedOn end as CaseLastChangedOn AS CaseLastChangedOnendasCaseLastChangedOn,
  case when _DisputeCaseDraft.DraftUUID is null then CaseClosedBy else _DisputeCaseDraft.CaseClosedBy end as CaseClosedBy AS CaseClosedByendasCaseClosedBy,
  case when _DisputeCaseDraft.DraftUUID is null then CaseClosedTime else _DisputeCaseDraft.CaseClosedTime end as CaseClosedTime AS CaseClosedTimeendasCaseClosedTime,
  case when _DisputeCaseDraft.DraftUUID is null then CaseProcessor else _DisputeCaseDraft.CaseProcessor end as CaseProcessor AS CaseProcessorendasCaseProcessor,
  case when _DisputeCaseDraft.DraftUUID is null then CaseResponsible else _DisputeCaseDraft.CaseResponsible end as CaseResponsible AS CaseResponsibleendasCaseResponsible,
  case when _DisputeCaseDraft.DraftUUID is null then CaseTitle else _DisputeCaseDraft.CaseTitle end as CaseTitle AS CaseTitleendasCaseTitle,
  case when _DisputeCaseDraft.DraftUUID is null then CaseCategory else _DisputeCaseDraft.CaseCategory end as CaseCategory AS CaseCategoryendasCaseCategory,
  case when _DisputeCaseDraft.DraftUUID is null then CasePriority else _DisputeCaseDraft.CasePriority end as CasePriority AS CasePriorityendasCasePriority,
  case when _DisputeCaseDraft.DraftUUID is null then CaseStatusProfile else _DisputeCaseDraft.CaseStatusProfile end as CaseStatusProfile AS CaseStatusProfileendasCaseStatusProfile,
  case when _DisputeCaseDraft.DraftUUID is null then CaseStatus else _DisputeCaseDraft.CaseStatus end as CaseStatus AS CaseStatusendasCaseStatus,
  case when _DisputeCaseDraft.DraftUUID is null then CaseSystemStatus else _DisputeCaseDraft.CaseSystemStatus end as CaseSystemStatus AS CaseSystemStatusendasCaseSystemStatus,
  case when _DisputeCaseDraft.DraftUUID is null then CaseReason else _DisputeCaseDraft.CaseReason end as CaseReason AS CaseReasonendasCaseReason,
  cast ( 'X'as boolean ) AS HasActiveEntity,
  _DisputeCaseDraft.DraftAdministrativeDataUUID AS DraftAdministrativeDataUUID,
  DisputeCaseCoordinator,
  DisputeCaseRootCause,
  CaseProcessingDeadlineDate,
  OriginalAmount,
  DisputedAmount,
  PaidAmount,
  CreditedAmount,
  WriteOffAmount,
  ManuallyClearedAmount,
  DisputeCaseCurrency,
  ContactPersonName,
  ContactPersonEmailAddress,
  ContactPersonPhoneNumber,
  ContactPersonFaxNumber,
  ContactPersonFaxCountry,
  ContactPerson,
  Customer,
  CompanyCode,
  DisputeCaseExternalApplication,
  CaseType,
  CaseID,
  CaseExternalReference,
  CaseCreatedBy,
  CaseCreatedOn,
  CaseLastChangedBy,
  CaseLastChangedOn,
  CaseClosedBy,
  CaseClosedTime,
  CasePlannedCloseDate,
  CaseProcessor,
  CaseResponsible,
  CaseTitle,
  CaseEscalationReason,
  CaseCategory,
  CasePriority,
  CaseAuthorizationLevel,
  CaseStatusProfile,
  CaseStatus,
  CaseSystemStatus,
  CaseReason,
  CustomerDisputedAmount,
  CustomerDisputedCurrency,
  cast( '' as boolean ) AS IsActiveEntity,
  DraftCreationDateTime,
  DraftLastChangedDateTime
FROM R_DisputeCase
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_DisputeCaseDraft AS _DisputeCaseDraft ON DisputeCaseUUID = _DisputeCaseDraft.DisputeCaseUUID  -- association [0..1]
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_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]
LEFT OUTER JOIN I_DraftAdministrativeData AS _DraftAdministrativeData ON DraftAdministrativeDataUUID = _DraftAdministrativeData.DraftUUID AND _DraftAdministrativeData.DraftEntityType = 'R_DISPUTECASETP'  -- association [0..1]
-- UNION ALL with additional select branch(es): I_DisputeCaseDraft
;