JV_JVSO1_COMB

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_COMB.
-- 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

CREATE VIEW JV_JVSO1_COMB AS
SELECT
  jvso1_4a.rclnt AS rclnt,
  jvso1_4a.gl_sirid AS gl_sirid,
  cast( '4A' as rldnr preserving type ) AS rldnr,
  jvso1_4a.rbukrs AS rbukrs,
  jvso1_4a.ryear AS ryear,
  jvso1_4a.docnr AS docnr,
  jvso1_4a.docln AS docln,
  jvso1_4a.rrcty AS rrcty,
  jvso1_4a.rvers AS rvers,
  jvso1_4a.rtcur AS rtcur,
  jvso1_4a.runit AS runit,
  jvso1_4a.drcrk AS drcrk,
  jvso1_4a.poper AS poper,
  jvso1_4a.docct AS docct,
  jvso1_4a.rjvnam AS rjvnam,
  jvso1_4a.regrou AS regrou,
  jvso1_4a.rpartn AS rpartn,
  jvso1_4a.rrecin AS rrecin,
  jvso1_4a.orecid AS orecid,
  jvso1_4a.bilid AS bilid,
  jvso1_4a.billm AS billm,
  jvso1_4a.pom AS pom,
  jvso1_4a.rdpom AS rdpom,
  jvso1_4a.rdbillm AS rdbillm,
  jvso1_4a.docty AS docty,
  jvso1_4a.activ AS activ,
  jvso1_4a.budat AS budat,
  jvso1_4a.bldat AS bldat,
  jvso1_4a.prodper AS prodper,
  jvso1_4a.wsdat AS wsdat,
  jvso1_4a.valut AS valut,
  jvso1_4a.sgtxt AS sgtxt,
  jvso1_4a.autom AS autom,
  jvso1_4a.racct AS racct,
  jvso1_4a.rbusa AS rbusa,
  jvso1_4a.rkokrs AS rkokrs,
  jvso1_4a.rprctr AS rprctr,
  jvso1_4a.rcntr AS rcntr,
  jvso1_4a.rordnr AS rordnr,
  jvso1_4a.rprojk AS rprojk,
  jvso1_4a.nplnr AS nplnr,
  jvso1_4a.aufpl AS aufpl,
  jvso1_4a.aplzl AS aplzl,
  jvso1_4a.vornr AS vornr,
  jvso1_4a.ranln1 AS ranln1,
  jvso1_4a.ranln2 AS ranln2,
  jvso1_4a.ranbwa AS ranbwa,
  jvso1_4a.msl AS msl,
  jvso1_4a.aunit AS aunit,
  jvso1_4a.refdocnr AS refdocnr,
  jvso1_4a.refryear AS refryear,
  jvso1_4a.refdocln AS refdocln,
  jvso1_4a.refdocct AS refdocct,
  jvso1_4a.refactiv AS refactiv,
  jvso1_4a.reffidoc AS reffidoc,
  jvso1_4a.reffidln AS reffidln,
  jvso1_4a.cpudt AS cpudt,
  jvso1_4a.cputm AS cputm,
  jvso1_4a.usnam AS usnam,
  jvso1_4a.mwskz AS mwskz,
  jvso1_4a.cbperiod AS cbperiod,
  jvso1_4a.ebeln AS ebeln,
  jvso1_4a.ebelp AS ebelp,
  jvso1_4a.ktosl AS ktosl,
  jvso1_4a.mmact AS mmact,
  jvso1_4a.lstar AS lstar,
  jvso1_4a.cycle AS cycle,
  jvso1_4a.sdate AS sdate,
  jvso1_4a.seqnr AS seqnr,
  jvso1_4a.seqname AS seqname,
  jvso1_4a.refcyc AS refcyc,
  jvso1_4a.matnr AS matnr,
  jvso1_4a.condi AS condi,
  jvso1_4a.awtyp AS awtyp,
  jvso1_4a.aworg AS aworg,
  jvso1_4a.logsys AS logsys,
  jvso1_4a.refawtyp AS refawtyp,
  jvso1_4a.refawref AS refawref,
  jvso1_4a.refaworg AS refaworg,
  jvso1_4a.reflogsys AS reflogsys,
  jvso1_4a.cbcustomer AS cbcustomer,
  jvso1_4a.cbvendor AS cbvendor,
  jvso1_4a.cbpayterm AS cbpayterm,
  jvso1_4a.xsbl AS xsbl,
  jvso1_4a.sbrefln AS sbrefln,
  jvso1_4a.rtcur AS rwcur,
  jvso1_4a.tsl AS tsl,
  jvso1_4a.tsl AS wsl,
  t881_4a.curt1 AS curt1_4a,
  t882_4a.curr1 AS curr1_4a,
  t882_4a.curr1 AS hwaer,
  t882_4a.curr1 AS rhcur,
  jvso1_4a.hsl AS hsl,
  jvso1_4a.hsl AS hsl_4a,
  t881_4a.curt2 AS curt2_4a,
  t882_4a.curr2 AS curr2_4a,
  t882_4a.curr2 AS hwae2,
  jvso1_4a.ksl AS ksl,
  jvso1_4a.ksl AS ksl_4a,
  coalesce( t882_4c.curr1, cast( '' as waers ) ) AS curr1_4c,
  coalesce( t882_4c.curr1, cast( '' as waers ) ) AS hwae3,
  coalesce( t882_4c.curr2, cast( '' as waers ) ) AS curr2_4c,
  coalesce( t882_4c.curr2, cast( '' as waers ) ) AS hwae4
FROM jvso1 AS jvso1_4a
INNER JOIN t881 AS t881_4a ON /* join condition not captured in parsed metadata */
INNER JOIN t882 AS t882_4a ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN jvso1 AS jvso1_4c ON jvso1_4c.rldnr = '4C' AND jvso1_4c.ryear = jvso1_4a.ryear AND jvso1_4c.rbukrs = jvso1_4a.rbukrs AND jvso1_4c.docnr = jvso1_4a.docnr AND jvso1_4c.docln = jvso1_4a.docln  -- association [0..1]
;