FGL_GLSI_ACD

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 FGL_GLSI_ACD.
-- 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: FGLV_GLSI_ACD

CREATE VIEW FGL_GLSI_ACD AS
SELECT
  a.rclnt AS rclnt,
  a.ryear AS ryear,
  a.belnr AS docnr,
  lr.rldnr AS rldnr,
  a.rbukrs AS rbukrs,
  a.docln AS docln,
  cast(cast(a.bttype as abap.char(4)) as acti1) AS activ,
  a.rmvct AS rmvct,
  a.rtcur AS rtcur,
  a.runit AS runit,
  a.awtyp AS awtyp,
  a.rrcty AS rrcty,
  cast('001' as abap.char(3)) AS rvers,
  a.awsys AS logsys,
  a.racct AS racct,
  case when a.co_buzei <> '000' then a.racct else '' end AS cost_elem,
  a.rcntr AS rcntr,
  a.prctr AS prctr,
  a.rfarea AS rfarea,
  a.rbusa AS rbusa,
  a.kokrs AS kokrs,
  a.segment AS segment,
  a.scntr AS scntr,
  a.pprctr AS pprctr,
  a.sfarea AS sfarea,
  a.sbusa AS sbusa,
  a.rassc AS rassc,
  a.psegment AS psegment,
  a.tsl AS tsl,
  a.hsl AS hsl,
  a.msl AS msl,
  a.wsl AS wsl,
  a.fsl AS fsl,
  a.vsl AS vsl,
  a.drcrk AS drcrk,
  a.poper AS poper,
  a.rwcur AS rwcur,
  a.gjahr AS gjahr,
  a.budat AS budat,
  a.belnr AS belnr,
  a.buzei AS buzei,
  a.bschl AS bschl,
  a.bstat AS bstat,
  a.linetype AS linetype,
  a.xsplitmod AS xsplitmod,
  a.usnam AS usnam,
  a.timestamp AS timestamp,
  a._dataaging AS _dataaging,
  a.fikrs AS fikrs,
  a.rfund AS rfund,
  a.rgrant_nbr AS rgrant_nbr,
  a.rbudget_pd AS rbudget_pd,
  a.sfund AS sfund,
  a.sgrant_nbr AS sgrant_nbr,
  a.sbudget_pd AS sbudget_pd,
  a.re_bukrs AS re_bukrs,
  a.re_account AS re_account,
  a.vname AS vname,
  a.egrup AS egrup,
  a.recid AS recid,
  a.mig_source AS mig_source,
  a.mig_docln AS mig_docln,
  a.rhcur AS rhcur,
  a.rfcur AS rfcur,
  a.rvcur AS rvcur,
  a.fcsl AS fcsl,
  a.rfccur AS rfccur
FROM acdoca AS a
INNER JOIN finsc_ledger_rep AS lr ON /* join condition not captured in parsed metadata */
INNER JOIN finsc_ld_cmp AS lc ON /* join condition not captured in parsed metadata */
;