P_Paymentstatistics_Days

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_Paymentstatistics_Days.
-- 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: PPSDAYS
-- Parameters: P_KeyDate : sydate

CREATE VIEW P_Paymentstatistics_Days AS
SELECT
  Base.CompanyCode AS CompanyCode,
  Base.PayeeBankCountry AS PayeeBankCountry,
  Base.PayeeBankInternalID AS PayeeBankInternalID,
  Base.BankKey AS BankKey,
  Base.BankCountryKey AS BankCountryKey,
  Base.PaymentMethod AS PaymentMethod,
  Base.PaymentBatch AS PaymentBatch,
  Base.PaymentBatchRule AS PaymentBatchRule,
  sum(Base.NumberOfPayments) AS NumberOfPayments,
  Base.Status AS GeneralStatus,
  Base.PaymentProcessingStatus AS PaymentProcessingStatus,
  Base.IsUrgentPayment AS IsUrgentPayment,
  Base.CreationDate AS CreationDate,
  Base.LastChangeDate AS LastChangeDate,
  dats_days_between(Base.CreationDate, $parameters.P_KeyDate) AS NumberOfDaysInPeriod,
  Base.PaymentCurrency AS PaymentCurrency,
  sum(Base.AmountInPaymentCurrency) AS AmountInPaymentCurrency
FROM I_Paymentstatistics_Base AS Base
;