Kkag_Acdoca_View

@AbapCatalog.sqlViewName: 'KKAGACDOCA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Acdoca View'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.serviceQuality: #P

//Used for optimization options 

//- 06, View ACDOCA + TKKAZ: Import as Necessary

//Used in view Kkag_Acdoca_Tkkaz_View0 

//Selects from Acdoca 


define view Kkag_Acdoca_View 

as select 
  a.rldnr as rldnr,
  rbukrs,
  kokrs,
  ktopl,
  objnr, 
  gjahr, 
  racct, 
  hrkft, 
  hkgrp,
  a.vrgng as vrgng, 
//rassc,  

//sbusa,  

  co_beknz, 
  rwcur, 
  runit, 
  beltp, 
  bemot,
//parob1, 

//uspob, 

  ukostl,
  ulstar,
  uprznr,
  poper, 
  fiscyearper,
  cast(fiscyearper as abap.int4 ) as fiscyearper_int4,
  sum(ksl) as ksl, 
  sum(kfsl) as kfsl, 
  sum(hsl) as hsl, 
  sum(wsl) as wsl, 
  sum(msl) as msl 
//sum(mfsl) as mfsl               

from acdoca as a 
//inner join finsc_cmp_versnc as v on  a.rbukrs = v.bukrs and a.rldnr  = v.rldnr and v.versn  = '000'   --- select only the ledger which is assigned to version 000;                                                             

inner join t000 as b on a.rclnt = b.mandt                                                  
where ( a.co_belnr <> '' and a.co_buzei <> '000' and not ( accasty is null or accasty = '' ) or ( mig_source = 'C' and bstat = 'C' ) )  
  and ( a.mig_source <> ' ' or ( a.mig_source = ' ' and not ( a.bstat = 'C' and a.poper = '000' ) ) )                 
  and ( a.logsyso = '' or a.logsyso = b.logsys )
group by 
  a.rldnr,
  rbukrs,
  kokrs,
  ktopl,
  objnr, 
  gjahr, 
  racct, 
  hrkft, 
  hkgrp,
  a.vrgng, 
//rassc, 

//sbusa, 

  co_beknz, 
  rwcur, 
  runit, 
  beltp, 
  bemot,
//parob1, 

//uspob, 

  ukostl,
  ulstar,
  uprznr,
  poper, 
  fiscyearper           
  ;                     
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCA",
"T000"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/