FAA_MIG_ANEP

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_MIG_ANEP.
-- 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_MIG_ANEP

CREATE VIEW FAA_MIG_ANEP AS
SELECT
  anla.bukrs AS bukrs,
  anla.anln1 AS anln1,
  anla.anln2 AS anln2,
  anla.ktogr AS ktogr,
  anla.xanlgr AS xanlgr,
  anla.anlkl AS anlkl,
  anlb.anlgr AS anlgr,
  anlb.anlgr2 AS anlgr2,
  anlz.bdatu AS bdatu,
  anlz.adatu AS adatu,
  anlz.kostl AS kostl,
  anlz.gsber AS gsber,
  anlz.caufn AS caufn,
  anlz.iaufn AS iaufn,
  anlz.fistl AS fistl,
  anlz.geber AS geber,
  anlz.fkber AS fkber,
  anlz.grant_nbr AS grant_nbr,
  anlz.geber2 AS geber2,
  anlz.fkber2 AS fkber2,
  anlz.grant_nbr2 AS grant_nbr2,
  anlz.fistl2 AS fistl2,
  anlz.imkey AS imkey,
  anlz.ps_psp_pnr2 AS ps_psp_pnr2,
  anlz.budget_pd AS budget_pd,
  anlz.budget_pd2 AS budget_pd2,
  anlz.segment AS segment,
  anlz.prctr AS prctr,
  anek.ldgrp AS ldgrp,
  anek.gjahr AS gjahr,
  anek.monat AS poper,
  anek.lnran AS lnran,
  anek.awtyp AS awtyp,
  anek.aworg AS aworg,
  anek.awsys AS awsys,
  anek.budat AS budat,
  anek.belnr AS belnr,
  cast (concat ('000' , anek.buzei ) as abap.numc(6) ) AS awitgrp,
  anek.bldat AS bldat,
  anek.bzdat AS bzdat,
  anek.anlu1 AS panl1,
  anek.anlu2 AS panl2,
  anek.glvor AS glvor,
  anek.vorgn AS vorgn,
  anek.sgtxt AS sgtxt,
  anek.objid AS objid,
  anek.obart AS obart,
  anek.ebeln AS ebeln,
  anek.ebelp AS ebelp,
  anek.zuonr AS zuonr,
  anek.cpudt AS cpudt,
  anek.cputm AS cputm,
  anek.tcode AS tcode,
  anek.usnam AS usnam,
  anek.xblnr AS xblnr,
  anek.xantei AS xantei,
  case when anek.xantei = '5' then ' ' else 'X' end as xfibeleg AS xantei5thenelseXendasxfibeleg,
  anep.afabe AS afabe,
  anep.lnsan AS lnsan,
  anep.augln AS augln,
  anep.bwasl AS bwasl,
  anep.xantw AS xantw,
  t001.ktopl AS ktopl,
  t001.xnegp AS xnegp,
  t093.buhbkt AS buhbkt,
  t093.ldgrp_gl AS ldgrp_gl,
  t093c.afapl AS afapl,
  t093c.xanueb AS xanueb,
  t093b.waers AS waers,
  t093b1.waers AS waers1,
  t093a1.curtp AS curt2,
  t093b2.waers AS waers2,
  t093a2.curtp AS curt3,
  concat( tabwg.bwatyp, tabwg.gitcol) AS MOVCAT,
  tabw.bwakon AS bwakon,
  tabwg.xzugne AS xzugne,
  case when tabwg.xbnafa = 'X' then 'O' when tabwg.xbsafa = 'X' then 'S' when tabwg.xbaafa = 'X' then 'A' when tabwg.xbmafa = 'X' then 'M' else '' end as afatyp AS xbmafaXthenMelseendasafatyp,
  anep.anbtr AS anbtr,
  anea.aufwv AS aufwv,
  anea.invzv AS invzv,
  anea.nafav AS nafav,
  anea.safav AS safav,
  anea.aafav AS aafav,
  anea.mafav AS mafav,
  anea.aufnv AS aufnv,
  anea.aufwl AS aufwl,
  anea.invzl AS invzl,
  anea.nafal AS nafal,
  anea.safal AS safal,
  anea.aafal AS aafal,
  anea.mafal AS mafal,
  anea.aufnl AS aufnl,
  anea.erlbt AS erlbt,
  anea.verko AS verko,
  anea.sanwv AS sanwv,
  anep1.anbtr AS anbtr1,
  anea1.aufwv AS aufwv1,
  anea1.invzv AS invzv1,
  anea1.nafav AS nafav1,
  anea1.safav AS safav1,
  anea1.aafav AS aafav1,
  anea1.mafav AS mafav1,
  anea1.aufnv AS aufnv1,
  anea1.aufwl AS aufwl1,
  anea1.invzl AS invzl1,
  anea1.nafal AS nafal1,
  anea1.safal AS safal1,
  anea1.aafal AS aafal1,
  anea1.mafal AS mafal1,
  anea1.aufnl AS aufnl1,
  anea1.erlbt AS erlbt1,
  anea1.verko AS verko1,
  anea1.sanwv AS sanwv1,
  anep2.anbtr AS anbtr2,
  anea2.aufwv AS aufwv2,
  anea2.invzv AS invzv2,
  anea2.nafav AS nafav2,
  anea2.safav AS safav2,
  anea2.aafav AS aafav2,
  anea2.mafav AS mafav2,
  anea2.aufnv AS aufnv2,
  anea2.aufwl AS aufwl2,
  anea2.invzl AS invzl2,
  anea2.nafal AS nafal2,
  anea2.safal AS safal2,
  anea2.aafal AS aafal2,
  anea2.mafal AS mafal2,
  anea2.aufnl AS aufnl2,
  anea2.erlbt AS erlbt2,
  anea2.verko AS verko2,
  anea2.sanwv AS sanwv2
LEFT OUTER JOIN anep ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN anea ON /* join condition not captured in parsed metadata */
INNER JOIN tabw ON /* join condition not captured in parsed metadata */
INNER JOIN tabwg ON /* join condition not captured in parsed metadata */
INNER JOIN anla ON /* join condition not captured in parsed metadata */
INNER JOIN anlb ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN anlz ON /* join condition not captured in parsed metadata */
INNER JOIN t093c ON /* join condition not captured in parsed metadata */
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 t001 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t001a ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t093a AS t093a1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t093b AS t093b1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN anep AS anep1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN anea AS anea1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t093a AS t093a2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t093b AS t093b2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN anep AS anep2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN anea AS anea2 ON /* join condition not captured in parsed metadata */
;