JV_JVTO2_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_JVTO2_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: CJVTO2

CREATE VIEW JV_JVTO2_COMB AS
SELECT
  jvto2_4b.rclnt AS rclnt,
  cast( '4B' as rldnr preserving type ) AS rldnr,
  jvto2_4b.rbukrs AS rbukrs,
  jvto2_4b.ryear AS ryear,
  jvto2_4b.rrcty AS rrcty,
  jvto2_4b.rvers AS rvers,
  jvto2_4b.rtcur AS rtcur,
  jvto2_4b.drcrk AS drcrk,
  jvto2_4b.rjvnam AS rjvnam,
  jvto2_4b.regrou AS regrou,
  jvto2_4b.rpartn AS rpartn,
  jvto2_4b.rbilid AS rbilid,
  jvto2_4b.rprojk AS rprojk,
  jvto2_4b.rdpom AS rdpom,
  jvto2_4b.rdbillm AS rdbillm,
  jvto2_4b.tslvt AS tslvt,
  jvto2_4b.tsl01 AS tsl01,
  jvto2_4b.tsl02 AS tsl02,
  jvto2_4b.tsl03 AS tsl03,
  jvto2_4b.tsl04 AS tsl04,
  jvto2_4b.tsl05 AS tsl05,
  jvto2_4b.tsl06 AS tsl06,
  jvto2_4b.tsl07 AS tsl07,
  jvto2_4b.tsl08 AS tsl08,
  jvto2_4b.tsl09 AS tsl09,
  jvto2_4b.tsl10 AS tsl10,
  jvto2_4b.tsl11 AS tsl11,
  jvto2_4b.tsl12 AS tsl12,
  jvto2_4b.tsl13 AS tsl13,
  jvto2_4b.tsl14 AS tsl14,
  jvto2_4b.tsl15 AS tsl15,
  jvto2_4b.tsl16 AS tsl16,
  t882_4b.curt1 AS curt1_4b,
  t882_4b.curr1 AS curr1_4b,
  jvto2_4b.hslvt AS hslvt,
  jvto2_4b.hsl01 AS hsl01,
  jvto2_4b.hsl02 AS hsl02,
  jvto2_4b.hsl03 AS hsl03,
  jvto2_4b.hsl04 AS hsl04,
  jvto2_4b.hsl05 AS hsl05,
  jvto2_4b.hsl06 AS hsl06,
  jvto2_4b.hsl07 AS hsl07,
  jvto2_4b.hsl08 AS hsl08,
  jvto2_4b.hsl09 AS hsl09,
  jvto2_4b.hsl10 AS hsl10,
  jvto2_4b.hsl11 AS hsl11,
  jvto2_4b.hsl12 AS hsl12,
  jvto2_4b.hsl13 AS hsl13,
  jvto2_4b.hsl14 AS hsl14,
  jvto2_4b.hsl15 AS hsl15,
  jvto2_4b.hsl16 AS hsl16,
  t881_4b.curt2 AS curt2_4b,
  t882_4b.curr2 AS curr2_4b,
  jvto2_4b.kslvt AS kslvt,
  jvto2_4b.ksl01 AS ksl01,
  jvto2_4b.ksl02 AS ksl02,
  jvto2_4b.ksl03 AS ksl03,
  jvto2_4b.ksl04 AS ksl04,
  jvto2_4b.ksl05 AS ksl05,
  jvto2_4b.ksl06 AS ksl06,
  jvto2_4b.ksl07 AS ksl07,
  jvto2_4b.ksl08 AS ksl08,
  jvto2_4b.ksl09 AS ksl09,
  jvto2_4b.ksl10 AS ksl10,
  jvto2_4b.ksl11 AS ksl11,
  jvto2_4b.ksl12 AS ksl12,
  jvto2_4b.ksl13 AS ksl13,
  jvto2_4b.ksl14 AS ksl14,
  jvto2_4b.ksl15 AS ksl15,
  jvto2_4b.ksl16 AS ksl16,
  coalesce( t881_4d.curt1, cast( ' ' as curtp preserving type ) ) AS curt1_4d,
  coalesce( t882_4d.curr1, cast( '' as waers ) ) AS curr1_4d,
  coalesce( jvto2_4d.hslvt, cast( 0 as wertv9 ) ) AS hslvt_4d,
  coalesce( jvto2_4d.hsl01, cast( 0 as wertv9 ) ) AS hsl01_4d,
  coalesce( jvto2_4d.hsl02, cast( 0 as wertv9 ) ) AS hsl02_4d,
  coalesce( jvto2_4d.hsl03, cast( 0 as wertv9 ) ) AS hsl03_4d,
  coalesce( jvto2_4d.hsl04, cast( 0 as wertv9 ) ) AS hsl04_4d,
  coalesce( jvto2_4d.hsl05, cast( 0 as wertv9 ) ) AS hsl05_4d,
  coalesce( jvto2_4d.hsl06, cast( 0 as wertv9 ) ) AS hsl06_4d,
  coalesce( jvto2_4d.hsl07, cast( 0 as wertv9 ) ) AS hsl07_4d,
  coalesce( jvto2_4d.hsl08, cast( 0 as wertv9 ) ) AS hsl08_4d,
  coalesce( jvto2_4d.hsl09, cast( 0 as wertv9 ) ) AS hsl09_4d,
  coalesce( jvto2_4d.hsl10, cast( 0 as wertv9 ) ) AS hsl10_4d,
  coalesce( jvto2_4d.hsl11, cast( 0 as wertv9 ) ) AS hsl11_4d,
  coalesce( jvto2_4d.hsl12, cast( 0 as wertv9 ) ) AS hsl12_4d,
  coalesce( jvto2_4d.hsl13, cast( 0 as wertv9 ) ) AS hsl13_4d,
  coalesce( jvto2_4d.hsl14, cast( 0 as wertv9 ) ) AS hsl14_4d,
  coalesce( jvto2_4d.hsl15, cast( 0 as wertv9 ) ) AS hsl15_4d,
  coalesce( jvto2_4d.hsl16, cast( 0 as wertv9 ) ) AS hsl16_4d,
  coalesce( t881_4d.curt2, cast( ' ' as curtp preserving type ) ) AS curt2_4d,
  coalesce( t882_4d.curr2, cast( '' as waers ) ) AS curr2_4d,
  coalesce( jvto2_4d.kslvt, cast( 0 as wertv9 ) ) AS kslvt_4d,
  coalesce( jvto2_4d.ksl01, cast( 0 as wertv9 ) ) AS ksl01_4d,
  coalesce( jvto2_4d.ksl02, cast( 0 as wertv9 ) ) AS ksl02_4d,
  coalesce( jvto2_4d.ksl03, cast( 0 as wertv9 ) ) AS ksl03_4d,
  coalesce( jvto2_4d.ksl04, cast( 0 as wertv9 ) ) AS ksl04_4d,
  coalesce( jvto2_4d.ksl05, cast( 0 as wertv9 ) ) AS ksl05_4d,
  coalesce( jvto2_4d.ksl06, cast( 0 as wertv9 ) ) AS ksl06_4d,
  coalesce( jvto2_4d.ksl07, cast( 0 as wertv9 ) ) AS ksl07_4d,
  coalesce( jvto2_4d.ksl08, cast( 0 as wertv9 ) ) AS ksl08_4d,
  coalesce( jvto2_4d.ksl09, cast( 0 as wertv9 ) ) AS ksl09_4d,
  coalesce( jvto2_4d.ksl10, cast( 0 as wertv9 ) ) AS ksl10_4d,
  coalesce( jvto2_4d.ksl11, cast( 0 as wertv9 ) ) AS ksl11_4d,
  coalesce( jvto2_4d.ksl12, cast( 0 as wertv9 ) ) AS ksl12_4d,
  coalesce( jvto2_4d.ksl13, cast( 0 as wertv9 ) ) AS ksl13_4d,
  coalesce( jvto2_4d.ksl14, cast( 0 as wertv9 ) ) AS ksl14_4d,
  coalesce( jvto2_4d.ksl15, cast( 0 as wertv9 ) ) AS ksl15_4d,
  coalesce( jvto2_4d.ksl16, cast( 0 as wertv9 ) ) AS ksl16_4d
FROM jvto2 AS jvto2_4b
INNER JOIN t881 AS t881_4b ON /* join condition not captured in parsed metadata */
INNER JOIN t882 AS t882_4b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN jvto2 AS jvto2_4d ON jvto2_4d.rldnr = '4D' AND jvto2_4d.rrcty = jvto2_4b.rrcty AND jvto2_4d.rvers = jvto2_4b.rvers AND jvto2_4d.ryear = jvto2_4b.ryear AND jvto2_4d.robjnr = jvto2_4b.robjnr AND jvto2_4d.sobjnr = jvto2_4b.sobjnr AND jvto2_4d.rtcur = jvto2_4b.rtcur AND jvto2_4d.drcrk = jvto2_4b.drcrk AND jvto2_4d.rpmax = jvto2_4b.rpmax AND jvto2_4d.rbukrs = jvto2_4b.rbukrs  -- association [0..1]
;