C_CAPaymentListRepaymentReq

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_CAPaymentListRepaymentReq.
-- 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: CCAPAYLISTREPAY

CREATE VIEW C_CAPaymentListRepaymentReq AS
SELECT
  CAMassRunDate,
  CAMassRunID,
  CAIntPaymentIdentification,
  CAIntAddlPaymentIdentification,
  CAInternalPaymentGroup,
  CADocumentNumber AS CAPaymentDocument,
  _DocHeader.DocumentDate AS DocumentDate,
  CARepaymentRequest,
  CAPaymentMethod,
  CompanyCodeCountry,
  _CAPaymentMethod._Text[1: Language=$session.system_language].CAPaymentMethodName AS CAPaymentMethodName,
  CAPaymentCompanyCode,
  CAPaymentCompanyCodeName,
  HouseBank,
  HouseBankName,
  HouseBankAccount,
  HouseBankAccountDescription,
  TransactionCurrency,
  PaidAmountInPaytCurrency,
  concat_with_space(AddressStreetName, AddressHouseNumber, 1) AS AddressLine1,
  concat_with_space(AddressPostalCode, CityName, 1) AS AddressLine2,
  PayeeCountry,
  PayeeCountryName,
  ValueDate,
  UniqueEndToEndTransactionID,
  BankNumber,
  BankAccount,
  BankCountry,
  BankCountryName,
  CABankAccountHolderName,
  PayeeBank,
  BankName,
  PayeeBankCountry,
  PayeeBankCountryName,
  PayeeBankNumber,
  PayeeBankAccount,
  PayeeIBAN,
  _CAPaymentListRepaymentReqItm.CAPostingDate AS CAPostingDate,
  _CARepaymentRequest.CARepaymentRequestDocument AS CARepaymentRequestDocument,
  _CARepaymentRequest.CANoteToPayeeInPayment AS CANoteToPayeeInPayment
FROM P_CAPaymentListPayment
LEFT OUTER JOIN I_CAPaymentMethod AS _CAPaymentMethod ON CAPaymentMethod = _CAPaymentMethod.CAPaymentMethod AND CompanyCodeCountry = _CAPaymentMethod.Country  -- association [0..1]
LEFT OUTER JOIN C_CAPaymentListRepaymentReqItm AS _CAPaymentListRepaymentReqItm ON CAMassRunDate = _CAPaymentListRepaymentReqItm.CAMassRunDate AND CAMassRunID = _CAPaymentListRepaymentReqItm.CAMassRunID AND CARepaymentRequest = _CAPaymentListRepaymentReqItm.CARepaymentRequest  -- association [1..*]
LEFT OUTER JOIN I_CADocumentHeader AS _DocHeader ON CAPaymentDocument = _DocHeader.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_CARepaymentRequest AS _CARepaymentRequest ON CARepaymentRequest = _CARepaymentRequest.CARepaymentRequest  -- association [0..1]
;