P_IntApportnmntTotals

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_IntApportnmntTotals.
-- 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: PINTAPPRTMTTOTAL
-- Parameters: P_PoolID : psm_pool_id, P_Year : num4, P_Period : num2

CREATE VIEW P_IntApportnmntTotals AS
SELECT
  $parameters.P_PoolID AS PoolID,
  CompanyCode,
  Fund,
  GrantID,
  ProfitCenter,
  Segment,
  InvestmentPoolUUID,
  InvestmentPooledFund,
  ControllingArea,
  sum( TotalBalance ) AS total,
  CompanyCodeCurrency,
  sum( BalanceDay0 ) AS BalanceDay0,
  sum( BalanceDay1 ) AS BalanceDay1,
  sum( BalanceDay2 ) AS BalanceDay2,
  sum( BalanceDay3 ) AS BalanceDay3,
  sum( BalanceDay4 ) AS BalanceDay4,
  sum( BalanceDay5 ) AS BalanceDay5,
  sum( BalanceDay6 ) AS BalanceDay6,
  sum( BalanceDay7 ) AS BalanceDay7,
  sum( BalanceDay8 ) AS BalanceDay8,
  sum( BalanceDay9 ) AS BalanceDay9,
  sum( BalanceDay10 ) AS BalanceDay10,
  sum( BalanceDay11 ) AS BalanceDay11,
  sum( BalanceDay12 ) AS BalanceDay12,
  sum( BalanceDay13 ) AS BalanceDay13,
  sum( BalanceDay14 ) AS BalanceDay14,
  sum( BalanceDay15 ) AS BalanceDay15,
  sum( BalanceDay16 ) AS BalanceDay16,
  sum( BalanceDay17 ) AS BalanceDay17,
  sum( BalanceDay18 ) AS BalanceDay18,
  sum( BalanceDay19 ) AS BalanceDay19,
  sum( BalanceDay20 ) AS BalanceDay20,
  sum( BalanceDay21 ) AS BalanceDay21,
  sum( BalanceDay22 ) AS BalanceDay22,
  sum( BalanceDay23 ) AS BalanceDay23,
  sum( BalanceDay24 ) AS BalanceDay24,
  sum( BalanceDay25 ) AS BalanceDay25,
  sum( BalanceDay26 ) AS BalanceDay26,
  sum (BalanceDay27 ) AS BalanceDay27,
  sum( BalanceDay28 ) AS BalanceDay28,
  sum( BalanceDay29 ) AS BalanceDay29,
  sum( BalanceDay30 ) AS BalanceDay30,
  sum( BalanceDay31 ) AS BalanceDay31
FROM P_IntApportnmntAggrgtns
;