FINOC_ACDOCA_SEGMENT_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 FINOC_ACDOCA_SEGMENT_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.
-- SQL view name: FINOCV_AC_SEGB
-- Parameters: p_date : datum, p_base : fins_ledger, p_sim : fins_ledger, p_reset_clear : char1

CREATE VIEW FINOC_ACDOCA_SEGMENT_BASE AS
SELECT
  $parameters.p_base AS rldnr,
  a.rbukrs AS rbukrs,
  coalesce( p.gjahr, a.gjahr ) AS gjahr,
  coalesce( p.belnr, a.belnr ) AS belnr,
  coalesce( p.buzei, a.buzei ) AS buzei,
  coalesce( p.docln, a.docln ) AS docln,
  coalesce( p.awitem, a.awitem ) AS awitem,
  a.prctr AS prctr,
  a.kokrs AS kokrs,
  a.segment AS segment,
  a.wsl AS wsl,
  a.tsl AS tsl,
  a.hsl AS hsl,
  a.ksl AS ksl,
  a.osl AS osl,
  a.vsl AS vsl,
  a.bsl AS bsl,
  a.csl AS csl,
  a.dsl AS dsl,
  a.esl AS esl,
  a.fsl AS fsl,
  a.gsl AS gsl,
  a.fcsl AS fcsl,
  a.rwcur AS rwcur,
  a.rtcur AS rtcur,
  a.rhcur AS rhcur,
  a.rkcur AS rkcur,
  a.rocur AS rocur,
  a.rvcur AS rvcur,
  a.rbcur AS rbcur,
  a.rccur AS rccur,
  a.rdcur AS rdcur,
  a.recur AS recur,
  a.rfcur AS rfcur,
  a.rgcur AS rgcur,
  a.rfccur AS rfccur,
  cast ( '00000000' as budat ) AS budat,
  'Y' AS p_correction
FROM acdoca AS a
LEFT OUTER JOIN acdoca AS p ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): acdoca
;