P_CAPaymentListGroup

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_CAPaymentListGroup.
-- 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: PCAPAYLISTGROUP

CREATE VIEW P_CAPaymentListGroup AS
SELECT
  CAMassRunDate,
  CAMassRunID,
  CAInternalPaymentGroup,
  CAInternalPaymentGroupName,
  CAPaymentMediumFormat,
  CAPaymentMediumFormatName,
  CAPaymentCompanyCode,
  _CompanyCode.Country AS CompanyCodeCountry,
  _CompanyCode.CompanyCodeName AS CAPaymentCompanyCodeName,
  HouseBank,
  _HouseBank._Bank.BankName AS HouseBankName,
  HouseBankAccount,
  _HouseBankAccount._Text[1: Language=$session.system_language].HouseBankAccountDescription AS HouseBankAccountDescription,
  CAPaymentMethod,
  NumberOfPayments,
  NumberOfPaymentsInFile,
  TransactionCurrency,
  BankAmountByGroup,
  NumberOfPaymentsByGroup,
  NumberOfRepaymentReqByGroup,
  NumberOfPaymentOrdersByGroup
FROM P_CAPaymentListGroupPre2
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CAPaymentCompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON CAPaymentCompanyCode = _HouseBank.CompanyCode AND HouseBank = _HouseBank.HouseBank  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccount AS _HouseBankAccount ON CAPaymentCompanyCode = _HouseBankAccount.CompanyCode AND HouseBank = _HouseBankAccount.HouseBank AND HouseBankAccount = _HouseBankAccount.HouseBankAccount  -- association [0..1]
;