fco_ovhd_cost_co_values

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 fco_ovhd_cost_co_values.
-- 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.

CREATE VIEW fco_ovhd_cost_co_values AS
SELECT
  a.lednr AS lednr,
  a.gjahr AS gjahr,
  a.bukrs AS bukrs,
  '04' AS wrttp,
  a.objnr AS objnr,
  a.vrgng AS vrgng,
  a.beknz AS beknz,
  a.kstar AS kstar,
  a.hrkft AS hrkft,
  a.vbund AS vbund,
  a.pargb AS pargb,
  a.parob AS parob,
  a.uspob AS uspob,
  a.twaer AS twaer,
  a.meinh AS meinh,
  a.beltp AS beltp,
  a.perio AS perio,
  a.timestmp AS timestmp,
  a.hwaer AS hwaer,
  a.versn AS versn,
  a.parob1 AS parob1,
  a.coep_vbund AS coep_vbund,
  a.coep_pargb AS coep_pargb,
  a.co_belnr AS co_belnr,
  a.aworg AS aworg,
  a.awtyp AS awtyp,
  a.awsys AS awsys,
  a.awref AS awref,
  a.budat AS budat,
  a.bldat AS bldat,
  ( a.wtgbtr_add - a.wtgbtr_subtract) AS wtgbtr,
  ( a.wogbtr_add - a.wogbtr_subtract) AS wogbtr,
  ( a.wkgbtr_add - a.wkgbtr_subtract) AS wkgbtr,
  ( a.wkfbtr_add - a.wkfbtr_subtract) AS wkfbtr,
  ( a.pagbtr_add - a.pagbtr_subtract) AS pagbtr,
  ( a.pafbtr_add - a.pafbtr_subtract) AS pafbtr,
  a.megbtr AS megbtr,
  a.mefbtr AS mefbtr,
  a.wagbtr AS wagbtr,
  a.wvgbtr AS wvgbtr,
  a.wbgbtr AS wbgbtr,
  a.wcgbtr AS wcgbtr,
  a.wdgbtr AS wdgbtr,
  a.wegbtr AS wegbtr,
  a.wfgbtr AS wfgbtr,
  a.wggbtr AS wggbtr,
  a.whgbtr AS whgbtr,
  a.awaer AS awaer,
  a.vwaer AS vwaer,
  a.bwaer AS bwaer,
  a.cwaer AS cwaer,
  a.dwaer AS dwaer,
  a.ewaer AS ewaer,
  a.fwaer AS fwaer,
  a.gwaer AS gwaer,
  a.kwaer AS kwaer,
  a.fkber AS fkber,
  a.segment AS segment,
  a.geber AS geber,
  a.grant_nbr AS grant_nbr,
  a.budget_pd AS budget_pd,
  a.pfkber AS pfkber,
  a.psegment AS psegment,
  a.pgeber AS pgeber,
  a.pgrant_nbr AS pgrant_nbr,
  a.pbudget_pd AS pbudget_pd,
  a.arbid AS arbid,
  a.aufnr_org AS aufnr_org,
  a.vornr_org AS vornr_org
FROM fco_ovhd_cost_co_values1 AS a
;