P_CAPaymentSearch

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_CAPaymentSearch.
-- 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: PCAPAYMENTSEARCH

CREATE VIEW P_CAPaymentSearch AS
SELECT
  CAPaymentLot,
  CAPaymentLotItem,
  ' ' AS CAMassRunDate,
  ' ' AS CAMAssRunID,
  cast(cast(0 as abap.int4) as payno_pay) AS CAIntPaymentIdentification,
  cast(cast('' as abap.char(6)) as subno_pay) AS CAIntAddlPaymentIdentification,
  CADocumentNumber,
  CARepaymentRequest,
  PaymentCardType,
  CABankAccountHolderName,
  TransactionCurrency,
  CardNumber,
  ValueDate,
  BankCountry,
  BankNumber,
  BankAccount,
  SWIFTCode,
  CAPaymentTransIsToBeClarified,
  IBAN,
  cast (CAPaymentAmountInTransCurrency as betrw_gfn_kk preserving type ) AS CAPaymentAmountInTransCurrency,
  DocumentDate,
  _PaymentLot.CreationDate AS CreationDate,
  CACheque,
  CANoteToPayeeInPayment,
  CompanyCode,
  BusinessArea,
  CAAuthorizationGroup,
  ' ' AS CAPaymentMethod,
  cast('00000000' as abap.dats( 8 )) AS PaymentDocumentPostingDate,
  cast('' as abap.char( 15 )) AS PayeeBank,
  ' ' AS PayeeCountry,
  cast('' as abap.char( 40 )) as CityName AS char12asCAPaymentLot,
  CityName
FROM I_CAPaymentLotItem
-- UNION ALL with additional select branch(es): I_CAPaymentRunHeader
;