C_CAPaymentListPayment

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_CAPaymentListPayment.
-- 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: CCAPAYLISTPAYMT

CREATE VIEW C_CAPaymentListPayment AS
SELECT
  CAMassRunDate,
  CAMassRunID,
  CAIntPaymentIdentification,
  CAIntAddlPaymentIdentification,
  CAInternalPaymentGroup,
  IsBusinessPurposeCompleted,
  CAAuthorizationGroup,
  CADocumentNumber AS CAPaymentDocument,
  _DocHeader.DocumentDate AS DocumentDate,
  TransactionCurrency,
  CAPaymentMethod,
  CompanyCodeCountry,
  _CAPaymentMethod._Text[1: Language=$session.system_language].CAPaymentMethodName AS CAPaymentMethodName,
  BusinessPartner,
  BusinessPartnerName,
  ContractAccount,
  ContractAccountName,
  CAPaymentCompanyCode,
  CAPaymentCompanyCodeName,
  CABusinessAreaInPaymentDoc,
  HouseBank,
  HouseBankName,
  HouseBankAccount,
  HouseBankAccountDescription,
  BankAmountInTransactionCrcy,
  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,
  _CADocumentGLItemPaymentData.PaymentCardHolderName AS PaymentCardHolderName,
  PaymentCardType,
  CardNumber,
  _CADocumentGLItemPaymentData.PaymentCardValidityEndDate AS PaymentCardValidityEndDate,
  CAPaymentSpecificationRef,
  CAPromiseToPay,
  CAPromisedPaymentDate
FROM P_CAPaymentListPayment
LEFT OUTER JOIN I_CAPaymentMethod AS _CAPaymentMethod ON CAPaymentMethod = _CAPaymentMethod.CAPaymentMethod AND CompanyCodeCountry = _CAPaymentMethod.Country  -- association [0..1]
LEFT OUTER JOIN I_CADocumentGLItemPaymentData AS _CADocumentGLItemPaymentData ON CAPaymentDocument = _CADocumentGLItemPaymentData.CADocumentNumber  -- association [1..1]
LEFT OUTER JOIN C_CAPaymentListPaymentItem AS _CAPaymentListPaymentItem ON CAMassRunDate = _CAPaymentListPaymentItem.CAMassRunDate AND CAMassRunID = _CAPaymentListPaymentItem.CAMassRunID AND CAIntPaymentIdentification = _CAPaymentListPaymentItem.CAIntPaymentIdentification AND CAIntAddlPaymentIdentification = _CAPaymentListPaymentItem.CAIntAddlPaymentIdentification  -- association [1..*]
LEFT OUTER JOIN I_CADocument AS _DocHeader ON CAPaymentDocument = _DocHeader.CADocumentNumber  -- association [0..1]
;