Fins_Rev_Rec_Data_View

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.
-- 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 AS
SELECT
  rldnr,
  objnr,
  ps_prj_pnr,
  ps_posid,
  ps_psp_pnr,
  ps_pspid,
  paobjnr,
  aufnr,
  kdauf,
  kdpos,
  vtkey,
  vtpos,
  ra_pob_id,
  gjahr,
  poper,
  fiscyearper,
  budat,
  hkont,
  gkont,
  slalittype,
  rtind,
  bukrs,
  werks,
  gsber,
  prctr,
  matnr,
  kunnr,
  cast(' ' as rassc) AS vbund,
  pernr,
  rsrce,
  uprctr,
  rwcur,
  rhcur,
  rkcur,
  rocur,
  rvcur,
  rbcur,
  rccur,
  rdcur,
  recur,
  rfcur,
  rgcur,
  rco_ocur,
  runit,
  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 FINS_REV_REC_DATA_VIEW_base
;