C_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 C_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: CCAPAYLISTGROUP

CREATE VIEW C_CAPaymentListGroup AS
SELECT
  CAMassRunDate,
  CAMassRunID,
  CAInternalPaymentGroup,
  TransactionCurrency,
  CAPaymentMediumFormat,
  CAPaymentMediumFormatName,
  CAPaymentCompanyCode,
  CAPaymentCompanyCodeName,
  HouseBank,
  HouseBankName,
  HouseBankAccount,
  HouseBankAccountDescription,
  CompanyCodeCountry,
  CAPaymentMethod,
  _CAPaymentMethod._Text[1: Language=$session.system_language].CAPaymentMethodName AS CAPaymentMethodName,
  NumberOfPayments AS NumberOfCreatedPayments,
  NumberOfPaymentsInFile,
  BankAmountByGroup AS BankAmountInTransactionCrcy,
  NumberOfPaymentsByGroup AS NumberOfPayments,
  NumberOfRepaymentReqByGroup AS NumberOfRepaymentRequests,
  NumberOfPaymentOrdersByGroup AS NumberOfPaymentOrders
FROM P_CAPaymentListGroup
LEFT OUTER JOIN I_CAPaymentMethod AS _CAPaymentMethod ON CAPaymentMethod = _CAPaymentMethod.CAPaymentMethod AND CompanyCodeCountry = _CAPaymentMethod.Country  -- association [0..1]
LEFT OUTER JOIN C_CAPaytListGrpPayment AS _CAPaytListGrpPayment ON CAMassRunDate = _CAPaytListGrpPayment.CAMassRunDate AND CAMassRunID = _CAPaytListGrpPayment.CAMassRunID AND CAInternalPaymentGroup = _CAPaytListGrpPayment.CAInternalPaymentGroup AND TransactionCurrency = _CAPaytListGrpPayment.TransactionCurrency  -- association [0..*]
LEFT OUTER JOIN C_CAPaytListGrpRepaymentReq AS _CAPaytListGrpRepaymentReq ON CAMassRunDate = _CAPaytListGrpRepaymentReq.CAMassRunDate AND CAMassRunID = _CAPaytListGrpRepaymentReq.CAMassRunID AND CAInternalPaymentGroup = _CAPaytListGrpRepaymentReq.CAInternalPaymentGroup AND TransactionCurrency = _CAPaytListGrpRepaymentReq.TransactionCurrency  -- association [0..*]
LEFT OUTER JOIN C_CAPaytListGrpPaymentOrder AS _CAPaytListGrpPaymentOrder ON CAMassRunDate = _CAPaytListGrpPaymentOrder.CAMassRunDate AND CAMassRunID = _CAPaytListGrpPaymentOrder.CAMassRunID AND CAInternalPaymentGroup = _CAPaytListGrpPaymentOrder.CAInternalPaymentGroup AND TransactionCurrency = _CAPaytListGrpPaymentOrder.TransactionCurrency  -- association [0..*]
;