LXE_WRK_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 LXE_WRK_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: LXE_V_WRK_SUM

CREATE VIEW LXE_WRK_SUM AS
SELECT
  lxe_wrkobd.targ_lang AS targ_lang,
  lxe_wrkobd.custmnr AS custmnr,
  lxe_wrkobd.objtype AS objtype,
  lxe_wrkobd.domatyp AS domatyp,
  lxe_wrkobd.domanam AS domanam,
  lxe_wrkobd.colltyp AS colltyp,
  lxe_wrkobd.collnam AS collnam,
  lxe_wrkobd.sour_lang AS sour_lang,
  lxe_wrkobd.wlistid AS wlistid,
  sum(lxe_wrkobd.cnttot) AS cnttot,
  sum(lxe_wrkobd.cntnew) AS cntnew,
  sum(lxe_wrkobd.cntmod) AS cntmod,
  sum(lxe_wrkobd.cntavl) AS cntavl,
  sum(lxe_wrkobd.wcnttot) AS wcnttot,
  sum(lxe_wrkobd.wcntnew) AS wcntnew,
  sum(lxe_wrkobd.wcntmod) AS wcntmod,
  sum(lxe_wrkobz.wcntavl) AS wcntavl
FROM lxe_wrkobd
-- UNION with additional select branch(es): lxe_wrkobo, lxe_wrkobs, lxe_wrkobx, lxe_wrkoby, lxe_wrkobz
;