Fins_Rev_Rec_uprctr_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_uprctr_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_uprctr_View AS
SELECT
  a.rldnr AS rldnr,
  a.belnr AS belnr,
  a.docln AS docln,
  a.rbukrs AS bukrs,
  a.gjahr AS docyear,
  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.ryear AS gjahr,
  a.poper AS poper,
  a.fiscyearper AS fiscyearper,
  a.budat AS budat,
  a.racct AS hkont,
  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.ukostl AS ukostl,
  a.pernr AS pernr,
  a.rsrce AS rsrce,
  a.uprctr AS uprctr
FROM acdoca AS a
INNER JOIN finsc_ld_cmp AS v ON /* join condition not captured in parsed metadata */
;