JV_JVTO1_ACDOCA_CFW_PREP

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_ACDOCA_CFW_PREP.
-- 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.
-- Parameters: fiscal_year : gjahr

CREATE VIEW JV_JVTO1_ACDOCA_CFW_PREP AS
SELECT
  rldnr,
  rrcty,
  rvers,
  :fiscal_year AS ryear,
  cast( '000000000000000000' as gobjnr_r ) AS robjnr,
  cast( '000000000000000000' as gobjnr_c ) AS cobjnr,
  cast( '000000000000000000' as gobjnr_s ) AS sobjnr,
  rtcur,
  runit,
  cast( ' ' as shkzg preserving type ) AS drcrk,
  cast( '016' as rpmax preserving type ) AS rpmax,
  rbukrs,
  rjvnam,
  regrou,
  racct,
  rbusa,
  rcntr,
  rordnr,
  rprojk,
  rprctr,
  ranln1,
  ranln2,
  ranbwa,
  rrecin,
  rpartn,
  rkokrs,
  nplnr,
  vornr,
  aufpl,
  aplzl,
  curt1_4a,
  curr1_4a,
  curt2_4a,
  curr2_4a,
  curt1_4c,
  curr1_4c,
  curt2_4c,
  curr2_4c,
  sum( tsl ) AS tslvt,
  sum( hsl ) AS hslvt,
  sum( ksl ) AS kslvt,
  sum( hsl_4c ) AS hslvt_4c,
  sum( ksl_4c ) AS kslvt_4c,
  cast( 0 as mslvt ) AS mslvt
FROM JV_JVSO1_ACDOCA
INNER JOIN t881 ON /* join condition not captured in parsed metadata */
INNER JOIN t882 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN jvaonacdocaactiv AS act ON act.id = 'START'  -- association [0..1]
-- UNION with additional select branch(es): jvto1
;