JV_ACDOCA_JVSO2_SWITCH

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 JV_ACDOCA_JVSO2_SWITCH.
-- 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: CACDOCA_JVSO2_SW

CREATE VIEW JV_ACDOCA_JVSO2_SWITCH AS
SELECT
  acdoca.rbukrs AS rbukrs,
  acdoca.gjahr AS gjahr,
  acdoca.belnr AS belnr,
  acdoca.docln AS docln,
  acdoca.buzei AS buzei,
  acdoca.co_belnr AS co_belnr,
  acdoca.co_buzei AS co_buzei,
  acdoca.awref AS awref,
  acdoca.aworg AS aworg,
  acdoca.awitem AS awitem,
  acdoca.awtyp AS awtyp,
  acdoca.awsys AS awsys,
  acdoca.ryear AS ryear,
  acdoca.poper AS poper,
  acdoca.budat AS budat,
  acdoca.bldat AS bldat,
  acdoca.vorgn AS vorgn,
  acdoca.blart AS blart,
  acdoca.vname AS vname,
  acdoca.egrup AS egrup,
  acdoca.btype AS btype,
  acdoca.kunnr AS kunnr,
  acdoca.vptnr AS vptnr,
  acdoca.billm AS billm,
  acdoca.pom AS pom,
  acdoca.jvactivity AS jvactivity,
  acdoca.sgtxt AS sgtxt,
  acdoca.rwcur AS rwcur,
  acdoca.rhcur AS rhcur,
  acdoca.rkcur AS rkcur,
  acdoca.rocur AS rocur,
  acdoca.rvcur AS rvcur,
  acdoca.rbcur AS rbcur,
  acdoca.rccur AS rccur,
  acdoca.rdcur AS rdcur,
  acdoca.recur AS recur,
  acdoca.rfcur AS rfcur,
  acdoca.rgcur AS rgcur,
  acdoca.drcrk AS drcrk,
  acdoca.wsl AS wsl,
  acdoca.hsl AS hsl,
  acdoca.ksl AS ksl,
  acdoca.osl AS osl,
  acdoca.vsl AS vsl,
  acdoca.bsl AS bsl,
  acdoca.csl AS csl,
  acdoca.dsl AS dsl,
  acdoca.esl AS esl,
  acdoca.fsl AS fsl,
  acdoca.gsl AS gsl,
  acdoca.usnam AS usnam,
  acdoca.timestamp AS timestamp,
  acdoca.cpudt AS cpudt,
  jvacd.cputm AS cputm
FROM JV_ACDOCA_BILLING AS acdoca
LEFT OUTER JOIN jvaonacdocaactiv AS act ON act.id = 'START'  -- association [0..1]
-- UNION with additional select branch(es): JV_ACDOCA_JVSO2
;