Faa_Rec_Anea_Base

@AbapCatalog.sqlViewName: 'FAAV_REC_ANEA'
@EndUserText.label: 'Reconciliation ANEA (base Version)'

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P

define view Faa_Rec_Anea_Base as

select 
from        anea as anea 
inner join  anla as anla                -- 2270905
        on  anla.bukrs = anea.bukrs
        and anla.anln1 = anea.anln1
        and anla.anln2 = anea.anln2
        { 
            anea.mandt,
            anea.bukrs,
            anea.anln1,
            anea.anln2,
            anea.gjahr,
            anea.lnran,
            anea.afabe,
            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
        }
    where anla.xanlgr = ''             --2270905 Check assets only and not asset groups
        
  
union all 
        
select
from        faav_anea as anea
inner join  anla as anla                 --2270905
        on  anla.bukrs = anea.bukrs
        and anla.anln1 = anea.anln1
        and anla.anln2 = anea.anln2
        {
          anea.mandt,
          anea.bukrs,
          anea.anln1,
          anea.anln2,
          anea.gjahr,
          anea.lnran,
          anea.afabe,
        - 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  
        }
    where anla.xanlgr = ''              --2270905 Check assets only and not asset groups
    
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ANEA",
"ANLA",
"FAAV_ANEA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/