FINS_REV_REC_DATA_VIEW_base

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_DATA_VIEW_base.
-- 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 FINS_REV_REC_DATA_VIEW_base AS
SELECT
  a.rldnr AS rldnr,
  objnr,
  ps_prj_pnr,
  ps_posid,
  ps_psp_pnr,
  ps_pspid,
  paobjnr,
  aufnr,
  kdauf,
  kdpos,
  vtkey,
  vtpos,
  ra_pob_id,
  ryear AS gjahr,
  poper,
  fiscyearper,
  budat,
  racct AS hkont,
  gkont,
  slalittype,
  cast( case awtyp when 'TBRR' then ' ' else 'X' end as fins_trr_real_time ) AS rtind,
  rbukrs AS bukrs,
  werks,
  rbusa AS gsber,
  prctr,
  matnr,
  kunnr,
  pernr,
  rsrce,
  uprctr,
  rwcur,
  rhcur,
  rkcur,
  rocur,
  rvcur,
  rbcur,
  rccur,
  rdcur,
  recur,
  rfcur,
  rgcur,
  rco_ocur,
  runit,
  max(budat) AS max_budat,
  sum(wsl) AS wsl,
  sum(hsl) AS hsl,
  sum(ksl) AS ksl,
  sum(kfsl) AS kfsl,
  sum(osl) AS osl,
  sum(vsl) AS vsl,
  sum(bsl) AS bsl,
  sum(csl) AS csl,
  sum(dsl) AS dsl,
  sum(esl) AS esl,
  sum(fsl) AS fsl,
  sum(gsl) AS gsl,
  sum(co_osl) AS co_osl,
  sum(msl) AS msl
FROM acdoca AS a
;