P_CollsSumAmtInPeriod

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_CollsSumAmtInPeriod.
-- 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.

CREATE VIEW P_CollsSumAmtInPeriod AS
SELECT
  BusinessPartner,
  CollectionSegment,
  CollStrgyCurrency,
  sum( AmountOverdue4 ) AS AmountOverdue4,
  sum( AmountOverdue3 ) AS AmountOverdue3,
  sum( AmountOverdue2 ) AS AmountOverdue2,
  sum( AmountOverdue1 ) AS AmountOverdue1,
  sum( AmountDue1 ) AS AmountDue1,
  sum( AmountDue2 ) AS AmountDue2,
  sum( AmountDue3 ) AS AmountDue3,
  sum( AmountDue4 ) AS AmountDue4
FROM P_CollsAcctDocAged
;