FAA_CFG_AFABER

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 FAA_CFG_AFABER.
-- 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: FAAV_CFG_AFABER

CREATE VIEW FAA_CFG_AFABER AS
SELECT
  t093c.bukrs AS bukrs,
  t093.afaber AS afaber,
  t093c.afapl AS afapl,
  t093c.lgjahr AS lgjahr,
  t093c.bukrsn AS bukrsn,
  t093c.aprof AS aprof,
  t093c.varbzd AS varbzd,
  t093c.afblrt AS afblrt,
  t093c.xrumpf AS xrumpf,
  t093c.xnoskonto AS xnoskonto,
  t093c.revdmeth AS revdmeth,
  t093c.xrebuw AS xrebuw,
  t093c.xvrsku AS xvrsku,
  t093c.xzorg AS xzorg,
  t093c.bkrakt AS bkrakt,
  t093c.monmit AS monmit,
  t093c.xanueb AS xanueb,
  t093.xstore AS xstore,
  t093.buhbkt AS buhbkt,
  t093.ldgrp_gl AS ldgrp,
  t093.xafaber AS xafaber,
  t093.xberep AS xberep,
  t093.gafaber AS gafaber,
  t093.vzansw AS vzansw,
  t093.vzrest AS vzrest,
  t093.vzinvz AS vzinvz,
  t093.vzawma AS vzawma,
  t093.vznafa AS vznafa,
  t093.vzsafa AS vzsafa,
  t093.vzaafa AS vzaafa,
  t093.vzindw AS vzindw,
  t093.vzzins AS vzzins,
  t093.vzinda AS vzinda,
  t093.corrbe AS corrbe,
  t093.abwber AS abwber,
  t093.abvor1 AS ABVOR1,
  t093.afabe1 AS afabe1,
  t093.antei1 AS ANTEI1,
  t093.abvor2 AS ABVOR2,
  t093.afabe2 AS AFABE2,
  t093.antei2 AS ANTEI2,
  t093.abvor3 AS ABVOR3,
  t093.afabe3 AS AFABE3,
  t093.antei3 AS ANTEI3,
  t093.abvor4 AS ABVOR4,
  t093.afabe4 AS AFABE4,
  t093.antei4 AS ANTEI4,
  t093a.afabe AS afabe,
  case t093.xstore when ' ' then ' ' else t093a.wrtafb end AS wrtafb,
  case t093.xstore when ' ' then ' ' else t093a.parafb end AS parafb,
  case t093.xstore when ' ' then ' ' else t093a.curtp end AS curtp,
  t093a.versn AS versn,
  t093a.bertyp AS bertyp,
  case t093.xstore when ' ' then ' ' else t093a.xwrtid end AS xwrtid,
  case t093.xstore when ' ' then ' ' else t093a.xindid end AS xindid,
  t093a.xumhis AS xumhis,
  case when quant.afabe is null and t093.afaber = '01' then 'X' when quant.afabe = t093.afaber then 'X' else '' end as xmenge AS afaberthenXelseendasxmenge,
  t093a.afarfo AS afarfo,
  t093b.waers AS waers,
  t093b.runden AS runden,
  t093b.rndahk AS RNDAHK,
  t093b.basrnd AS BASRND,
  t093b.metrnd AS METRND,
  t093b.abgja AS ABGJA,
  t093b.xakpl AS XAKPL,
  t093b.periv AS periv,
  t093b.kzrbwb_afabe AS KZRBWB_AFABE,
  ld_cmp.rldnr AS rep_ledger,
  ld_cmp.curtpk AS curtpk,
  ld_cmp.curtpo AS curtpo,
  ld_cmp.curtpv AS curtpv,
  ld_cmp.curtpb AS curtpb,
  ld_cmp.curtpc AS curtpc,
  ld_cmp.curtpd AS curtpd,
  ld_cmp.curtpe AS curtpe,
  ld_cmp.curtpf AS curtpf,
  ld_cmp.curtpg AS curtpg,
  ld_cmp.periv AS periv_ld,
  case t093.afabe1 when t093a.afabe then t093a.afabe else t093.afaber end AS base_afabe
INNER JOIN t093 ON /* join condition not captured in parsed metadata */
INNER JOIN t093a ON /* join condition not captured in parsed metadata */
INNER JOIN t093b ON /* join condition not captured in parsed metadata */
INNER JOIN fagl_tldgrp_map AS tldgrp_map ON /* join condition not captured in parsed metadata */
INNER JOIN finsc_ld_cmp AS ld_cmp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t093a AS quant ON /* join condition not captured in parsed metadata */
;