FINS_GL_DOCUMENT_AMT_AWITEM

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 FINS_GL_DOCUMENT_AMT_AWITEM.
-- 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: GLDOCAMAWITEM

CREATE VIEW FINS_GL_DOCUMENT_AMT_AWITEM AS
SELECT
  acdoca.rbukrs AS bukrs,
  acdoca.gjahr AS gjahr,
  acdoca.belnr AS belnr,
  acdoca.rldnr AS rldnr,
  cast('00' as curtype) AS currencyType,
  acdoca.awitem AS awitem,
  acdoca.racct AS hkont,
  acdoca.tsl AS amount,
  acdoca.rtcur AS currency,
  acdoca.docln AS docln
FROM acdoca
INNER JOIN finsc_ledger AS ledger ON /* join condition not captured in parsed metadata */
INNER JOIN finsc_ld_cmp AS currency_type ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): acdoca
;