P_DCD_1

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

CREATE VIEW P_DCD_1 AS
SELECT
  CaseUUID,
  CaseID,
  BusinessPartner,
  CreditSegment,
  CreditRiskClass,
  CaseProcessor,
  CaseResponsible,
  CaseCreatedBy,
  CaseLastChangedBy,
  CaseClosedBy,
  CaseReason,
  CaseType,
  CaseStatusProfile,
  CaseStatus,
  CaseSystemStatus,
  CasePriority,
  CaseEscalationReason,
  CaseCategory,
  tstmp_to_dats( CaseCreatedOn, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) AS CaseCreationDate,
  tstmp_to_dats( CaseLastChangedOn, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) AS CaseLastChangeDate,
  tstmp_to_dats( CaseClosedTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) AS CaseClosingDate,
  cast( CasePlannedCloseDate as scmg_plan_end_date preserving type ) AS CasePlannedCloseDate,
  :P_KeyDate AS TodayDate,
  CrdtMgmtBusinessPartnerGroup,
  CreditDecisionObjectType,
  CreditDecisionSalesDocument,
  SalesDocumentCreditStatus,
  CreditDecisionReqUTCDateTime,
  CreditDecisionFirstApprover,
  CreditDecisionSecondApprover,
  CreditDecisionFirstApprvlSts,
  CreditDecisionSecondApprvlSts,
  CreditDecisionCompletedByUser,
  CrdtDcsnApprvlProcIsOverruled,
  StaticLmtUtilznCrdtChkIsFailed,
  MaxDocAmountCreditChkIsFailed,
  DynLimitUtilznCrdtChkIsFailed,
  MaxDunningLevelCrdtChkIsFailed,
  OldestOpenItemCrdtChkIsFailed,
  DaysSlsOutStdgCrdtChkIsFailed,
  OtherCreditCheckIsFailed,
  OverdueOpenItemCrdtChkIsFailed,
  CreditDecisionCurrency,
  :P_DisplayCurrency AS DisplayCurrency,
  currency_conversion( amount => OpenCreditAmount, source_currency => CreditDecisionCurrency, 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 OpenCreditAmount AS trueasOpenCreditAmount,
  currency_conversion( amount => CheckedCreditRiskAmount, source_currency => CreditDecisionCurrency, 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 CheckedCreditRiskAmount AS trueasCheckedCreditRiskAmount
FROM I_CreditDecisionDocument
;