FINS_REV_REC_ACDOCA_API

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_ACDOCA_API.
-- 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_Budat : budat

CREATE VIEW FINS_REV_REC_ACDOCA_API AS
SELECT
  rldnr,
  ps_psp_pnr,
  pernr,
  slalittype,
  runit,
  racct AS hkont,
  rsrce,
  matnr,
  rwcur,
  rhcur,
  rkcur,
  rocur,
  rvcur,
  rbcur,
  rccur,
  rdcur,
  recur,
  rfcur,
  rgcur,
  rco_ocur,
  sum(msl) AS msl,
  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
FROM acdoca
;