Faa_Sil_Doc_Int

DDL: FAA_SIL_DOC_INT SQL: FAAV_SIL_DOC_INT Type: view

Belege, die über FI-AA integriert nachzubuchen sind

Faa_Sil_Doc_Int is a CDS View that provides data about "Belege, die über FI-AA integriert nachzubuchen sind" in SAP S/4HANA. It reads from 1 data source (bkpf) and exposes 12 fields.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
bkpf b inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FAAV_SIL_DOC_INT view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Belege, die über FI-AA integriert nachzubuchen sind view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

Fields (12)

KeyFieldSource TableSource FieldDescription
rclnt a rclnt
rldnr a rldnr
rbukrs a rbukrs
gjahr a gjahr
belnr bkpf belnr
awtyp a awtyp
awsys a awsys
awref a awref
aworg a aworg
awkey a awkey
integrated
ldgrp bkpf ldgrp 
@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":""
}
}*/

Learn More