FAA_SIL_DOC_INT

CDS View

Belege, die über FI-AA integriert nachzubuchen sind

FAA_SIL_DOC_INT is a CDS View in S/4HANA. Belege, die über FI-AA integriert nachzubuchen sind. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
Faa_Sil_Doc view left_outer Belege, die über FI-AA nachgebucht werden
@AbapCatalog.sqlViewName: 'FAAV_SIL_DOC_INT'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Belege, die über FI-AA integriert nachzubuchen sind'

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

define view Faa_Sil_Doc_Int 
  
// select INTEGRATED DOCUMENTS 

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

  as select distinct from Faa_Sil_Awkey as a
     
    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  = '' 
      
    { 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, 
      'X'         as integrated,
      b.ldgrp     as ldgrp }
      
    where ( a.awtyp <> 'AMDP' )          
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAA_SIL_AWKEY",
"BKPF"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/