FACVD_GLCASHMC_WLI_02

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 FACVD_GLCASHMC_WLI_02.
-- 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: to_budat : abap.dats

CREATE VIEW FACVD_GLCASHMC_WLI_02 AS
SELECT
  a.bukrs AS bukrs,
  hkont,
  h_hwaer,
  a.hbkid AS hbkid,
  a.hktid AS hktid,
  skat.txt50 AS txt50,
  sum(items_count) AS items_count,
  sum(debit) AS debit,
  sum(credit) AS credit,
  sum(credit_xnegp) AS credit_xnegp,
  sum(debit_xnegp) AS debit_xnegp,
  coalesce(t030.ktosl,'') AS ktosl,
  begru,
  a.altkt AS altkt,
  alttxt.txt50 AS altkt_txt50,
  a.ktopl AS ktopl,
  a.butxt AS butxt,
  a.AuthorizationGroup AS AuthorizationGroup
FROM FACVD_GLCASHMC_WLI_03
LEFT OUTER JOIN t030 ON /* join condition not captured in parsed metadata */
;