JV_JVSO2_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_JVSO2_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: CJVSO2_ACD_SW

CREATE VIEW JV_JVSO2_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.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.rpartn AS rpartn,
  jvacd.rbilid AS rbilid,
  jvacd.rprojk AS rprojk,
  jvacd.rdpom AS rdpom,
  jvacd.rdbillm AS rdbillm,
  jvacd.curt1_4b AS curt1_4b,
  jvacd.curr1_4b AS curr1_4b,
  jvacd.curt2_4b AS curt2_4b,
  jvacd.curr2_4b AS curr2_4b,
  jvacd.curt1_4d AS curt1_4d,
  jvacd.curr1_4d AS curr1_4d,
  jvacd.curt2_4d AS curt2_4d,
  jvacd.curr2_4d AS curr2_4d,
  jvacd.tsl AS tsl,
  jvacd.hsl AS hsl,
  jvacd.ksl AS ksl,
  jvacd.hsl_4d AS hsl_4d,
  jvacd.ksl_4d AS ksl_4d,
  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.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.billm AS billm,
  jvacd.pom AS pom,
  jvacd.awtyp AS awtyp,
  jvacd.aworg AS aworg,
  jvacd.logsys AS logsys,
  jvacd.refawtyp AS refawtyp,
  jvacd.refawref AS refawref,
  jvacd.refaworg AS refaworg,
  jvso2.reflogsys AS reflogsys
FROM JV_JVSO2_ACDOCA AS jvacd
LEFT OUTER JOIN jvaonacdocaactiv AS act ON act.id = 'START'  -- association [0..1]
-- UNION with additional select branch(es): JV_JVSO2_COMB
;