FINOC_TRANSFER_APAR

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 FINOC_TRANSFER_APAR.
-- 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.
-- SQL view name: FINOCV_APAR

CREATE VIEW FINOC_TRANSFER_APAR AS
SELECT
  acdoca_buzei.rldnr AS rldnr,
  splinfo.bukrs AS rbukrs,
  splinfo.gjahr AS gjahr,
  splinfo.belnr AS belnr,
  splinfo.buzei AS buzei,
  splinfo.spl_no AS spl_no,
  splinfo_val.curtp AS curtp,
  0 AS seqno,
  acdoca_buzei.docln AS docln,
  splinfo.kdpos AS kdpos,
  splinfo.matnr AS matnr,
  splinfo.kostl AS rcntr,
  splinfo.anln2 AS anln2,
  splinfo.aplzl AS aplzl,
  _acdoca.vornr AS vornr,
  splinfo.egrup AS egrup,
  splinfo.vptnr AS vptnr,
  splinfo.vname AS vname,
  splinfo.geber AS rfund,
  splinfo.grant_nbr AS rgrant_nbr,
  splinfo.fkber AS rfarea,
  _acdoca.budat AS budat,
  _acdoca.poper AS poper,
  _acdoca.bstat AS bstat,
  _acdoca.augdt AS augdt,
  _acdoca.augbl AS augbl,
  _acdoca.vorgn AS vorgn,
  _acdoca.awtyp AS awtyp,
  cast( ' ' as finoc_orgl_change preserving type ) AS orgl_change,
  _acdoca.slalittype AS slalittype,
  _acdoca.ktosl AS ktosl,
  splinfo.pswbt AS pswbt,
  splinfo_val.waers AS waers,
  splinfo_val.wrbtr AS wrbtr,
  splinfo.prctr AS prctr_old
FROM fagl_splinfo AS splinfo
INNER JOIN fagl_splinfo_val AS splinfo_val ON /* join condition not captured in parsed metadata */
INNER JOIN FINOC_ACDOCA_BUZEI AS acdoca_buzei ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN acdoca AS acdoca_prec ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN acdoca AS _acdoca ON rldnr = _acdoca.rldnr AND rbukrs = _acdoca.rbukrs AND gjahr = _acdoca.gjahr AND belnr = _acdoca.belnr AND docln = _acdoca.docln  -- association [0..1]
LEFT OUTER JOIN fagl_splinfo AS _splinfo ON belnr = _splinfo.belnr AND gjahr = _splinfo.gjahr AND rbukrs = _splinfo.bukrs AND buzei = _splinfo.buzei AND spl_no = _splinfo.spl_no  -- association [0..1]
;