I_OpenClosedDisputeCase

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

CREATE VIEW I_OpenClosedDisputeCase AS
SELECT
  DisputeCaseUUID,
  Customer,
  CaseID,
  CompanyCode,
  _Customer.CustomerAccountGroup AS CustomerAccountGroup,
  _Customer.AuthorizationGroup AS CustomerBasicAuthorizationGrp,
  DisputeCaseProcessor,
  cast( DisputeCaseProcessorFullName as farp_processor_full_name preserving type ) AS DisputeCaseProcessorFullName,
  cast( DisputeCaseRootCause as udm_root_ccode preserving type ) AS DisputeCaseRootCause,
  cast( DisputeCaseCoordinator as udm_coordinator preserving type ) AS DisputeCaseCoordinator,
  cast( DsputCaseCoordinatorFullName as farp_coordinator_full_name preserving type ) AS DsputCaseCoordinatorFullName,
  cast( DisputeCaseReason as scmg_reason_code preserving type ) AS DisputeCaseReason,
  Status,
  cast( StatusProfile as scmgstatusprofid preserving type ) AS StatusProfile,
  cast( CaseProcessingStatus as scmgstatusonr preserving type) AS CaseProcessingStatus,
  CaseType,
  _CaseUUID.DisputeCasePriority AS DisputeCasePriority,
  cast( DisplayCurrency as disp_curr preserving type ) AS DisplayCurrency,
  CaseCreationDate,
  CaseClosingDate,
  cast( CurrentDay as currentday preserving type ) AS CurrentDay,
  cast( IsCreatedToday as farp_createdtoday preserving type ) AS IsCreatedToday,
  cast( IsSolvedToday as farp_solvedtoday ) AS IsSolvedToday,
  cast( IsCreatedLast5Days as farp_createdlast5days preserving type ) AS IsCreatedLast5Days,
  cast( IsSolvedLast5Days as farp_solvedinlast5days ) AS IsSolvedLast5Days,
  cast( IsCreatedCurrentMonth as farp_createdcurrentmonth ) AS IsCreatedCurrentMonth,
  cast( IsSolvedCurrentMonth as farp_solvedincurrentmonth ) AS IsSolvedCurrentMonth,
  cast( TodayCreatedAmtInDspCrcy as farp_createdamttoday ) AS TodayCreatedAmtInDspCrcy,
  cast( TodaySolvedAmtInDspCrcy as farp_solvedamttoday ) AS TodaySolvedAmtInDspCrcy,
  cast( Last5DaysCrtedAmtInDspCrcy as farp_createdamtlast5days ) AS Last5DaysCrtedAmtInDspCrcy,
  cast( Last5DaysSolvedAmtInDspCrcy as farp_solvedamtlast5days ) AS Last5DaysSolvedAmtInDspCrcy,
  cast( CurMonthCreatedAmtInDspCrcy as farp_createdamtcurmonth ) AS CurMonthCreatedAmtInDspCrcy,
  cast( CurMonthSolvedAmtInDspCrcy as farp_solvedamtcurrentmonth ) AS CurMonthSolvedAmtInDspCrcy
FROM P_OpenClosedDisputeCase3
LEFT OUTER JOIN I_CaseAttributes AS _CaseUUID ON _CaseUUID.CaseUUID = DisputeCaseUUID  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _Company ON _Company.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON _Customer.Customer = Customer  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DisplayCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CaseReason AS _CaseReason ON CaseType = _CaseReason.CaseType AND DisputeCaseReason = _CaseReason.CaseReason  -- association [0..1]
LEFT OUTER JOIN I_CaseType AS _CaseType ON CaseType = _CaseType.CaseType  -- association [0..1]
LEFT OUTER JOIN I_CaseStatus AS _CaseStatus ON Status = _CaseStatus.Status  -- association [0..1]
LEFT OUTER JOIN I_CaseStatProfile AS _StatProf ON StatusProfile = _StatProf.CaseStatusProfile  -- association [0..1]
LEFT OUTER JOIN I_CaseIndivStatus AS _StatusProfile ON StatusProfile = _StatusProfile.CaseStatusProfile AND CaseProcessingStatus = _StatusProfile.CaseStatus  -- association [0..1]
LEFT OUTER JOIN I_CasePriority AS _Prio ON DisputeCasePriority = _Prio.CasePriority  -- association [0..1]
LEFT OUTER JOIN I_RootCause AS _RootCause ON CaseType = _RootCause.CaseType AND DisputeCaseRootCause = _RootCause.DisputeCaseRootCause  -- association [0..1]
LEFT OUTER JOIN I_DisputeCaseContact AS _CaseProcessor ON DisputeCaseProcessor = _CaseProcessor.UserID  -- association [0..1]
LEFT OUTER JOIN I_DisputeCaseContact AS _CaseCoordinator ON DisputeCaseCoordinator = _CaseCoordinator.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _Processor ON DisputeCaseProcessor = _Processor.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _Coordinator ON DisputeCaseCoordinator = _Coordinator.UserID  -- association [0..1]
;