JV_JVSO1_ACDOCA_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_JVSO1_ACDOCA_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: CJVSO1_ACD_SW

CREATE VIEW JV_JVSO1_ACDOCA_SWITCH AS
SELECT
  jvacd.gl_sirid AS gl_sirid,
  jvacd.rldnr AS rldnr,
  jvacd.rrcty AS rrcty,
  jvacd.rvers AS rvers,
  jvacd.ryear AS ryear,
  jvacd.rtcur AS rtcur,
  jvacd.runit AS runit,
  jvacd.drcrk AS drcrk,
  jvacd.poper AS poper,
  jvacd.docct AS docct,
  jvacd.docnr AS docnr,
  jvacd.docln_acd AS docln_acd,
  jvacd.rbukrs AS rbukrs,
  jvacd.docln AS docln,
  jvacd.rjvnam AS rjvnam,
  jvacd.regrou AS regrou,
  jvacd.racct AS racct,
  jvacd.rbusa AS rbusa,
  jvacd.rkokrs AS rkokrs,
  jvacd.rcntr AS rcntr,
  jvacd.rordnr AS rordnr,
  jvacd.rprojk AS rprojk,
  jvacd.rprctr AS rprctr,
  jvacd.ranln1 AS ranln1,
  jvacd.ranln2 AS ranln2,
  jvacd.ranbwa AS ranbwa,
  jvacd.rrecin AS rrecin,
  jvacd.rpartn AS rpartn,
  jvacd.rdpom AS rdpom,
  jvacd.rdbillm AS rdbillm,
  jvacd.nplnr AS nplnr,
  jvacd.aufpl AS aufpl,
  jvacd.aplzl AS aplzl,
  jvacd.vornr AS vornr,
  jvacd.rhcur AS rhcur,
  jvacd.rkcur AS rkcur,
  jvacd.curt1_4a AS curt1_4a,
  jvacd.curr1_4a AS curr1_4a,
  jvacd.curt2_4a AS curt2_4a,
  jvacd.curr2_4a AS curr2_4a,
  jvacd.curt1_4c AS curt1_4c,
  jvacd.curr1_4c AS curr1_4c,
  jvacd.curt2_4c AS curt2_4c,
  jvacd.curr2_4c AS curr2_4c,
  jvacd.tsl AS tsl,
  jvacd.hsl AS hsl,
  jvacd.ksl AS ksl,
  jvacd.hsl_4c AS hsl_4c,
  jvacd.ksl_4c AS ksl_4c,
  jvacd.msl AS msl,
  jvacd.aunit AS aunit,
  jvacd.sgtxt AS sgtxt,
  jvacd.autom AS autom,
  jvacd.docty AS docty,
  jvacd.activ AS activ,
  jvacd.budat AS budat,
  jvacd.wsdat AS wsdat,
  jvacd.valut AS valut,
  jvacd.refdocnr AS refdocnr,
  jvacd.refryear AS refryear,
  jvacd.refdocln AS refdocln,
  jvacd.refdocct AS refdocct,
  jvacd.refactiv AS refactiv,
  jvacd.reffidln AS reffidln,
  jvacd.cpudt AS cpudt,
  jvacd.cputm AS cputm,
  jvacd.usnam AS usnam,
  jvacd.bldat AS bldat,
  jvacd.bilid AS bilid,
  jvacd.orecid AS orecid,
  jvacd.mwskz AS mwskz,
  jvacd.billm AS billm,
  jvacd.pom AS pom,
  jvacd.cbperiod AS cbperiod,
  jvacd.ebeln AS ebeln,
  jvacd.ebelp AS ebelp,
  jvacd.ktosl AS ktosl,
  jvacd.mmact AS mmact,
  jvacd.lstar AS lstar,
  jvacd.cycle AS cycle,
  jvacd.sdate AS sdate,
  jvacd.seqnr AS seqnr,
  jvacd.seqname AS seqname,
  jvacd.refcyc AS refcyc,
  jvacd.matnr AS matnr,
  jvacd.condi AS condi,
  jvacd.awtyp AS awtyp,
  jvacd.aworg AS aworg,
  jvacd.logsys AS logsys,
  jvacd.refawtyp AS refawtyp,
  jvacd.refawref AS refawref,
  jvacd.refaworg AS refaworg,
  jvacd.reflogsys AS reflogsys,
  jvacd.prodper AS prodper,
  jvacd.reffidoc AS reffidoc,
  jvacd.cbcustomer AS cbcustomer,
  jvacd.cbvendor AS cbvendor,
  jvacd.cbpayterm AS cbpayterm,
  jvacd.xsbl AS xsbl,
  jvso1.sbrefln AS sbrefln
FROM JV_JVSO1_ACDOCA AS jvacd
LEFT OUTER JOIN jvaonacdocaactiv AS act ON act.id = 'START'  -- association [0..1]
-- UNION with additional select branch(es): JV_JVSO1_COMB
;