fisvd_glacct_comp

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_comp.
-- 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_COMP
-- Parameters: P_XKTOP2 : abap.char( 1 )

CREATE VIEW fisvd_glacct_comp AS
SELECT
  t001.ktopl AS ktopl,
  skb1.saknr AS saknr,
  skb1.bukrs AS bukrs,
  skb1.mitkz AS mitkz,
  skb1.xkres AS xkres,
  skb1.xopvw AS xopvw,
  skb1.xspeb AS xspeb,
  skb1.zuawa AS zuawa,
  skb1.altkt AS altkt,
  t001.butxt AS butxt,
  t001.land1 AS land1,
  t001.waers AS waers,
  t001.periv AS periv,
  t001.kkber AS kkber,
  t001.ktop2 AS ktop2,
  skb1.fdgrv AS fdgrv,
  skb1.fstag AS fstag,
  skb1.xgkon AS xgkon,
  skb1.xloeb AS xloeb,
  skb1.xmitk AS xmitk,
  skb1.begru AS begru,
  skb1.busab AS busab,
  skb1.ernam AS ernam_skb1,
  skb1.erdat AS erdat_skb1,
  skb1.fdlev AS fdlev,
  skb1.hbkid AS hbkid,
  skb1.hktid AS hktid,
  skb1.mwskz AS mwskz,
  skb1.waers AS waers_skb1,
  skb1.xintb AS xintb,
  skb1.infky AS infky,
  skb1.xlgclr AS xlgclr,
  skb1.bewgp AS bewgp,
  skb1.datlz AS datlz,
  skb1.kdfsl AS kdfsl,
  skb1.togru AS togru,
  skb1.vzskz AS vzskz,
  skb1.wmeth AS wmeth,
  skb1.xnkon AS xnkon,
  skb1.xsalh AS xsalh,
  skb1.zindt AS zindt,
  skb1.zinrt AS zinrt,
  skb1.xmwno AS xmwno,
  fisvd_glacct_cur.ktext AS ktext,
  fisvd_glacct_cnty.landx AS landx,
  tka02.kokrs AS kokrs,
  $parameters.P_XKTOP2 AS xktop2
FROM skb1
LEFT OUTER JOIN fisvd_glacct_cur ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fisvd_glacct_cnty ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tka02 ON /* join condition not captured in parsed metadata */
;