FINS_REV_REC_COSACT_VIEW2_BAS

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 FINS_REV_REC_COSACT_VIEW2_BAS.
-- 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.
-- Parameters: p_fiscyearper : jahrper

CREATE VIEW FINS_REV_REC_COSACT_VIEW2_BAS AS
SELECT
  a.rldnr AS rldnr,
  a.objnr AS objnr,
  a.ps_posid AS ps_posid,
  a.ps_psp_pnr AS ps_psp_pnr,
  a.paobjnr AS paobjnr,
  a.aufnr AS aufnr,
  a.kdauf AS kdauf,
  a.kdpos AS kdpos,
  a.vtkey AS vtkey,
  a.vtpos AS vtpos,
  a.racct AS hkont,
  a.gkont AS gkont,
  a.slalittype AS slalittype,
  a.rbukrs AS bukrs,
  a.werks AS werks,
  a.rbusa AS gsber,
  a.prctr AS prctr,
  a.matnr AS matnr,
  a.pernr AS pernr,
  a.rsrce AS rsrce,
  a.uprctr AS uprctr,
  a.bttype AS bttype,
  cast( case a.bttype when 'RFCV' then a.bttype else ( case a.vrgng when '' then a.vorgn when 'COIE' then a.vorgn when 'COIN' then a.vorgn else a.vrgng end ) end as fins_trr_bttype ) AS bttype_tec,
  a.beltp AS beltp,
  a.rwcur AS rwcur,
  a.rhcur AS rhcur,
  a.rkcur AS rkcur,
  a.rocur AS rocur,
  a.rvcur AS rvcur,
  a.rbcur AS rbcur,
  a.rccur AS rccur,
  a.rdcur AS rdcur,
  a.recur AS recur,
  a.rfcur AS rfcur,
  a.rgcur AS rgcur,
  a.rco_ocur AS rco_ocur,
  a.runit AS runit,
  max(a.budat) AS max_budat,
  sum(a.wsl) AS wsl,
  sum(a.hsl) AS hsl,
  sum(a.ksl) AS ksl,
  sum(a.kfsl) AS kfsl,
  sum(a.osl) AS osl,
  sum(a.vsl) AS vsl,
  sum(a.bsl) AS bsl,
  sum(a.csl) AS csl,
  sum(a.dsl) AS dsl,
  sum(a.esl) AS esl,
  sum(a.fsl) AS fsl,
  sum(a.gsl) AS gsl,
  sum(a.co_osl) AS co_osl,
  sum(a.msl) AS msl
FROM acdoca AS a
INNER JOIN finsc_ld_cmp AS v ON /* join condition not captured in parsed metadata */
;