FGL_GLTT2

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 FGL_GLTT2.
-- 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: FGLV_GLTT2

CREATE VIEW FGL_GLTT2 AS
SELECT
  rclnt,
  ryear,
  objnr00,
  objnr01,
  objnr02,
  objnr03,
  objnr04,
  objnr05,
  objnr06,
  objnr07,
  objnr08,
  drcrk,
  rpmax,
  activ,
  rmvct,
  rtcur,
  runit,
  awtyp,
  rldnr,
  rrcty,
  rvers,
  logsys,
  racct,
  cost_elem,
  rbukrs,
  rcntr,
  prctr,
  rfarea,
  rbusa,
  kokrs,
  segment,
  scntr,
  pprctr,
  sfarea,
  sbusa,
  rassc,
  psegment,
  fikrs,
  rfund,
  rgrant_nbr,
  rbudget_pd,
  sfund,
  sgrant_nbr,
  sbudget_pd,
  re_bukrs,
  re_account,
  vname,
  egrup,
  recid,
  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(kslvt) AS kslvt,
  sum(ksl01) AS ksl01,
  sum(ksl02) AS ksl02,
  sum(ksl03) AS ksl03,
  sum(ksl04) AS ksl04,
  sum(ksl05) AS ksl05,
  sum(ksl06) AS ksl06,
  sum(ksl07) AS ksl07,
  sum(ksl08) AS ksl08,
  sum(ksl09) AS ksl09,
  sum(ksl10) AS ksl10,
  sum(ksl11) AS ksl11,
  sum(ksl12) AS ksl12,
  sum(ksl13) AS ksl13,
  sum(ksl14) AS ksl14,
  sum(ksl15) AS ksl15,
  sum(ksl16) AS ksl16,
  sum(oslvt) AS oslvt,
  sum(osl01) AS osl01,
  sum(osl02) AS osl02,
  sum(osl03) AS osl03,
  sum(osl04) AS osl04,
  sum(osl05) AS osl05,
  sum(osl06) AS osl06,
  sum(osl07) AS osl07,
  sum(osl08) AS osl08,
  sum(osl09) AS osl09,
  sum(osl10) AS osl10,
  sum(osl11) AS osl11,
  sum(osl12) AS osl12,
  sum(osl13) AS osl13,
  sum(osl14) AS osl14,
  sum(osl15) AS osl15,
  sum(osl16) AS osl16,
  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,
  max(timestamp) AS timestamp
FROM FGL_GLTT1
;