FINOC_ACDOCA_SEGMENT

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.
-- 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_SEG
-- Parameters: p_date : datum, p_correction : char1, p_base : fins_ledger, p_sim : fins_ledger, p_reset_clear : char1

CREATE VIEW FINOC_ACDOCA_SEGMENT AS
SELECT
  s.rldnr AS rldnr,
  s.rbukrs AS rbukrs,
  s.gjahr AS gjahr,
  s.belnr AS belnr,
  s.docln AS docln,
  s.buzei AS buzei,
  s.awitem AS awitem,
  s.wsl_sum AS wsl,
  s.tsl_sum AS tsl,
  s.hsl_sum AS hsl,
  s.ksl_sum AS ksl,
  s.osl_sum AS osl,
  s.vsl_sum AS vsl,
  s.bsl_sum AS bsl,
  s.csl_sum AS csl,
  s.dsl_sum AS dsl,
  s.esl_sum AS esl,
  s.fsl_sum AS fsl,
  s.gsl_sum AS gsl,
  s.fcsl_sum AS fcsl,
  s.rwcur AS rwcur,
  s.rtcur AS rtcur,
  s.rhcur AS rhcur,
  s.rkcur AS rkcur,
  s.rocur AS rocur,
  s.rvcur AS rvcur,
  s.rbcur AS rbcur,
  s.rccur AS rccur,
  s.rdcur AS rdcur,
  s.recur AS recur,
  s.rfcur AS rfcur,
  s.rgcur AS rgcur,
  s.rfccur AS rfccur,
  s.prctr AS prctr,
  s.kokrs AS kokrs,
  s.segment AS segment,
  rt.orgl_change AS orgl_change,
  rt.prctr AS prctr_rt,
  rt.segment_old AS segment_old,
  rt.segment AS segment_new,
  s.budat AS budat
FROM FINOC_ACDOCA_SEGMENT_sum
LEFT OUTER JOIN finoc_segment AS seg 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]
;