P_FMBDT_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_FMBDT_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: PFMBDT_OLD

CREATE VIEW P_FMBDT_Old AS
SELECT
  rclnt,
  rldnr,
  rrcty,
  rvers,
  ryear,
  robjnr,
  cobjnr,
  sobjnr,
  rtcur,
  drcrk,
  rpmax,
  rfikrs,
  rfund,
  rfundsctr,
  rcmmtitem,
  rfuncarea,
  ruserdim,
  rgrant_nbr,
  rmeasure,
  budget_pd_9,
  ceffyear_9,
  valtype_9,
  wfstate_9,
  process_9,
  budtype_9,
  logsys,
  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,
  cspred
FROM fmbdt
;