FM_sum_Fmia

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 FM_sum_Fmia.
-- 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: FMV_SUM_FMIA

CREATE VIEW FM_sum_Fmia AS
SELECT
  rclnt,
  rldnr,
  RRCTY,
  rvers,
  ryear,
  ROBJNR,
  COBJNR,
  SOBJNR,
  rtcur,
  rpmax,
  rbukrs,
  rfistl,
  rfonds,
  rfipex,
  rwrttp,
  rbtart,
  rgnjhr,
  rhkont,
  rstats,
  rcflev,
  robjnrz,
  rvrgng,
  ruserdim,
  rfarea,
  rmeasure,
  LOGSYS,
  grant_nbr,
  rbusa,
  budget_pd,
  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,
  CSPRED,
  fikrs,
  DISTKEY
FROM FM_tot_Fmia
;