ACE_ACEDSOI_CMPATBL

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 ACE_ACEDSOI_CMPATBL.
-- 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: ACEV_ACEDSOI

CREATE VIEW ACE_ACEDSOI_CMPATBL AS
SELECT
  _item.comp AS comp,
  _item.bukrs AS bukrs,
  _sobj.objid AS objid,
  _sobj.subid AS subid,
  tace_itemtypel.acrtype AS acrtype,
  case when tace_combination.accrule <> '' then tace_combination.accrule else finsc_ledger.acc_principle end AS accrule,
  max( _item.date_to ) AS date_to,
  min( _item.date_from ) AS date_from,
  _item.timestmp AS timestmp,
  _item.total_accr_amnt_wsl AS amount,
  _item.rwcurttl AS currency,
  _item.quantity AS quantity,
  _item.unit AS unit,
  _item.acrmethod AS acrmethod,
  _item.xobsolete AS itemtype,
  _item.xobsolete AS xobsolete
FROM acesobj_item AS _item
LEFT OUTER JOIN acesobj AS _sobj ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fagl_tldgrp_map ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN finsc_ledger ON /* join condition not captured in parsed metadata */
INNER JOIN tace_itemtypel ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tacc_trgt_ldgr ON /* join condition not captured in parsed metadata */
INNER JOIN tace_combination ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): acesobj_item
;