C_CAPaytRunExceptionAnalysis

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 C_CAPaytRunExceptionAnalysis.
-- 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.
-- Parameters: P_DisplayCurrency : waers_kk

CREATE VIEW C_CAPaytRunExceptionAnalysis AS
SELECT
  CAMassRunDate,
  CAMassRunID,
  CAIntPaymentIdentification,
  CAIntAddlPaymentIdentification,
  CADocumentNumberWithItem,
  CARepaymentRequest,
  CAPaymentOrder,
  CASEPAPreNotificationNumber,
  CAPaymentExceptionReasonGroup,
  cast(concat( cast(CAMassRunDate as date), CAMassRunID) as abap.char(20) ) AS CAPaymentRunDateAndID,
  _CAPaymentRun.CAPaymentMethod AS CAPaymentMethod,
  BusinessPartner,
  BusinessPartnerName,
  IsBusinessPurposeCompleted,
  CompanyCode,
  ContractAccount,
  _ContractAccount.CAApplicationArea AS CAApplicationArea,
  _ContractAccount.ContractAccountCategory AS ContractAccountCategory,
  CAContract,
  CASubApplication,
  cast(_CAProviderContract.CAProviderContractName as vtref_text_gfn_kk preserving type ) AS CAProviderContractName,
  cast(_CASubApplication._CASubApplicationText[1: Language=$session.system_language].CASubApplicationText as subap_text_gfn_kk preserving type ) AS CASubApplicationText,
  CAContractType,
  CAMainTransaction,
  CASubTransaction,
  PayeeCountry,
  CADocumentBPItemPyblRblCode,
  cast( 1 as abap.int4 ) AS NumberOfItems,
  _CAMassRunDate.CalendarYear AS CalendarYear,
  _CAMassRunDate.CalendarQuarter AS CalendarQuarter,
  _CAMassRunDate._CalendarQuarter._Text[1:Language=$session.system_language].CalendarQuarterName AS CalendarQuarterName,
  _CAMassRunDate.CalendarMonth AS CalendarMonth,
  _CAMassRunDate._CalendarMonth._Text[1:Language=$session.system_language].CalendarMonthName AS CalendarMonthName,
  _CAMassRunDate.CalendarWeek AS CalendarWeek,
  CAPaymentLockReason,
  CAClearingLockReason,
  CAPaymentExceptionReason,
  TransactionCurrency,
  CAAmountInTransactionCurrency,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  _TotalAmounts(P_DisplayCurrency: $parameters.P_DisplayCurrency).BPBalanceAmountInDC AS BPBalanceAmountInDC,
  _TotalAmounts(P_DisplayCurrency: $parameters.P_DisplayCurrency).BPCreditAmountInDC AS BPCreditAmountInDC,
  _TotalAmounts(P_DisplayCurrency: $parameters.P_DisplayCurrency).BPDebitAmountInDC AS BPDebitAmountInDC,
  _LastWorklistItem.CAClrfctnStatus AS CAClrfctnStatus,
  _LastWorklistItem.CreationDateTime AS CAWorklistItemCreationDateTime,
  _ContractAccountPartner.CAAuthorizationGroup AS CAAuthorizationGroup,
  _CAProviderContract.CAAuthorizationGroup AS CAProviderContractAuthznGroup,
  _CAMassRunDate._CalendarWeek AS _CalendarWeek,
  _CAMassRunDate._CalendarMonth AS _CalendarMonth,
  _CAMassRunDate._CalendarQuarter AS _CalendarQuarter,
  _CAMassRunDate._CalendarYear AS _CalendarYear,
  _ContractAccount._ApplArea AS _ApplArea,
  _ContractAccount._Category AS _Category,
  _ContractAccountPartner._CAAuthorizationGroup AS _CAAuthorizationGroup,
  _LastWorklistItem._Status AS _Status
FROM P_CAPaytRunException
LEFT OUTER JOIN P_CABPTotalAmounts3 AS _TotalAmounts ON _TotalAmounts.BusinessPartner = BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CAMassRunDate ON _CAMassRunDate.CalendarDate = CAMassRunDate  -- association [1..1]
LEFT OUTER JOIN I_CAPayableReceivableCode AS _PayableReceivable ON _PayableReceivable.CADocumentBPItemPyblRblCode = CADocumentBPItemPyblRblCode  -- association [0..1]
LEFT OUTER JOIN I_CABusPartLastWorklistItem AS _LastWorklistItem ON _LastWorklistItem.BusinessPartner = BusinessPartner AND _LastWorklistItem.CAFioriApplication = 'F2124A' AND _LastWorklistItem.CADocumentBPItemPyblRblCode = CADocumentBPItemPyblRblCode  -- association [0..1]
LEFT OUTER JOIN I_CAPaymentLockReasonText AS _PaymentLockReasonText ON _PaymentLockReasonText.CAPaymentLockReason = CAPaymentLockReason  -- association [0..*]
LEFT OUTER JOIN I_CAPaytExcRsnEnhancedText AS _PaymentExceptionReasonText ON _PaymentExceptionReasonText.CAPaymentExceptionReason = CAPaymentExceptionReason  -- association [0..*]
LEFT OUTER JOIN I_Indicatortext AS _PaymentIsSuccessfulText ON _PaymentIsSuccessfulText.IndicatorValue = CAPaymentIsSuccessful  -- association [0..*]
LEFT OUTER JOIN I_CAWorklistStatusText AS _WorklistStatusText ON _WorklistStatusText.CAClrfctnStatus = caclrfctnstatus  -- association [0..*]
LEFT OUTER JOIN I_CAFioApUsrPaytExcRsnGrp AS _PaymentExceptionReasonGroup ON _PaymentExceptionReasonGroup.CAFioriApplication = 'F2124A' AND _PaymentExceptionReasonGroup.CAFioriApplicationUser = $session.user AND _PaymentExceptionReasonGroup.CAPaymentExceptionReasonGroup = CAPaymentExceptionReasonGroup  -- association [0..1]
LEFT OUTER JOIN I_CAContractTypeEnhancedText AS _ContractTypeText ON _ContractTypeText.CAContractType = CAContractType  -- association [0..*]
LEFT OUTER JOIN I_CASubApplication AS _CASubApplication ON CASubApplication = _CASubApplication.CASubApplication  -- association [0..1]
;