FCO_ABR_SETLDOCTOTAL

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 FCO_ABR_SETLDOCTOTAL.
-- 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.

CREATE VIEW FCO_ABR_SETLDOCTOTAL AS
SELECT
  auak.lednr AS lednr,
  auak.objnr AS objnr,
  substring(auas.key01,3,22) AS cobjnr,
  auak.gjahr AS gjahr,
  auak.wrttp AS wrttp,
  auak.versn AS versn,
  auak.kokrs AS Kokrs,
  auak.perbz AS perbz,
  auas.datei AS Datei,
  auas.key01 AS Key01,
  auas.twaer AS Twaer,
  I_ControllingArea.ControllingAreaCurrency AS ControllingAreaCurrency,
  auas.meinh AS Meinh,
  substring(auas.key01,1,2) AS clednr,
  substring(auas.key01,25,4) AS cgjahr,
  cast(substring(auas.key01,29,2) as co_wrttp) AS cwrttp,
  substring(auas.key01,31,3) AS cversn,
  substring(auas.key01,34,10) AS ckstar,
  sum(auas.wtgbtr) AS Wtgbtr,
  sum(auas.wkgbtr) AS Wkgbtr,
  sum(auas.wkfbtr) AS Wkfbtr,
  sum(auas.wogbtr) AS Wogbtr,
  sum(auas.pagbtr) AS Pagbtr,
  sum(auas.pafbtr) AS Pafbtr,
  sum(auas.megbtr) AS Megbtr,
  sum(auas.mefbtr) AS Mefbtr,
  sum(auas.wagbtr) AS Wagbtr,
  sum(auas.wvgbtr) AS Wvgbtr,
  sum(auas.wbgbtr) AS Wbgbtr,
  sum(auas.wcgbtr) AS Wcgbtr,
  sum(auas.wdgbtr) AS Wdgbtr,
  sum(auas.wegbtr) AS Wegbtr,
  sum(auas.wfgbtr) AS Wfgbtr,
  sum(auas.wggbtr) AS Wggbtr,
  sum(auas.whgbtr) AS Whgbtr,
  sum(auas.wsgbtr) AS Wsgbtr
FROM auak
;