P_Gmia_sum_view

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_Gmia_sum_view.
-- 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: P_GMIA_SUM

CREATE VIEW P_Gmia_sum_view AS
SELECT
  rclnt,
  rldnr,
  rrcty,
  rvers,
  ryear,
  robjnr,
  cobjnr,
  sobjnr,
  rtcur,
  runit,
  rpmax,
  rbukrs,
  rgrant_nbr,
  rfund,
  rvaluetype_9,
  rtrans,
  rstats_ind,
  logsys,
  bdgt_state,
  sum(tslvt) AS tslvt,
  sum(tsl01) AS tsl01,
  sum(tsl02) AS tsl02,
  sum(tsl03) AS tsl03,
  sum(tsl04) AS tsl04,
  sum(tsl05) AS tsl05,
  sum(tsl06) AS tsl06,
  sum(tsl07) AS tsl07,
  sum(tsl08) AS tsl08,
  sum(tsl09) AS tsl09,
  sum(tsl10) AS tsl10,
  sum(tsl11) AS tsl11,
  sum(tsl12) AS tsl12,
  sum(tsl13) AS tsl13,
  sum(tsl14) AS tsl14,
  sum(tsl15) AS tsl15,
  sum(tsl16) AS tsl16,
  sum(hslvt) AS hslvt,
  sum(hsl01) AS hsl01,
  sum(hsl02) AS hsl02,
  sum(hsl03) AS hsl03,
  sum(hsl04) AS hsl04,
  sum(hsl05) AS hsl05,
  sum(hsl06) AS hsl06,
  sum(hsl07) AS hsl07,
  sum(hsl08) AS hsl08,
  sum(hsl09) AS hsl09,
  sum(hsl10) AS hsl10,
  sum(hsl11) AS hsl11,
  sum(hsl12) AS hsl12,
  sum(hsl13) AS hsl13,
  sum(hsl14) AS hsl14,
  sum(hsl15) AS hsl15,
  sum(hsl16) AS hsl16,
  sum(mslvt) AS mslvt,
  sum(msl01) AS msl01,
  sum(msl02) AS msl02,
  sum(msl03) AS msl03,
  sum(msl04) AS msl04,
  sum(msl05) AS msl05,
  sum(msl06) AS msl06,
  sum(msl07) AS msl07,
  sum(msl08) AS msl08,
  sum(msl09) AS msl09,
  sum(msl10) AS msl10,
  sum(msl11) AS msl11,
  sum(msl12) AS msl12,
  sum(msl13) AS msl13,
  sum(msl14) AS msl14,
  sum(msl15) AS msl15,
  sum(msl16) AS msl16,
  ' ' AS cspred,
  ' ' AS qspred
FROM P_Gmia_Tot_View
;