I_ResolvedDisputeCase

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

CREATE VIEW I_ResolvedDisputeCase 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( DisputeCaseReason as scmg_reason_code preserving type ) AS DisputeCaseReason,
  CaseType,
  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,
  Status,
  DisputeCasePriority,
  cast( StatusProfile as scmgstatusprofid preserving type ) AS StatusProfile,
  cast( CaseProcessingStatus as scmgstatusonr preserving type) AS CaseProcessingStatus,
  cast( DisplayCurrency as disp_curr preserving type ) AS DisplayCurrency,
  cast( CaseCreationDate as udm_create_date preserving type ) AS CaseCreationDate,
  cast( CaseClosingDate as udm_closing_date preserving type ) AS CaseClosingDate,
  cast( CurrentYear as currentyear preserving type ) AS CurrentYear,
  cast( CurrentMonth as currentmonth preserving type ) AS CurrentMonth,
  cast( CurrentQuarter as currentquarter) AS CurrentQuarter,
  cast( LastQuarter as lastquarter ) AS LastQuarter,
  cast( CaseClosingYear as caseclosingyear preserving type ) AS CaseClosingYear,
  cast( CaseClosingMonth as caseclosingmonth preserving type ) AS CaseClosingMonth,
  cast( CaseClosingQuarter as caseclosingquarter ) AS CaseClosingQuarter,
  cast( IsSolvedCurrentYear as farp_solvedincurrentyear ) AS IsSolvedCurrentYear,
  cast( IsSolvedCurrentMonth as farp_solvedincurrentmonth ) AS IsSolvedCurrentMonth,
  cast( IsSolvedLastMonth as farp_solvedinlastmonth ) AS IsSolvedLastMonth,
  cast( IsSolvedLastQuarter as farp_solvedinlastquarter ) AS IsSolvedLastQuarter,
  cast( IsSolvedLast12Months as farp_solvedinlast12months) AS IsSolvedLast12Months,
  cast( Last12MonthsResolvingDays as farp_last12monthsresolvingdays preserving type ) AS Last12MonthsResolvingDays,
  cast( CurrentMonthResolvingDays as farp_currentmonthresolvingdays preserving type ) AS CurrentMonthResolvingDays,
  cast( LastMonthResolvingDays as farp_lastmonthresolvingdays preserving type ) AS LastMonthResolvingDays,
  cast( CurrentYearResolvingDays as farp_currentyearresolvingdays preserving type ) AS CurrentYearResolvingDays,
  cast( OriginalAmountInDisplayCrcy as farp_solvedamtlast12months ) AS Last12MnthsSlvdAmtInDspCrcy,
  cast( CurMonthSolvedAmtInDspCrcy as farp_solvedamtcurrentmonth ) AS CurMonthSolvedAmtInDspCrcy,
  cast( LastMonthSolvedAmtInDspCrcy as farp_solvedamtlastmonth ) AS LastMonthSolvedAmtInDspCrcy,
  cast( CurrentYearSolvedAmtInDspCrcy as farp_solvedamtcurrentyear ) AS CurYearSolvedAmtInDspCrcy
FROM P_ResolvedDisputeCase3
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 _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.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]
;