P_OpenDisputeProcessingTime3

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_OpenDisputeProcessingTime3.
-- 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: POPNDISPPRCTIME3
-- Parameters: P_KeyDate : sydate, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst_curr

CREATE VIEW P_OpenDisputeProcessingTime3 AS
SELECT
  DisputeCaseUUID,
  CaseID,
  CompanyCode,
  Customer,
  DisputeCaseProcessor,
  DisputeCaseProcessorFullName,
  DisputeCaseRootCause,
  DisputeCaseCoordinator,
  DsputCaseCoordinatorFullName,
  DisputeCaseReason,
  Status,
  DisputeCasePriority,
  StatusProfile,
  CaseProcessingStatus,
  CaseType,
  DisputedAmount,
  Currency,
  CaseCreationDate,
  TodayDate,
  ProcessingDays,
  DisputedAmountInDisplayCrcy,
  DisplayCurrency,
  case when CaseIsCrtedInFirstIntvl = 1 then 'A. 0' else case when CaseIsCrtedInSecondIntvl = 1 then 'B. 1-2' else case when CaseIsCrtedInThirdIntvl = 1 then 'C. 3-5' else case when CaseIsCrtedInFourthIntvl = 1 then 'D. 6-10' else case when CaseIsCrtedInFifthIntvl = 1 then 'E. 11-20' else case when CaseIsCrtedInSixthIntvl = 1 then 'F. 21-50' else 'G. >50' end end end end end end as ProcessingDaysText AS 50endendendendendendasProcessingDaysText,
  CaseIsCrtedInFirstIntvl,
  CaseIsCrtedInSecondIntvl,
  CaseIsCrtedInThirdIntvl,
  CaseIsCrtedInFourthIntvl,
  CaseIsCrtedInFifthIntvl,
  CaseIsCrtedInSixthIntvl,
  CaseIsCrtedInSeventhIntvl
FROM P_OpenDisputeProcessingTime2
;