P_GMAVCT_Old

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_GMAVCT_Old.
-- 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: PGMAVCT_OLD

CREATE VIEW P_GMAVCT_Old AS
SELECT
  rclnt,
  rldnr,
  rrcty,
  rvers,
  ryear,
  robjnr,
  cobjnr,
  sobjnr,
  rtcur,
  runit,
  drcrk,
  rpmax,
  rbukrs,
  rgrant_nbr,
  rfund,
  ceffyear_9,
  wfstate_9,
  alloctype_9,
  logsys,
  grantee_fy_9,
  sbukrs,
  tslvt,
  tsl01,
  tsl02,
  tsl03,
  tsl04,
  tsl05,
  tsl06,
  tsl07,
  tsl08,
  tsl09,
  tsl10,
  tsl11,
  tsl12,
  tsl13,
  tsl14,
  tsl15,
  tsl16,
  hslvt,
  hsl01,
  hsl02,
  hsl03,
  hsl04,
  hsl05,
  hsl06,
  hsl07,
  hsl08,
  hsl09,
  hsl10,
  hsl11,
  hsl12,
  hsl13,
  hsl14,
  hsl15,
  hsl16,
  cast(0 as kslvt9_cs) AS kslvt,
  cast(0 as kslxx9_cs) AS ksl01,
  cast(0 as kslxx9_cs) AS ksl02,
  cast(0 as kslxx9_cs) AS ksl03,
  cast(0 as kslxx9_cs) AS ksl04,
  cast(0 as kslxx9_cs) AS ksl05,
  cast(0 as kslxx9_cs) AS ksl06,
  cast(0 as kslxx9_cs) AS ksl07,
  cast(0 as kslxx9_cs) AS ksl08,
  cast(0 as kslxx9_cs) AS ksl09,
  cast(0 as kslxx9_cs) AS ksl10,
  cast(0 as kslxx9_cs) AS ksl11,
  cast(0 as kslxx9_cs) AS ksl12,
  cast(0 as kslxx9_cs) AS ksl13,
  cast(0 as kslxx9_cs) AS ksl14,
  cast(0 as kslxx9_cs) AS ksl15,
  cast(0 as kslxx9_cs) AS ksl16,
  mslvt,
  msl01,
  msl02,
  msl03,
  msl04,
  msl05,
  msl06,
  msl07,
  msl08,
  msl09,
  msl10,
  msl11,
  msl12,
  msl13,
  msl14,
  msl15,
  msl16,
  cspred,
  qspred
FROM gmavct
;