JV_JVTO1_T8JTPM_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_JVTO1_T8JTPM_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: CJVTO1_TPM_COMB

CREATE VIEW JV_JVTO1_T8JTPM_COMB AS
SELECT
  jvto1_4a.rclnt AS rclnt,
  jvto1_4a.rrcty AS rrcty,
  jvto1_4a.rvers AS rvers,
  jvto1_4a.ryear AS ryear,
  jvto1_4a.robjnr AS robjnr,
  jvto1_4a.cobjnr AS cobjnr,
  jvto1_4a.sobjnr AS sobjnr,
  jvto1_4a.rtcur AS rtcur,
  jvto1_4a.runit AS runit,
  jvto1_4a.drcrk AS drcrk,
  jvto1_4a.rpmax AS rpmax,
  jvto1_4a.rbukrs AS rbukrs,
  jvto1_4a.rldnr AS rldnr,
  jvto1_4a.racct AS racct,
  jvto1_4a.rbusa AS rbusa,
  jvto1_4a.rkokrs AS rkokrs,
  jvto1_4a.rjvnam AS rjvnam,
  jvto1_4a.regrou AS regrou,
  jvto1_4a.rrecin AS rrecin,
  jvto1_4a.rpartn AS rpartn,
  jvto1_4a.rprctr AS rprctr,
  jvto1_4a.rcntr AS rcntr,
  jvto1_4a.rordnr AS rordnr,
  jvto1_4a.rprojk AS rprojk,
  jvto1_4a.nplnr AS nplnr,
  jvto1_4a.vornr AS vornr,
  jvto1_4a.aufpl AS aufpl,
  jvto1_4a.aplzl AS aplzl,
  jvto1_4a.ranln1 AS ranln1,
  jvto1_4a.ranln2 AS ranln2,
  jvto1_4a.ranbwa AS ranbwa,
  t881_4a.curt1 AS curt1_4a,
  t882_4a.curr1 AS curr1_4a,
  t881_4a.curt2 AS curt2_4a,
  t882_4a.curr2 AS curr2_4a,
  coalesce( t882_4c.curr1, cast( '' as waers ) ) AS curr1_4c,
  coalesce( t882_4c.curr2, cast( '' as waers ) ) AS curr2_4c
FROM jvto1 AS jvto1_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 jvto1 AS jvto1_4c ON jvto1_4c.rldnr = '4C' AND jvto1_4c.rrcty = jvto1_4a.rrcty AND jvto1_4c.rvers = jvto1_4a.rvers AND jvto1_4c.ryear = jvto1_4a.ryear AND jvto1_4c.robjnr = jvto1_4a.robjnr AND jvto1_4c.cobjnr = jvto1_4a.cobjnr AND jvto1_4c.sobjnr = jvto1_4a.sobjnr AND jvto1_4c.rtcur = jvto1_4a.rtcur AND jvto1_4c.runit = jvto1_4a.runit AND jvto1_4c.drcrk = jvto1_4a.drcrk AND jvto1_4c.rpmax = jvto1_4a.rpmax AND jvto1_4c.rbukrs = jvto1_4a.rbukrs  -- association [0..1]
;