JV_ACDOCA_JVSO1_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_JVSO1_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_JVSO1_SW

CREATE VIEW JV_ACDOCA_JVSO1_SWITCH AS
SELECT
  acdoca.rldnr AS rldnr,
  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.prec_awref AS prec_awref,
  acdoca.prec_aworg AS prec_aworg,
  acdoca.prec_awitem AS prec_awitem,
  acdoca.prec_awtyp AS prec_awtyp,
  acdoca.prec_awsys AS prec_awsys,
  acdoca.src_awref AS src_awref,
  acdoca.src_aworg AS src_aworg,
  acdoca.src_awitem AS src_awitem,
  acdoca.src_awtyp AS src_awtyp,
  acdoca.src_awsys AS src_awsys,
  acdoca.ryear AS ryear,
  acdoca.poper AS poper,
  acdoca.budat AS budat,
  acdoca.bldat AS bldat,
  acdoca.valut AS valut,
  acdoca.vorgn AS vorgn,
  acdoca.blart AS blart,
  acdoca.racct AS racct,
  acdoca.kokrs AS kokrs,
  acdoca.rbusa AS rbusa,
  acdoca.prctr AS prctr,
  acdoca.segment AS segment,
  acdoca.rfarea AS rfarea,
  acdoca.vname AS vname,
  acdoca.egrup AS egrup,
  acdoca.recid AS recid,
  acdoca.btype AS btype,
  acdoca.vptnr AS vptnr,
  acdoca.etype AS etype,
  acdoca.prodper AS prodper,
  acdoca.billm AS billm,
  acdoca.pom AS pom,
  acdoca.jvactivity AS jvactivity,
  acdoca.cbrunid AS cbrunid,
  acdoca.objnr AS objnr,
  acdoca.rcntr AS rcntr,
  acdoca.aufnr AS aufnr,
  acdoca.ps_psp_pnr AS ps_psp_pnr,
  acdoca.nplnr AS nplnr,
  acdoca.nplnr_vorgn AS nplnr_vorgn,
  acdoca.vornr AS vornr,
  acdoca.anln1 AS anln1,
  acdoca.anln2 AS anln2,
  acdoca.anbwa AS anbwa,
  acdoca.mat_pspnr AS mat_pspnr,
  acdoca.matnr AS matnr,
  acdoca.lstar AS lstar,
  acdoca.ebeln AS ebeln,
  acdoca.ebelp AS ebelp,
  acdoca.mwskz AS mwskz,
  acdoca.ktosl AS ktosl,
  acdoca.sgtxt AS sgtxt,
  acdoca.kunnr AS kunnr,
  acdoca.lifnr AS lifnr,
  acdoca.xreversed AS xreversed,
  acdoca.xreversing AS xreversing,
  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.msl AS msl,
  acdoca.runit AS runit,
  acdoca.usnam AS usnam,
  acdoca.timestamp AS timestamp,
  jvacd.jv_docnr AS jv_docnr
FROM acdoca
LEFT OUTER JOIN jvaonacdocaactiv AS act ON act.id = 'START'  -- association [0..1]
-- UNION with additional select branch(es): JV_ACDOCA_JVSO1
;