view_ccsv_sum

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 view_ccsv_sum.
-- 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: CDS_CCSV_SUM

CREATE VIEW view_ccsv_sum AS
SELECT
  settl_doc.mandt AS mandt,
  settl_doc.coco_num AS coco_num,
  settl_doc.settl_post_party AS post_party,
  settl_doc.waerl AS waerl,
  settl_doc.settl_lfart AS settl_lfart,
  settl_doc.settl_bukrs AS settl_bukrs,
  settl_doc.settl_ekorg AS settl_ekorg,
  settl_doc.settl_ekgrp AS settl_ekgrp,
  settl_doc.settl_vkorg AS settl_vkorg,
  settl_doc.settl_vtweg AS settl_vtweg,
  settl_doc.settl_spart AS settl_spart,
  coco_head.vend_owner AS vend_owner,
  coco_head.cust_owner AS cust_owner,
  coco_head.contract_type AS coco_type,
  coco_head.vkorg AS coco_vkorg,
  coco_head.vtweg AS coco_vtweg,
  coco_head.spart AS coco_spart,
  coco_head.ekorg AS coco_ekorg,
  coco_head.ekgrp AS coco_ekgrp,
  sum( settl_doc.netwr ) AS netwr,
  sum( settl_doc.netwrd ) AS netwrd,
  sum( settl_doc.brtwr ) AS brtwr,
  sum( settl_doc.brtwrd ) AS brtwrd,
  sum( settl_doc.skfbp ) AS skfbp,
  sum( settl_doc.skfbpd) AS skfbpd,
  sum( settl_doc.effwr ) AS effwr,
  sum( settl_doc.effwrd ) AS effwrd,
  sum( settl_doc.mwsbp ) AS mwsbp,
  sum( settl_doc.mwsbpd ) AS mwsbpd
FROM view_ccs_settl AS settl_doc
LEFT OUTER JOIN wcocoh AS coco_head ON coco_num = coco_head.num  -- association [1..1]
LEFT OUTER JOIN wb2_c_ccs AS cust_ccs ON mandt = cust_ccs.mandt  -- association [0..1]
;