JV_JVTO2_ACDOCA

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_ACDOCA.
-- 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_ACD

CREATE VIEW JV_JVTO2_ACDOCA AS
SELECT
  rclnt,
  rldnr,
  rrcty,
  rvers,
  ryear,
  rtcur,
  rbukrs,
  rjvnam,
  regrou,
  rpartn,
  rbilid,
  rprojk,
  rdpom,
  rdbillm,
  rhcur,
  curt1_4b,
  curr1_4b,
  curt2_4b,
  curr2_4b,
  curt1_4d,
  curr1_4d,
  curt2_4d,
  curr2_4d,
  sum( tslvt ) AS tslvt,
  sum( tsl01 ) AS tsl01,
  sum( tsl02 ) AS tsl02,
  sum( tsl03 ) AS tsl03,
  sum( tsl04 ) AS tsl04,
  sum( tsl05 ) AS tsl05,
  sum( tsl06 ) AS tsl06,
  sum( tsl07 ) AS tsl07,
  sum( tsl08 ) AS tsl08,
  sum( tsl09 ) AS tsl09,
  sum( tsl10 ) AS tsl10,
  sum( tsl11 ) AS tsl11,
  sum( tsl12 ) AS tsl12,
  sum( tsl13 ) AS tsl13,
  sum( tsl14 ) AS tsl14,
  sum( tsl15 ) AS tsl15,
  sum( tsl16 ) AS tsl16,
  sum( hslvt ) AS hslvt,
  sum( hsl01 ) AS hsl01,
  sum( hsl02 ) AS hsl02,
  sum( hsl03 ) AS hsl03,
  sum( hsl04 ) AS hsl04,
  sum( hsl05 ) AS hsl05,
  sum( hsl06 ) AS hsl06,
  sum( hsl07 ) AS hsl07,
  sum( hsl08 ) AS hsl08,
  sum( hsl09 ) AS hsl09,
  sum( hsl10 ) AS hsl10,
  sum( hsl11 ) AS hsl11,
  sum( hsl12 ) AS hsl12,
  sum( hsl13 ) AS hsl13,
  sum( hsl14 ) AS hsl14,
  sum( hsl15 ) AS hsl15,
  sum( hsl16 ) AS hsl16,
  sum( kslvt ) AS kslvt,
  sum( ksl01 ) AS ksl01,
  sum( ksl02 ) AS ksl02,
  sum( ksl03 ) AS ksl03,
  sum( ksl04 ) AS ksl04,
  sum( ksl05 ) AS ksl05,
  sum( ksl06 ) AS ksl06,
  sum( ksl07 ) AS ksl07,
  sum( ksl08 ) AS ksl08,
  sum( ksl09 ) AS ksl09,
  sum( ksl10 ) AS ksl10,
  sum( ksl11 ) AS ksl11,
  sum( ksl12 ) AS ksl12,
  sum( ksl13 ) AS ksl13,
  sum( ksl14 ) AS ksl14,
  sum( ksl15 ) AS ksl15,
  sum( ksl16 ) AS ksl16,
  sum( hslvt_4d ) AS hslvt_4d,
  sum( hsl01_4d ) AS hsl01_4d,
  sum( hsl02_4d ) AS hsl02_4d,
  sum( hsl03_4d ) AS hsl03_4d,
  sum( hsl04_4d ) AS hsl04_4d,
  sum( hsl05_4d ) AS hsl05_4d,
  sum( hsl06_4d ) AS hsl06_4d,
  sum( hsl07_4d ) AS hsl07_4d,
  sum( hsl08_4d ) AS hsl08_4d,
  sum( hsl09_4d ) AS hsl09_4d,
  sum( hsl10_4d ) AS hsl10_4d,
  sum( hsl11_4d ) AS hsl11_4d,
  sum( hsl12_4d ) AS hsl12_4d,
  sum( hsl13_4d ) AS hsl13_4d,
  sum( hsl14_4d ) AS hsl14_4d,
  sum( hsl15_4d ) AS hsl15_4d,
  sum( hsl16_4d ) AS hsl16_4d,
  sum( kslvt_4d ) AS kslvt_4d,
  sum( ksl01_4d ) AS ksl01_4d,
  sum( ksl02_4d ) AS ksl02_4d,
  sum( ksl03_4d ) AS ksl03_4d,
  sum( ksl04_4d ) AS ksl04_4d,
  sum( ksl05_4d ) AS ksl05_4d,
  sum( ksl06_4d ) AS ksl06_4d,
  sum( ksl07_4d ) AS ksl07_4d,
  sum( ksl08_4d ) AS ksl08_4d,
  sum( ksl09_4d ) AS ksl09_4d,
  sum( ksl10_4d ) AS ksl10_4d,
  sum( ksl11_4d ) AS ksl11_4d,
  sum( ksl12_4d ) AS ksl12_4d,
  sum( ksl13_4d ) AS ksl13_4d,
  sum( ksl14_4d ) AS ksl14_4d,
  sum( ksl15_4d ) AS ksl15_4d,
  sum( ksl16_4d ) AS ksl16_4d
FROM JV_JVTO2_ACDOCA_INT
;