C_CAPaymentRunSearch

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_CAPaymentRunSearch.
-- 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.

CREATE VIEW C_CAPaymentRunSearch AS
SELECT
  CAMassRunDate,
  CAMassRunID,
  CAIntPaymentIdentification,
  CAIntAddlPaymentIdentification,
  cast(concat( cast(CAMassRunDate as date), CAMassRunID) as abap.char(20) ) AS CAPaymentRunDateAndID,
  CAPaymentCompanyCode AS CompanyCode,
  _PaymentCompanyCode.CompanyCodeName AS CompanyCodeName,
  concat_with_space( concat_with_space( cast(CAMassRunDate as date) , '/', 1), CAMassRunID, 1) AS CAMassRunDateAndID,
  BusinessPartner,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  _BusinessPartner.FirstName AS FirstName,
  _BusinessPartner.LastName AS LastName,
  _BusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  _BusinessPartner.OrganizationBPName2 AS OrganizationBPName2,
  _BusinessPartner.GroupBusinessPartnerName1 AS GroupBusinessPartnerName1,
  _BusinessPartner.GroupBusinessPartnerName2 AS GroupBusinessPartnerName2,
  ContractAccount,
  _ContractAccount.ContractAccountName AS ContractAccountName,
  _PaymentRunItem.CASubApplication AS CASubApplication,
  CAPaymentDocumentReference,
  CAPaymentDocumentType,
  cast('' as char70) AS CAPaymentDocumentTypeName,
  CADocumentNumber,
  CAPaymentOrder,
  CARepaymentRequest,
  CASEPAPreNotificationNumber,
  _BankCountry._Text[1: Language=$session.system_language].CountryName AS BankCountryName,
  BankCountry,
  cast(BankNumber as bankl preserving type ) AS BankNumber,
  cast(BankAccount as farp_bankn preserving type ) AS BankAccount,
  _PayeeBankCountry._Text[1: Language=$session.system_language].CountryName AS PayeeBankCountryName,
  cast(PayeeBankCountry as banks preserving type ) AS PayeeBankCountry,
  PayeeBank,
  _Bank.BankName AS PayeeBankName,
  PayeeBankNumber,
  cast(PayeeBankAccount as farp_bankn preserving type ) AS PayeeBankAccount,
  PayeeIBAN,
  CABankAccountHolderName,
  _PayeeCountry._Text[1: Language=$session.system_language].CountryName AS PayeeCountryName,
  PayeeCountry,
  CityName,
  AddressPostalCode,
  concat_with_space( AddressPostalCode, CityName, 1) AS AddressLine2,
  AddressStreetName,
  AddressHouseNumber,
  concat_with_space( AddressStreetName, AddressHouseNumber, 1) AS AddressLine1,
  SWIFTCode,
  TransactionCurrency,
  _TransactionCurrency._Text[1: Language=$session.system_language].CurrencyName AS CurrencyName,
  PaytAmountInCoCodeCurrency,
  PaidAmountInPaytCurrency,
  cast(_PaymentCompanyCode.Currency as fis_hwaer preserving type) AS CompanyCodeCurrency,
  ValueDate,
  _PaymentMethod._Text[1:Language = $session.system_language].CAPaymentMethodName AS CAPaymentMethodName,
  CAPaymentMethod,
  _HouseBank._Bank.BankName AS BankName,
  HouseBank,
  _HouseBank._Bank.BankName AS HouseBankName,
  HouseBankAccount,
  _HouseBankAccount._Text[1: Language=$session.system_language].HouseBankAccountDescription AS HouseBankAccountDescription,
  _CADocumentGLItemPaymentData.PaymentCardHolderName AS CardHolder,
  _CADocumentGLItemPaymentData.PaymentCardValidityEndDate AS ValidityEndDate,
  cast(concat_with_space(CardNumber, concat_with_space('(', concat_with_space(_PaymentCardType._Text[1: Language=$session.system_language].CardTypeText, ')', 1), 1), 1) as ccnum_ccins_kk) AS PaymentCardData,
  PaymentCardType,
  _PaymentCardType._Text[1: Language=$session.system_language].CardTypeText AS CardTypeText,
  PaymentAdvicePrintingReason,
  '' AS PaidItemBusinessPartner,
  '' AS PaidItemContractAccount,
  '' AS CAContract,
  cast('' as vtref_semobj_kk) AS CAContractSemanticObject,
  cast (_DocHeader.DocumentDate as co_bldat preserving type) AS DocumentDate,
  _DocHeader.CAPostingDate AS CAPostingDate,
  _DocHeader._DocType._Text[1:Language = $session.system_language].CADocumentTypeName AS CADocumentTypeName,
  _DocHeader.CADocumentType AS CADocumentType,
  _ReturnHistory.CAReturnReason AS CAReturnReason,
  _ReturnHistory._CAReturnReason._Text[1:Language = $session.system_language].CAReturnReasonName AS CAReturnReasonName,
  _DocHeader.CAReversalDocumentNumber AS CAReversalDocumentNumber,
  _PaymentOrder.PaidItemDueDate AS PaidItemDueDate,
  _PaymentOrder.CAPaymentOrderExpirationDate AS CAPaymentOrderExpirationDate,
  _PaymentOrder.CAPaymentOrderStatus AS CAPaymentOrderStatus,
  _PaymentOrder._CAPaymentOrderStatus._Text[1: Language=$session.system_language].CAPaymentOrderStatusName AS CAPaymentOrderStatusName,
  _PaymentOrder.CAPaymentDocument AS CAPaymentDocument,
  cast('' as char20) AS CADocumentReversalStatusName,
  CAPaymentSpecification,
  CAPaymentSpecificationRef,
  CAPromiseToPay,
  CAPromisedPaymentDate
