Faa_Rec_Anlp_Base

@AbapCatalog.sqlViewName: 'FAAV_REC_ANLP'
@EndUserText.label: 'Reconciliation ANLP (Base View)'

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

define view Faa_Rec_Anlp_Base

as select from  t093c as t093c

     inner join t093 as t093
                on t093.afapl = t093c.afapl
               and buhbkt <> '0'

     inner join anlp as anlp
                on anlp.bukrs   =  t093c.bukrs
               and anlp.afaber  =  t093.afaber

  { anlp.mandt  as mandt,
    anlp.bukrs  as bukrs,
    anlp.gjahr  as gjahr,
    case when anlp.peraf = '999'                    //2197244 

         then cast ( concat( '0', anlp.afbnr ) as abap.numc( 3 ) )          // 2204679

         else anlp.peraf end as peraf,
    anlp.afbnr  as afbnr,                          //2246616         

    anlp.anln1  as anln1,
    anlp.anln2  as anln2,
    anlp.afaber as afaber,
    anlp.aufwz  as aufwz,
    anlp.nafaz  as nafaz,
    anlp.safaz  as safaz,
    anlp.aafaz  as aafaz,
    anlp.mafaz  as mafaz,
    anlp.zinsz  as zinsz,
    anlp.aufnz  as aufnz }

union all

select from  t093c as t093c

     inner join t093 as t093
                on t093.afapl = t093c.afapl
               and buhbkt <> '0'

     inner join faav_anlp as mig
                on mig.bukrs   =  t093c.bukrs
               and mig.afaber  =  t093.afaber

  { mig.mandt  as mandt,
    mig.bukrs  as bukrs,
    mig.gjahr  as gjahr,
    mig.peraf  as peraf,
    mig.afbnr  as afbnr,     
    mig.anln1  as anln1,
    mig.anln2  as anln2,
    mig.afaber as afaber,
  - mig.aufwz  as aufwz,
  - mig.nafaz  as nafaz,
  - mig.safaz  as safaz,
  - mig.aafaz  as aafaz,
  - mig.mafaz  as mafaz,
  - mig.zinsz  as zinsz,
  - mig.aufnz  as aufnz }
    
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ANLP",
"T093",
"T093C",
"FAAV_ANLP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/