FGL_BCF_RUN_INFO

@AbapCatalog.sqlViewName: 'FGLV_BCF_INFO'
@EndUserText.label: 'Balance Carry Forward: Run Information'

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MIXED
define view FGL_BCF_RUN_INFO as 
  select from fins_bcf_run as r
    left outer join fins_bcf_package as p
      on r.run_id = p.run_id 
    left outer join finsc_ld_cmp as l
      on p.rldnr = l.rldnr 
      and p.bukrs = l.bukrs 
{ 
 -- key fields
    key r.run_id, 
    key p.rldnr, 
    key p.bukrs, 
    key p.seqno,
    
 -- settings  
    r.from_year, 
    r.to_year,
    r.xtestmode, 
    r.xreacc, 
    r.xinit, 
    r.xinit_aa, 
    r.xactivate_only, 
    
 -- status        
    r.uname, 
    r.timestamp, 
    r.appl_log_ext_id, 
    r.appl_log_number,
    p.xinitial_run, 
    p.xsuccess, 
    p.xinitialized, 
    p.xdelta_needed,
    l.periv,
    
 -- validation core ledger
    p.dbcnt_pl, 
    p.dbcnt_bs, 
    p.num_imsg, 
    p.num_smsg, 
    p.num_wmsg, 
    p.num_emsg, 
    
  -- validation technical ledger
    p.tl_ledger,
    p.tl_dbcnt_pl, 
    p.tl_dbcnt_bs, 
    p.tl_num_imsg, 
    p.tl_num_smsg, 
    p.tl_num_wmsg, 
    p.tl_num_emsg    

}    
  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINSC_LD_CMP",
"FINS_BCF_PACKAGE",
"FINS_BCF_RUN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/