FROM I_CAPaymentRunHeader
LEFT OUTER JOIN I_CAPaymentRunItemEnhanced AS _PaymentRunItem ON CAMassRunDate = _PaymentRunItem.CAMassRunDate AND CAMassRunID = _PaymentRunItem.CAMassRunID AND CAIntPaymentIdentification = _PaymentRunItem.CAIntPaymentIdentification AND CAIntAddlPaymentIdentification = _PaymentRunItem.CAIntAddlPaymentIdentification  -- association [1..*]
LEFT OUTER JOIN I_CAPaymentMethod AS _PaymentMethod ON CAPaymentMethod = _PaymentMethod.CAPaymentMethod AND PayeeCountry = _PaymentMethod.Country  -- association [0..1]
LEFT OUTER JOIN I_CADocument AS _DocHeader ON CADocumentNumber = _DocHeader.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_CAPaymentOrder AS _PaymentOrder ON CAPaymentOrder = _PaymentOrder.CAPaymentOrder  -- association [0..1]
LEFT OUTER JOIN I_CADocumentGLItemPaymentData AS _CADocumentGLItemPaymentData ON CADocumentNumber = _CADocumentGLItemPaymentData.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_Bank AS _Bank ON PayeeBankCountry = _Bank.BankCountry AND PayeeBank = _Bank.BankInternalID  -- association [0..1]
LEFT OUTER JOIN C_CAPaytRunSrchPaymentOrder AS _AssocPaymentOrder ON CAMassRunDate = _AssocPaymentOrder.CAMassRunDate AND CAMassRunID = _AssocPaymentOrder.CAMassRunID AND CAIntPaymentIdentification = _AssocPaymentOrder.CAIntPaymentIdentification AND CAIntAddlPaymentIdentification = _AssocPaymentOrder.CAIntAddlPaymentIdentification  -- association [1..1]
LEFT OUTER JOIN C_CAPaymentRunSearchPayment AS _AssocPayment ON CAMassRunDate = _AssocPayment.CAMassRunDate AND CAMassRunID = _AssocPayment.CAMassRunID AND CAIntPaymentIdentification = _AssocPayment.CAIntPaymentIdentification AND CAIntAddlPaymentIdentification = _AssocPayment.CAIntAddlPaymentIdentification  -- association [1..1]
LEFT OUTER JOIN C_CAPaytRunSrchRepaymentReq AS _AssocRepaymentRequest ON CAMassRunDate = _AssocRepaymentRequest.CAMassRunDate AND CAMassRunID = _AssocRepaymentRequest.CAMassRunID AND CAIntPaymentIdentification = _AssocRepaymentRequest.CAIntPaymentIdentification AND CAIntAddlPaymentIdentification = _AssocRepaymentRequest.CAIntAddlPaymentIdentification  -- association [1..1]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON CompanyCode = _HouseBank.CompanyCode AND HouseBank = _HouseBank.HouseBank  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccount AS _HouseBankAccount ON CompanyCode = _HouseBankAccount.CompanyCode AND HouseBank = _HouseBankAccount.HouseBank AND HouseBankAccount = _HouseBankAccount.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_CAReturnHistory AS _ReturnHistory ON BusinessPartner = _ReturnHistory.BusinessPartner AND ContractAccount = _ReturnHistory.ContractAccount AND CADocumentNumber = _ReturnHistory.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_PaymentCardTypes AS _PaymentCardType ON PaymentCardType = _PaymentCardType.PaymentCardType  -- association [0..1]
;