Faa_Rec_Anlp1_Sum

@AbapCatalog.sqlViewName: 'FAAV_REC_ANLP1_S'
@EndUserText.label: 'Reconciliation ANLP vs ANLC (Result Set)'

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

define view Faa_Rec_Anlp1_Sum

as select from Faa_Rec_Anlp1_Base as b

  inner join anla as a
     on a.mandt = b.mandt
    and a.bukrs = b.bukrs
    and a.anln1 = b.anln1
    and a.anln2 = b.anln2

  inner join t093c  as t093c                                     -- 2318770
     on b.bukrs     =  t093c.bukrs
  inner join t093   as t093
     on t093c.afapl =  t093.afapl
    and b.afaber    =  t093.afaber                               -- 2324001


  { key b.mandt  as mandt,
    key b.bukrs  as bukrs,
    key b.anln1  as anln1,
    key b.anln2  as anln2,
    key a.ktogr  as ktogr,
    key b.gjahr  as gjahr,
    key b.afaber as afaber,

    min( b.peraf ) as peraf, // 999 for the case when ANLP doesn't exist

    sum( b.nafaz ) as nafaz,
    sum( b.safaz ) as safaz,
    sum( b.aafaz ) as aafaz,
    sum( b.mafaz ) as mafaz,
    sum( b.aufwz ) as aufwz,
    sum( b.aufnz ) as aufnz,
    sum( b.zinsz ) as zinsz }

    where t093.xstore = 'X'                                       -- 2318770: exclude derived areas

    group by b.mandt, b.bukrs, b.anln1, b.anln2, a.ktogr, b.gjahr, b.afaber

having sum( b.nafaz ) <> 0
    or sum( b.safaz ) <> 0
    or sum( b.aafaz ) <> 0
    or sum( b.mafaz ) <> 0
    or sum( b.aufwz ) <> 0
    or sum( b.aufnz ) <> 0
    or sum( b.zinsz ) <> 0


         
 
   
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAA_REC_ANLP1_BASE",
"ANLA",
"T093",
"T093C"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/