fisvd_glacct_all

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_all.
-- 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_ALL
-- Parameters: P_MANDT : mandt, P_BUKRS : bukrs, P_KTOPL : ktopl, P_XKTOP2 : abap.char( 1 )

CREATE VIEW fisvd_glacct_all AS
SELECT
  fisvd_glacct_coa.ktopl AS ktopl,
  fisvd_glacct_coa.saknr AS saknr,
  fisvd_glacct_coa.xbilk AS xbilk,
  fisvd_glacct_coa.xplkt AS xplkt,
  fisvd_glacct_coa.sakan AS sakan,
  fisvd_glacct_coa.bilkt AS bilkt,
  fisvd_glacct_coa.erdat AS erdat,
  fisvd_glacct_coa.ernam AS ernam,
  fisvd_glacct_coa.gvtyp AS gvtyp,
  fisvd_glacct_coa.ktoks AS ktoks,
  fisvd_glacct_coa.mustr AS mustr,
  fisvd_glacct_coa.vbund AS vbund,
  fisvd_glacct_coa.xloev AS xloev,
  fisvd_glacct_coa.xspea AS xspea,
  fisvd_glacct_coa.xspeb AS xspeb,
  fisvd_glacct_coa.xspep AS xspep,
  fisvd_glacct_coa.func_area AS func_area,
  fisvd_glacct_coa.kktpl AS kktpl,
  fisvd_glacct_comp.bukrs AS bukrs,
  fisvd_glacct_comp.mitkz AS mitkz,
  fisvd_glacct_comp.xkres AS xkres,
  fisvd_glacct_comp.xopvw AS xopvw,
  fisvd_glacct_comp.xspeb AS xspeb_skb1,
  fisvd_glacct_comp.zuawa AS zuawa,
  fisvd_glacct_comp.altkt AS altkt,
  fisvd_glacct_comp.butxt AS butxt,
  fisvd_glacct_comp.land1 AS land1,
  fisvd_glacct_comp.waers AS waers,
  fisvd_glacct_comp.periv AS periv,
  fisvd_glacct_comp.kkber AS kkber,
  fisvd_glacct_comp.ktop2 AS ktop2,
  fisvd_glacct_comp.fdgrv AS fdgrv,
  fisvd_glacct_comp.fstag AS fstag,
  fisvd_glacct_comp.xgkon AS xgkon,
  fisvd_glacct_comp.xloeb AS xloeb,
  fisvd_glacct_comp.xmitk AS xmitk,
  fisvd_glacct_comp.begru AS begru,
  fisvd_glacct_comp.busab AS busab,
  fisvd_glacct_comp.ernam_skb1 AS ernam_skb1,
  fisvd_glacct_comp.erdat_skb1 AS erdat_skb1,
  fisvd_glacct_comp.fdlev AS fdlev,
  fisvd_glacct_comp.hbkid AS hbkid,
  fisvd_glacct_comp.hktid AS hktid,
  fisvd_glacct_comp.mwskz AS mwskz,
  fisvd_glacct_comp.waers AS waers_skb1,
  fisvd_glacct_comp.xintb AS xintb,
  skat_ktopl.txt50 AS saknr_txt50,
  skat_kktpl.txt50 AS bilkt_txt50,
  skat_ktop2.txt50 AS altkt_txt50,
  t004t_ktopl.ktplt AS ktopl_name,
  t004t_kktpl.ktplt AS kktpl_name,
  t004t_ktop2.ktplt AS ktop2_name,
  tfkbt.fkbtx AS fkbtx,
  fisvd_glacct_coa.konts AS konts,
  fisvd_glacct_comp.infky AS infky,
  fisvd_glacct_comp.xlgclr AS xlgclr,
  fisvd_glacct_comp.bewgp AS bewgp,
  fisvd_glacct_comp.datlz AS datlz,
  fisvd_glacct_comp.kdfsl AS kdfsl,
  fisvd_glacct_comp.togru AS togru,
  fisvd_glacct_comp.vzskz AS vzskz,
  fisvd_glacct_comp.wmeth AS wmeth,
  fisvd_glacct_comp.xnkon AS xnkon,
  fisvd_glacct_comp.xsalh AS xsalh,
  fisvd_glacct_comp.zindt AS zindt,
  fisvd_glacct_comp.zinrt AS zinrt,
  fisvd_glacct_comp.xmwno AS xmwno
LEFT OUTER JOIN fisvd_glacct_comp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN skat AS skat_ktopl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN skat AS skat_kktpl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN skat AS skat_ktop2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t004t AS t004t_ktopl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t004t AS t004t_kktpl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t004t AS t004t_ktop2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN tfkbt ON /* join condition not captured in parsed metadata */
;