Faa_Sil_Doc

@AbapCatalog.sqlViewName: 'faav_sil_doc'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Belege, die über FI-AA nachgebucht werden'

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

define view Faa_Sil_Doc 

// select INTEGRATED DOCUMENTS 

// ========================

  as select distinct from Faa_Sil_Doc_Int as a1

    { a1.rclnt      as rclnt,
      a1.rldnr      as rldnr,
      a1.rbukrs     as rbukrs,
      a1.gjahr      as gjahr,
      a1.belnr      as belnr,
      a1.awtyp      as awtyp,
      a1.awsys      as awsys,
      a1.awref      as awref,
      a1.aworg      as aworg,
      a1.awkey      as awkey,       
      a1.integrated as integrated,
      a1.ldgrp      as ldgrp,
      'A'           as doctype,
      ' '           as statistic }

  union all
  
// select None INTEGRATED DOCUMENTS 

// ========================

  select distinct from Faa_Sil_Awkey as a 
    
    // right LDGRP

    inner join t093c                 as l1 
      on  a.rclnt  = l1.mandt
      and a.rbukrs = l1.bukrs
     
    inner join t093                  as l2
      on  l1.mandt = l2.mandt
      and l1.afapl = l2.afapl
    
     inner join fagl_tldgrp_map      as l3
       on  l2.mandt     = l3.mandt
       and l2.ldgrp_gl  = l3.ldgrp   
       and a.rldnr      = l3.rldnr
       and l3.represent = 'X'        

    // right document header 

    inner join bkpf                  as b
      on  a.rclnt  = b.mandt
      and a.rbukrs = b.bukrs
      and a.gjahr  = b.gjahr
      and a.awtyp  = b.awtyp
      and a.awkey  = b.awkey
      and a.awsys  = b.awsys  
      and b.ldgrp  = l3.ldgrp 
  
    left outer join Faa_Sil_Doc_Int  as int
      on  a.rclnt  = int.rclnt
      and a.rbukrs = int.rbukrs
      and a.gjahr  = int.gjahr
      and a.awtyp  = int.awtyp
      and a.awsys  = int.awsys      
      and a.awref  = int.awref
      and a.aworg  = int.aworg  
      and a.awkey  = int.awkey
      
    { a.rclnt     as rclnt,
      a.rldnr     as rldnr,
      a.rbukrs    as rbukrs,
      a.gjahr     as gjahr,
      b.belnr     as belnr,
      a.awtyp     as awtyp,
      a.awsys     as awsys,
      a.awref     as awref,
      a.aworg     as aworg,
      a.awkey     as awkey,
      ' '         as integrated,
      b.ldgrp     as ldgrp,
      'A'         as doctype,
      ' '         as statistic }
      
    where ( a.awtyp   <> 'AMDP'                       )
      and ( int.awtyp =  'AUAK' or int.rbukrs is null )         
          
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAA_SIL_AWKEY",
"FAA_SIL_DOC_INT",
"BKPF",
"FAGL_TLDGRP_MAP",
"T093",
"T093C"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/