C_CADisputeCaseDraftTP

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_CADisputeCaseDraftTP.
-- 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 C_CADisputeCaseDraftTP AS
SELECT
  CaseUUID,
  BusinessPartner,
  BusinessPartnerFullName,
  ContractAccount,
  ContractAccountName,
  cast ( CAContract as vtref_kk preserving type ) AS CAContract,
  cast ( _ProviderContract.CAProviderContractName as vtbez_vt_gfn_kk preserving type ) AS CAProviderContractName,
  CASubApplication,
  _CASubApplicationText[1:Language = $session.system_language].CASubApplicationText AS CASubApplicationText,
  DisputedAmount,
  TotalReceivablesAmount,
  DisputeCaseCorrectionAmount,
  DisputeCaseReversedAmount,
  CreditedAmount,
  WriteOffAmount,
  DisputeCaseReplacedAmount,
  CARemainingDisputedAmount,
  DisputeCaseCurrency,
  CADisputeType,
  CADisputeTypeText,
  CompanyCode,
  cast( CompanyCodeName as bukrs_text_gfn_kk preserving type ) AS CompanyCodeName,
  DisputeCaseCoordinator,
  cast( _DisputeCaseCoordinator.UserDescription as case_coordinator_text_gfn_kk preserving type ) AS DsputCaseCoordinatorFullName,
  cast( DisputeCaseRootCause as udm_root_ccode_gfn_kk preserving type ) AS DisputeCaseRootCause,
  cast( CaseRootCauseDescription as udm_root_ccode_txt_gfn_kk preserving type ) AS CaseRootCauseDescription,
  CaseProcessingDeadlineDate,
  ContactPersonFullName,
  ContactPersonEmailAddress,
  ContactPersonPhoneNumber,
  ContactPersonFaxNumber,
  ContactPersonFaxCountry,
  _ContactPersonFaxCountryText[1:Language = $session.system_language].CountryName AS FaxCountryName,
  DisputeCaseInformationText,
  DisputeCaseTransactionDate,
  CADisputeCase,
  CaseType,
  CaseID,
  CaseExternalReference,
  CaseCreatedBy,
  cast( _CaseCreatedBy.UserDescription as case_created_by_text_gfn_kk preserving type ) AS CaseCreatedByUserName,
  CaseCreationDate,
  CaseLastChangedBy,
  cast( _CaseLastChangedBy.UserDescription as case_last_chg_by_text_gfn_kk preserving type ) AS CaseLastChangedByUserName,
  CaseLastChangedOn,
  CaseStatusProfile,
  CaseClosedBy,
  cast( _CaseClosedBy.UserDescription as case_closed_by_text_gfn_kk preserving type ) AS CaseClosedByUserName,
  CaseClosedTime,
  CasePlannedCloseDate,
  CaseProcessor,
  cast( _CaseProcessor.UserDescription as case_processor_text_gfn_kk preserving type ) AS CaseProcessorName,
  CaseResponsible,
  _CaseResponsible.UserDescription AS CaseResponsibleName,
  CaseTitle,
  CaseStatus,
  CaseStatusName,
  CaseSystemStatus,
  CaseUserStatusName,
  CasePriority,
  DisputeCasePriorityName,
  CaseCategory,
  cast( DisputeCaseCategoryName as scmg_category_desc_gfn_kk preserving type ) AS DisputeCaseCategoryName,
  CaseReason,
  CaseReasonName,
  CaseEscalationReason,
  DsputCaseEscalationRsnName,
  CountryName,
  CADocumentNumber,
  TemporaryDisputeCaseUUID,
  AddressLine1,
  AddressLine2,
  CaseIsDisplayOnly,
  UserDefinedText,
  CACaseConversionStatus,
  CaseAttributeProfile,
  CADisputeCaseOrigin,
  CADisputeCaseOriginText,
  CAAuthorizationGroup,
  virtual IsCloudSystem : is_cloud_system AS virtualIsCloudSystemis_cloud_system,
  virtual IsDraftEntity : abap_boolean AS virtualIsDraftEntityabap_boolean,
  virtual CADocument : opbel_gfn_kk AS virtualCADocumentopbel_gfn_kk,
  virtual CAInvoicingDocument : invdocno_kk AS virtualCAInvoicingDocumentinvdocno_kk
FROM R_CADisputeCaseTP
LEFT OUTER JOIN C_CANotDisputedPayment AS _NotDisPayment ON ContractAccount = _NotDisPayment.ContractAccount AND BusinessPartner = _NotDisPayment.BusinessPartner AND CAContract = _NotDisPayment.CAContract AND CaseUUID = _NotDisPayment.CaseUUID  -- association [0..*]
LEFT OUTER JOIN C_CANotDisputedCredit AS _NotDisCredit ON ContractAccount = _NotDisCredit.ContractAccount AND BusinessPartner = _NotDisCredit.BusinessPartner AND CAContract = _NotDisCredit.CAContract AND CaseUUID = _NotDisCredit.CaseUUID  -- 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 CompanyCode = _NotDisDocument.CompanyCode AND CaseUUID = _NotDisDocument.CaseUUID  -- association [0..*]
LEFT OUTER JOIN C_CAInvcgUserContact AS _CreatedBy ON CaseCreatedBy = _CreatedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN C_CAInvcgUserContact AS _Processor ON CaseProcessor = _Processor.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_CANotDisputedInvcgDoc AS _NotDisInvcgDoc ON ContractAccount = _NotDisInvcgDoc.ContractAccount AND BusinessPartner = _NotDisInvcgDoc.BusinessPartner AND CAContract = _NotDisInvcgDoc.CAContract AND CaseUUID = _NotDisInvcgDoc.CaseUUID AND CompanyCode = _NotDisInvcgDoc.CompanyCode  -- association [0..*]
LEFT OUTER JOIN C_CANotDisputedBillableItem AS _NotDisBillableItem ON ContractAccount = _NotDisBillableItem.ContractAccount AND BusinessPartner = _NotDisBillableItem.BusinessPartner AND CAContract = _NotDisBillableItem.CAContract AND CaseUUID = _NotDisBillableItem.CaseUUID AND CompanyCode = _NotDisBillableItem.CompanyCode  -- association [0..*]
LEFT OUTER JOIN C_CANotDisputedInvcgDocItem AS _NotDisInvcgDocItem ON ContractAccount = _NotDisInvcgDocItem.ContractAccount AND BusinessPartner = _NotDisInvcgDocItem.BusinessPartner AND CAContract = _NotDisInvcgDocItem.CAContract AND CaseUUID = _NotDisInvcgDocItem.CaseUUID AND CompanyCode = _NotDisInvcgDocItem.CompanyCode  -- association [0..*]
;