Faa_V_Anlab

@AbapCatalog.sqlViewName: 'FAAV_V_ANLAB'
@EndUserText.label: 'Kompatibilitaets-View fuer View V_ANLAB'

@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED

define view Faa_V_Anlab

as select from anla     as anla

    inner join Faa_Anep as anep

    on anla.mandt = anep.mandt
   and anla.bukrs = anep.bukrs
   and anla.anln1 = anep.anln1
   and anla.anln2 = anep.anln2

    inner join anlz     as anlz

    on anla.mandt = anlz.mandt
   and anla.bukrs = anlz.bukrs
   and anla.anln1 = anlz.anln1
   and anla.anln2 = anlz.anln2

    inner join Faa_Anek as anek

    on anek.mandt = anep.mandt
   and anek.bukrs = anep.bukrs
   and anek.anln1 = anep.anln1
   and anek.anln2 = anep.anln2
   and anek.gjahr = anep.gjahr
   and anek.lnran = anep.lnran


    { key anep.mandt,
      key anep.bukrs,
      key anep.anln1,
      key anep.anln2,
      key anep.gjahr,
      key anep.lnran,
      key anep.afabe,
      key anep.zujhr as anepzujhr,
      key anep.zucod,
      key anlz.bdatu,
      anla.anlkl,
      anla.gegst,
      anla.anlar,
      anla.ernam,
      anla.erdat,
      anla.aenam,
      anla.aedat,
      anla.xloev,
      anla.xspeb,
      anla.felei,
      anla.ktogr,
      anla.xopvw,
      anla.anltp,
      anla.zujhr,
      anla.zuper,
      anla.zugdt,
      anla.aktiv,
      anla.abgdt,
      anla.deakt,
      anla.gplab,
      anla.bstdt,
      anla.ord41,
      anla.ord42,
      anla.ord43,
      anla.ord44,
      anla.anlue,
      anla.zuawa,
      anla.aneqk,
      anla.aneqs,
      anla.lifnr,
      anla.land1,
      anla.liefe,
      anla.herst,
      anla.eigkz,
      anla.aibn1,
      anla.aibn2,
      anla.aibdt,
      anla.urjhr,
      anla.urwrt,
      anla.antei,
      anla.projn,
      anla.eaufn,
      anla.meins,
      anla.menge,
      anla.typbz,
      anla.izwek,
      anla.inken,
      anla.ivdat,
      anla.invzu,
      anla.vmgli,
      anla.xvrmw,
      anla.wrtma,
      anla.ehwrt,
      anla.aufla,
      anla.ehwzu,
      anla.ehwnr,
      anla.gruvo,
      anla.grein,
      anla.grbnd,
      anla.grblt,
      anla.grlfd,
      anla.flurk,
      anla.flurn,
      anla.fiamt,
      anla.stadt,
      anla.grund,
      anla.feins,
      anla.grufl,
      anla.invnr,
      anla.vbund,
      anla.spras,
      anla.txt50,
      anla.txa50,
      anla.xltxid,
      anla.xverid,
      anla.xtchid,
      anla.xkalid,
      anla.xherid,
      anla.xleaid,
      anla.leafi,
      anla.lvdat,
      anla.lkdat,
      anla.leabg,
      anla.lejar,
      anla.leper,
      anla.lryth,
      anla.legeb,
      anla.lbasw,
      anla.lkauf,
      anla.lmzin,
      anla.lzins,
      anla.ltzbw,
      anla.lkuza,
      anla.lkuzi,
      anla.llavb,
      anla.leanz,
      anla.lvtnr,
      anla.letxt,
      anla.xaktiv,
      anla.anupd,
      anla.lblnr,
      anla.xv0dt,
      anla.xv0nm,
      anla.xv1dt,
      anla.xv1nm,
      anla.xv2dt,
      anla.xv2nm,
      anla.xv3dt,
      anla.xv3nm,
      anla.xv4dt,
      anla.xv4nm,
      anla.xv5dt,
      anla.xv5nm,
      anla.xv6dt,
      anla.xv6nm,
      anla.aimmo,
      anla.objnr,
      anla.leart,
      anla.lvors,
      anla.gdlgrp,
      anla.posnr,
      anla.xerwrt,
      anla.xafabch,
      anla.xanlgr,
      anla.xinvm,
      anla.sernr,
      anla.umwkz,
      anla.lrvdat,
      anla.has_tddp,
      anla.last_reorg_date,
      anla.ldt_date,
      anlz.adatu,
      anlz.kostl,
      anlz.werks,
      anlz.gsber,
      anlz.lstar,
      anlz.msfak,
      anlz.xstil,
      anlz.stort,
      anlz.caufn,
      anlz.plan1,
      anlz.plan2,
      anlz.raumn,
      anlz.iaufn,
      anlz.iproj,
      anlz.tplkz,
      anlz.tplnr,
      anlz.txjcd,
      anlz.ipsnr,
      anlz.kfzkz,
      anlz.pernr,
      anlz.kostlv,
      anlz.geber,
      anlz.fkber,
      anlz.grant_nbr,
      anlz.fistl,
      anlz.geber2,
      anlz.fkber2,
      anlz.grant_nbr2,
      anlz.fistl2,
      anlz.imkey,
      anlz.ps_psp_pnr2,
      anep.bwasl,
      anek.budat,
      anek.monat,
      anlz.budget_pd,
      anlz.budget_pd2,
      anlz.segment,
      anlz.prctr }

       
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAA_ANEK",
"FAA_ANEP",
"ANLA",
"ANLZ"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/