FMUSFGA_FROM_ACDOCA_CCFWD

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 FMUSFGA_FROM_ACDOCA_CCFWD.
-- 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: FMUSFGA_ACDOCCV

CREATE VIEW FMUSFGA_FROM_ACDOCA_CCFWD AS
SELECT
  gl_sirid,
  rldnr,
  rrcty,
  rvers,
  ryear,
  rtcur,
  drcrk,
  poper,
  docct,
  docnr,
  docln,
  rbukrs,
  racct,
  rbusa,
  rprctr,
  rcntr,
  rprojk,
  rfarea,
  acdoca.rfund AS rfund
FROM FMUSFGA_COMPAT
INNER JOIN fmfg_uj_activ AS activation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN finsc_period AS _finsc_period_0 ON _finsc_period_0.fiscal_year_variant = acdoca.periv AND _finsc_period_0.fiscal_year = acdoca.ryear AND _finsc_period_0.fiscal_period = '001'  -- association [0..1]
-- UNION ALL with additional select branch(es): acdoca
;