P_OpenDisputeCase1

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

CREATE VIEW P_OpenDisputeCase1 AS
SELECT
  I_DisputeCase.DisputeCaseUUID AS DisputeCaseUUID,
  _CaseAttributes.CaseID AS CaseID,
  I_DisputeCase.CompanyCode AS CompanyCode,
  I_DisputeCase.Customer AS Customer,
  _CaseAttributes.CaseProcessor AS DisputeCaseProcessor,
  _CaseAttributes.DisputeCaseProcessorFullName AS DisputeCaseProcessorFullName,
  DisputeCaseRootCause,
  DisputeCaseCoordinator,
  DsputCaseCoordinatorFullName,
  _CaseAttributes.CaseReason AS DisputeCaseReason,
  I_DisputeCase.Status AS Status,
  _CaseAttributes.CaseStatusProfile AS StatusProfile,
  _CaseAttributes.CaseProcessingStatus AS CaseProcessingStatus,
  _CaseAttributes.CaseType AS CaseType,
  _CaseAttributes.DisputeCasePriority AS DisputeCasePriority,
  I_DisputeCase.DisputedAmount AS DisputedAmount,
  cast( substring( cast( _CaseAttributes.CreationDateTime as sstring ),1,8 ) as abap.dats ) AS CaseCreationDate,
  :P_KeyDate AS TodayDate,
  cast( I_DisputeCase.Currency as currency preserving type ) AS Currency,
  currency_conversion( amount => I_DisputeCase.DisputedAmount, source_currency => I_DisputeCase.Currency, target_currency => :P_DisplayCurrency, exchange_rate_date => :P_KeyDate , exchange_rate_type => :P_ExchangeRateType, error_handling => #CNV_ERROR_HANDLING.FAIL_ON_ERROR, round => #CDSBoolean.true, decimal_shift => #CDSBoolean.true, decimal_shift_back => #CDSBoolean.true ) as DisputedAmountInDisplayCrcy AS trueasDisputedAmountInDisplayCrcy,
  cast( :P_DisplayCurrency as disp_curr preserving type ) AS DisplayCurrency
FROM I_DisputeCase
;