JV_JVSO1_ACDOCA_4A_4C_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_4A_4C_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_ACD4A4CSW

CREATE VIEW JV_JVSO1_ACDOCA_4A_4C_SWITCH AS
SELECT
  jvacd.rclnt AS rclnt,
  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.tsl AS tsl,
  jvacd.hsl AS hsl,
  jvacd.ksl AS ksl,
  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_4A_4C AS jvacd
LEFT OUTER JOIN jvaonacdocaactiv AS act ON act.id = 'START'  -- association [0..1]
-- UNION with additional select branch(es): jvso1
;