fisvd_glacct_coa

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 fisvd_glacct_coa.
-- 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: FISV_GLACCT_COA

CREATE VIEW fisvd_glacct_coa AS
SELECT
  ska1.ktopl AS ktopl,
  ska1.saknr AS saknr,
  ska1.xbilk AS xbilk,
  ska1.sakan AS sakan,
  ska1.bilkt AS bilkt,
  ska1.erdat AS erdat,
  ska1.ernam AS ernam,
  ska1.gvtyp AS gvtyp,
  ska1.ktoks AS ktoks,
  ska1.mustr AS mustr,
  ska1.vbund AS vbund,
  ska1.xloev AS xloev,
  ska1.xspea AS xspea,
  ska1.xspeb AS xspeb,
  ska1.xspep AS xspep,
  ska1.func_area AS func_area,
  t004.kktpl AS kktpl,
  t030.konts AS konts,
  case ska1.xbilk when 'X' then '' else 'X' end as xplkt AS xbilkwhenXthenelseXendasxplkt
INNER JOIN t004 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t030 ON /* join condition not captured in parsed metadata */
;