FACVD_GLMC_WLI_03

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_GLMC_WLI_03.
-- 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: FACV_GLMC_WLI_03
-- Parameters: to_budat : abap.dats

CREATE VIEW FACVD_GLMC_WLI_03 AS
SELECT
  skb1.bukrs AS bukrs,
  bseg.hkont AS hkont,
  bseg.h_hwaer AS h_hwaer,
  t001.ktopl AS ktopl,
  t001.butxt AS butxt,
  t001.ktop2 AS ktop2,
  count (*) AS items_count,
  bseg.h_blart AS h_blart,
  skb1.begru AS begru,
  skb1.altkt AS altkt
FROM skb1
LEFT OUTER JOIN bseg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN bkpf ON /* join condition not captured in parsed metadata */
;